Calendar: Form - SQL
Define the attributes relative to
the connection to the table used by the form. Define primary key, filters and ordinances for the form.
Image1: SQL SettingsInterface
primary key fields - In
this function it is displayed a combobox object with an asterisks
that indicate what are the fields that are SQL table primary key fields . In the majority of cases, the Scriptcase identifies it. For cases that are not identifiable by the Scriptcase the user must use the buttons to select the field as key, note:
Button - Select/unselect the field as primary key displaying an asterisk at
its left side.
Button - Defines all fields as primary key.
- None - Defines that no field is primary key (unselect all). Normally it is used to clean all
definitions of the On/Off and restart the process.
Buttons - Allows to order the primary key fields. To order click on the field and use
Condition - Enter the WHERE to retrieve the records to edit.
- Enter the ORDER BY clause to
determine the order that the records are displayed. When the
navigation is used by default, the order is determinated
by the primary key.
-Displays the connection name (database) that the application is using for its
execution, this connection can be replaced by another that have the
same tables (SQL).
Name - Table
name that the form application is using.
for Table -
Fields to allow to be replaced part of the table name defined in
the select, before the execution.
Note: In the first
field enter the variable name. In the second field enter the part of the table name to be replaced.
- Case Sensitive - Set it to "No" only if the database is configured for case-sensitive and it is desired that the filter does not respect this setting.