| Home | Previous Lesson: Transaction Options Next Lesson: Network Options |
Options in the Syntax tab page allows you to specify the exact format you want to use for different datatypes. The first two options specify whether you want PowerBuilder to enclose the names of tables, columns, indexes, and constraints in double quotes when it generates SQL statements. This affects the behavior of any PowerBuilder painter that generates SQL syntax. For example, older versions of Adaptive Server Anywhere need double quote delimitation, while Adaptive Server Enterprise doesn�t use them.
'Use Call Escape Syntax' specifies whether the ODBC interface should convert stored procedure calls to driver-specific native SQL syntax before sending the command to the ODBC driver or use call escape syntax. You may want to leave other options to their default values unless you need a specific format.
Jaguar/MTS options are too advanced to discuss at this stage, let's explore them in the 'Distributed PowerBuilder Objects' session.
| Home | Previous Lesson: Transaction Options Next Lesson: Network Options |