STableElement| Database | |
|---|---|
| AllowNullFilterValues | Allows to filter null value |
| CascadeDelete | Allows to delete references of a sub table. When a sub table will be filtered by a main table and a recordset in the sub table will be deleted, the reference in the main table will be deleted too |
| CascadeUpdate | Allows to save references in sub tables. When a subtable will be filtered by a main table, and a new data record will be inserted or edited, the reference in the main table will be saved too |
| InsertIfSearchedValueNotFound | When this property is true, and a value will be serched by SearchedTableSourceaund SearchedControlSource that is not in the table, a new datarecord will be inserted in the TableSource and positioned. This executes the eventValuesChangedMacro. |
| LogicalDeletionColumn | Allows the logical deletion of data records.
The column of the data record gets a value that marks the data record as
"deleted". The column must be of the type Boolean, Bit or Integer. Id this function activated, this flag will be set in the appropriate column at deletion. It is furthermore possible to get full access to this datarecord. The filter of deleted data records is reserved by the user. To mark a data record as not deleted, the value of the column must be set to false resp. to 0 (Bit or Integer) |
| OptimizeForLargeTable | Optimizes the access of large tables |
| OrderBy | Difines the column to order the data records by |
| RecordSource | Defines the data source of the STableElement |
| SortOrder | Provides three kinds of order: Ascending, Decending and Unsorted |
| UseOrOperator | Defines the use of the and or or operator at table
filtering: When this propertie is deactivated, there will be searched for every data record from the filtering SFormattedField’s and only that data records will be shown, that conform all values from the referenced fields. When this propertie is activated, every data record will be shown that conforms one of the conditions |
| Event | |
| AfterDeleteMacro | Macro, that will be executed after a data record was deleted |
| AfterDeleteMacroParameters | Parameter settings for the AfterDeleteMacros |
| AfterInsertMacro | Macro, that will be executed after a new data record was inserted |
| AfterInsertMacroParameters | Parameter settings for the AfterInsertMacros |
| AfterUpdateConfirmedMacro | Macro, that will be executed confirming the UpdateConfirm dialog |
| AfterUpdateConfirmedMacroParameters | Parameter settings for the AfterUpdateConfirmMacros |
| AfterUpdateMacro | Macro, that will be executed after a data record was updated |
| AfterUpdateMacroParameters | Parameter settings for the AfterUpdateMacros |
| BeforeDeleteMacro | Macro, that will be executed before a data record will be deleted |
| BeforeDeleteMacroParameters | Parameter settings for the BeforeDeleteMacros |
| BeforeInsertMacro | Macro, that will be executed before a new data record will be inserted |
| BeforeInsertMacroParameters | Parameter settings for the BeforeInsertMacros |
| BeforeUpdateMacro | Macro, that will be executed before a data record will be updated |
| BeforeUpdateMacroParameters | Parameter settings for the BeforeUpdateMacros |
| ValueChangedMacro | Macro, that will be executed when the value of a column changes ( s.Using of...) |
| ValueChangedMacroParameters | Parameter settings for the ValueChangedMacro ( s. Using of...) |
| ValuesChangedMacro | Macro, that will be executed when the row contend changes( s. Using of...) |
| ValuesChangedMacroParameters | Parameter settings for the ValuesChangedMacro ( s. Using of...) |
| Main | |
| AllowAdditions | Allow to insert new data records |
| AllowDeletions | Allows to delete data records |
| AllowEdits | Allows to edit data records |
| FetchSize | Defines the number of data records in the fetch buffer |
| Limit | Defines the maximum count of data records that will be read. If the value is 0, all data records will be read |
| MaximumSize | See common properties |
| MinimumSize | See common properties |
| UpdateConfirm | Defines whether the UpdateConfirm dialog will be shown before safing each data record |
| Name | See common properties |
| View | |
| Constraints | See common properties |