The easiest way to specify database parameters in a PocketBuilder application script is to copy the PowerScript DBParm syntax from the Preview tab in the Database Profile Setup dialog box into your script, modifying the default Transaction object name (SQLCA) if necessary.
As you set database parameters in the Database Profile Setup dialog box in the development environment, PocketBuilder generates the correct connection syntax on the Preview tab. Therefore, copying the syntax directly from the Preview tab ensures that you use the correct PowerScript DBParm syntax in your script.
To copy DBParm syntax from the Preview tab into
your script:
On one or more tab pages in the Database Profile Setup dialog box for your connection, supply values for any database parameters you want to set.
Click Apply to save your changes to the current tab without closing the Database Profile Setup dialog box.
Click the Preview tab.
The correct PowerScript DBParm syntax for each selected option displays in the Database Connection Syntax box.
Select one or more lines of text in the Database Connection Syntax box and click Copy.
PocketBuilder copies the selected text to the clipboard.
Click OK to close the Database Profile Setup dialog box.
Paste the selected text from the Preview tab into your script, modifying the default Transaction object name (SQLCA) if necessary.
