Using the Preview tab to connect in a PocketBuilder application

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.

StepsTo use the Preview tab to connect in a PocketBuilder application:

  1. 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.

  2. Click Apply to save your settings without closing the Database Profile Setup dialog box.

  3. Click the Preview tab.

    The correct PowerScript connection syntax for each selected option displays in the Database Connection Syntax box on the Preview tab.

  4. 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.

    NoteODB or ODBC for DBMS value An ODBC connection profile shows “ODBC” as the value for the DBMS parameter. Only the first three characters in this string are used, so ODB and ODBC both work correctly.

  5. Click OK.