#SCRIPTCASE HOW SEE GENERATED SQL MANUAL#

Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.Дisplay original and lookup value : Displays the value of the field and the value returned from the lookup.Title : Text displayed on the title of the Select object.Title internal value : Value Saved to the field when the line of the title is selected in the object.Use title : Allows to display a line of a title on the select object (Title Attribute) associated to a value informed manually (Title internal value). Height : Defines the height for the select object.

Only inform a value to this field if you need to separate the selected options with a different delimiter then ( ).

Delimiter : Defines the character used to separate the values selected in the form.

Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitation. The value of the key_field will be stored in the table field. SELECT key_field, display_field FROM table The command needs to have the following structure:

SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field.

These values will be recovered dynamically using the Select command. Lookup used to list the values that will be displayed on the Checkbox field.

#SCRIPTCASE HOW SEE GENERATED SQL MANUAL#

You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query). For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.ДЄ method used to offer the user a list of values that can be selected in the form applications.

OnChange Submit : When enabled, it submits the search when there is modifications to the field.

Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.

Select Field Behavior Interface of the Search Configuration.

SQL Type : Informs the data type of field in the database.

Maximum Size : Defines the size of the field.

Amount of characters : Define the amount of characters allowed for the field.

Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be вЂњClient NameвЂќ. Search Label : Defines the title of a field in the application.When set to Select, you can select multiple option from a combo box (Select Field). Data Type : Define the type of field for the application.

Scriptcase how see generated sql