Previous Topic

Next Topic

Book Contents

Example 2

The SQL statement shown in Example 1 selects patient information for all sites that the current user can access, and filters it through a simple WHERE clause. The information is extracted by default from the InForm application database. To extract data from a customer-defined database (CDD) instead, you need to specify the DSN for the CDD, and a valid user ID and password, as shown in the following example (remember that user IDs and passwords must contain all alphabetic or all alphanumeric characters and begin with a letter. Do not use all numeric characters):

'Set a custom database connection
obj.SetCustomDB "pfstrep", "pfstuid", "pfstpid" 'DSN, userid, pwd

This statement specifies that the data should come from a customer-defined database (i.e., not the InForm application database). Note that the data is not filtered.

Send Feedback