The Preview tab page in the Database Profile Setup dialog box makes it easy to generate accurate PowerScript connection syntax in the development environment for use in your PocketBuilder application script.
As you complete the Database Profile Setup dialog box, the correct PowerScript connection syntax for each selected option is generated on the Preview tab. PocketBuilder assigns the corresponding DBParm parameter or SQLCA property name to each option and inserts quotation marks, commas, semicolons, and other characters where needed. You can copy the syntax you want from the Preview tab directly into your script.
To use the Preview tab to connect in a PocketBuilder
application:
In the Database Profile Setup dialog box for your connection, supply values for basic options (on the Connection tab) and additional database parameters and SQLCA properties (on the other tabbed pages) as required.
For information about connection parameters and the values you should supply, click Help.
Click Apply to save your settings without closing the Database Profile Setup dialog box.
Click the Preview tab.
The correct PowerScript connection syntax for each selected option displays in the Database Connection Syntax box on the Preview tab.
Select one or more lines of text in the Database Connection Syntax box and click Copy.
PocketBuilder copies the selected text to the clipboard. You can then paste this syntax into your script, modifying the default Transaction object name (SQLCA) if necessary.
Click OK.
