Specifying the SQL property at design time
Go Up to Specifying the SQL statement to execute
You can specify the SQL property at design time using the String List editor. To invoke the String List editor for the SQL property:
- Double-click on the
SQLproperty value column, or - Click its ellipsis button.
You can enter a SQL statement in as many or as few lines as you want. Entering a statement on multiple lines, however, makes it easier to read, change, and debug. Choose OK to assign the text you enter to the SQL property.
Normally, the SQL property can contain only one complete SQL statement at a time, although these statements can be as complex as necessary (for example, a SELECT statement with a WHERE clause that uses several nested logical operators such as AND and OR). InterBase supports “batch” syntax so you can enter multiple statements in the SQL property.
You can use the SQL Builder to construct a query based on a visible representation of tables and fields in a database. To use the SQL Builder, select a query component, right-click it to invoke the context menu, and choose Graphical Query Editor. To learn how to use the SQL Builder, open it and use its online help.