Copying DBParm syntax from the Preview tab
The easiest way to specify DBParm parameters in a
PowerBuilder application script is to copy the DBParm syntax from the
Preview tab in the Database Profile Setup dialog box into your code,
modifying the default Transaction object name (SQLCA) if
necessary.
As you set parameters in the Database Profile Setup dialog box
in the development environment, PowerBuilder generates the correct
connection syntax on the Preview tab. Therefore, copying the syntax
directly from the Preview tab ensures that you use the correct DBParm
syntax in your code.
To copy DBParm syntax from the Preview tab into your
code:
-
On one or more tab pages in the Database Profile Setup
dialog box for your connection, supply values for any parameters
you want to set.For instructions, see Setting database parameters
in the development environment.For information about the parameters for your interface and
the values to supply, click Help. -
Click Apply to save your changes to the current tab without
closing the Database Profile Setup dialog box. -
Click the Preview tab.
The correct 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.PowerBuilder 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 code,
modifying the default Transaction object name (SQLCA) if
necessary.