Databases Reference
In-Depth Information
Tip
Refer to Recipe 2-1 for more information on how to set up a data entry form.
3.
Add a sample record to the PaymentHistory table with the Social Security
number
123456789
. This can be done by executing the SQL in Listing 3-3.
Listing 3-3.
Creating the Sample Record in the PaymentHistory Table
INSERT INTO PAYMENTHISTORY(SOCIALSECURITYNO,AMOUNTPAID) VALUES('123456789',500)
Adding Server-side Validation
To add server-side validation to your form, follow these steps:
1.
Navigate to the Page Processing section of the Page Definition area in the
patient discharge form.
2.
Under the Validating node, right click the Validations node and click the
Create button (as shown in Figure 3-1).
Figure 3-1.
Launching the Create Validation wizard
