| Command |
Description |
Parameter |
| ExecuteSQLStatment |
Executes the given DSQL statement |
- DSQL file path*: File path to the DSQL statement to
be executed
|
| RefreshTableElement |
Refreshes a "TableElement".
The data of the "TableElements"
will be reread, the connected components will be updated |
- Name of the form*: Name of the form that contains the
"TableElement", that should be
updated.
- TableElement name*: Name of the "TableElements" to be updated.
|
| NextDataRecord |
Forwards the database cursor of the given "STableElement" by one position.
This function is the same as the "Next
record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" which should be
forwardes by one position.
|
| PreviousDataRecord |
Moves the database cursor of the given "STableElement" by one position
back. This function is the same as the "Previous
record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" which should be
moves by one position back.
|
| FirstDataRecord |
Moves the database cursor of the given "STableElement" to the first
position. This function is the same as the "First
record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" which should be
moved to the first position.
|
| LastDataRecord |
Moves the database cursor of the given "STableElement" to the last
position. This function is the same as the "Last
record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" which should be
moved to the last position.
|
| DeleteDataRecord |
Deletes the data record on which the cursor
of the "STableElement" is
currently placed. This function is the same as the "Delete record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" on which the
data record should be deleted.
|
| InsertNewDataRecord |
Inserts a new data record at the end of the
"STableElement". This function is
the same as the "Add record"
function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" on which the new
data record should be inserted.
|
| CommitDataRecord |
Saves all changes of the current data
record. This function is the same as the "Save
record" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" on which the
data record should be saved.
|
| UndoDataRecord |
Undoes all changes of the current data
record. This function is the same as the "Undo
changes" function of the "SNavigator" |
- Name of the form*: Name of the form which contains
the "STableElement"
- TableElement name*: Name of the "STableElementes" on which the
data record should be restored.
|
| FindRecord |
Allows to search for a data record matching
to the given criteria. The command FindRecord
allows a fine adjustable search. If only a search with the first found
record is needed, please use the search function of the component SFormattedField.
Its more performant using this for simple searching. |
- Target form*: The form that contains the STableElement
which should be searched.
- STableElement*: The STableElement
that should be searched.
- Column name*: Name of the column to be searched in
the STableElement.
- Source form*: Name of the form which contains the
component containing the search term.
- Search field*: Name of the component containing the
search term.
- Compare*: Specifies how the data records should be
compared with the search term.
- All: The whole field content must match to the
search term. (Default value)
- Partial: Only a part of the field content must match
to the search value.
- Starting: The field content must start with the
search term.
- Case sensitive*: If this argument is set to true, the search value only matches with the
fields content if the case is the same. If the argument is set to false, case will be ignored (Default value).
- Search direction*:
- All: Starts searching forward to the end of the
table and than starting at the beginning of the table.
- Forward: Starts searching forward to the end of the
table.
- Backward: Starts searching backward to the beginning
of the table.
- Like formatted*: Is this argument set to true, the serach value will be used like
displayed in the search component (with possible formats). If the
argument is set to false, only the entered
value will be used as search term (Default value).
- Start searching at*:
- Current position: Starts searching at the current
position. (Default value)
- Beginning: Starts searching at the beginning of the
table any time.
- End: Starts searching at the end of the table any
time.
|
| DataFileExport |
Exports the data from a STableElement. |
- Form name*: Name of the form containing the
STableElement.
- STableElement*: STableElement that contains the data
to be exported.
- Export format*: Format the file should be exported:
- CSV
- Fixed CSV
- SYLK
- HTML
- Static table
- OpenXML
- DIF
- File name*: Path and file name. Existing files will
be overwritten.
- Columnnames?*: If true the
coulmn names will be exported, too.
- CSV separator: String that separates the columns.
Only used for the CSV format.
- Table name: The table name is used for the OpenXML
worksheet name or the TITLE tag of the html page and the CAPTION tag
of the table which contains the data. Only used for the HTML and
OpenXML format.
- Codepage: Used codepage for the HTML export.
|
| DataFileImport |
Imports the data from a file into a STableElement. |
- Form name*: Name of the form containing the STableElement where the data should be imported to.
- STableElement*: STableElement where the data should be imported to.
- Export format*: Format of the file which data should be imported:
- File name/url*: Path or URL to the import file.
- Start with row: The row to be started with the import. If the data file contains a row with column headers, this option should be set to 1.
- CSV separator: String that separates the columns. Only used for the CSV format.
- Table name: The table name specifies the OpenXML worksheet name.
- Codepage: Used codepage for the HTML export.
- Override: Searches for primary key values and replace the records in the STableElement these ones from the data file. Record which could not be overriden will be appended to the table.
- Clear Table: Clears the table befor starting the data file import.
|
With * marked parameters are mandatory declaration. All other
declaration are optional. Optional fields can be empty.
System Commands