In this module are defined the attributes relative to the connection with the table in that the form was created. We can define the primary key, filters, ordinances for the create form.
Image1: Interface of SQL Configuration.
Choosing the fields that are primary key - In this function it is shown an combobox object with an asterisk beside, that indicates what are the fields that compose the primary key of the SQL table. In the majority cases, the Scriptcase identifies it, for the cases that this don't happen, the user will must do this identification, using the buttons beside to do the choose of the key. See how the buttons act:
Where Condition - Option to the user enter the WHERE clause to filter sql records.
Order By - Allows the user write an ORDER BY clause that will determine the order of the records. By default the records are ordered by primary key.
Connection - Show the connection name (database) that the application is using for its execution, this connection can be traded for another that have the same tables (SQL).
Table Name - Table name that the form application is using.
for Table -
These filled fields allows that part of the table name defined in
the select to be traded before the execution of the command by a
content of a variable.
Note: In the first field you must fill it with the variable name. The second field must be filled with the part of the table name to be traded.