Summary

The SQL Script allows you to select records from the external database.

If more than one record is returned by this process, a list of records is displayed, so you can select the record that you want to validate.

1. Right-click this tab page to see the menu.
2. Select Test SQL from the menu.

This option allows you to check if the SQL statement will return a record. To complete the test you may need to include a known test value, which is detailed in the SQL Parameters tab page.

Example of SQL script

SELECT Patients.Code, Patients.FirstName, Patients.LastName, Patients.Address, Patients.City, Patients.StateOrProvince,Patients.PostalCode, Patients.Region, Patients.Country, Patients.Title, Patients.WorkPhone, Patients.Birthdate, Patients.Gender

FROM Patients

WHERE Patients.Code = (:NMPI)

Wildcard characters

Wildcard characters are not accepted in SQL.

See also

External Validation