IliMemoryDataSource
The IliMemoryDataSource gadget is used for:
defining temporary tables in local memory by entering data.defining how the data is to be displayed by specifying format criteria for display gadgets connected to the memory data source.
IliMemoryDataSource Inspector Panel
This panel appears by double-clicking its gadget-icon (seen above) in the Gadgets buffer window. The IliMemoryDataSource inspector has five notebook pages:
Data Source Page
Data Source Page Table Columns
Column | Description |
|---|---|
Column | Menu: None. Default: No default. Explanation: The name of the column. |
Type | Menu: String, Boolean, Byte, Integer, Float, Double, Date Default: No default. Explanation: The type of data that can be entered in the column. |
Data Source Page Notebook Pages
The Data Source page has three notebook pages. The rows on these pages define the criteria for mapping data to other data source columns and for formatting the data in display gadgets.
Datatype Page The Datatype page is used to define the type of data that can be entered in the column.
Label | Description |
|---|---|
Length | Menu: None. Default: No default. Explanation: Number of characters that can be entered in the cells of the column. |
Part of key | Menu: Yes, No. Default: No Explanation: Yes = The column is included in the key for the table. No = The column is not included in the key. |
Null | Menu: Yes, No. Default: No Explanation: Yes = The cell can remain empty. No = The cell cannot remain empty. |
Default | Menu: None. Default: No default. Explanation: Data that appears in a cell when it is added to the table. |
Look Page The Look page is used for defining how data entered in the column will appear.
Label | Description |
|---|---|
Format | Menu: Formats corresponding to what is entered in the column Type cell in the Memory Data Source inspector panel. Default: No default. Explanation: Predefined system and user formats from the menu or a format entered by the user, by which data in the column cells will be formatted. |
Mask | Menu: Masks corresponding to how and what data is entered in the column Type cell in the Memory Data Source inspector panel. Default: No default. Explanation: Predefined by the user for data input in the column cells. There are predefined system masks for date and time. |
Alignment | Menu: Left, Center, Right. Default: Depends on the entry in the Type cell in the Memory Data Source inspector panel. Explanation: How data in the column cells will be aligned within the cell. |
Width | Menu: None. Default: No default. Explanation: The display width in pixels of the column cells. Can be changed in the table gadget. |
Read only | Menu: Yes, No. Default: No default. Explanation: Yes = Prevents the column cells from being edited. No = Allows the column cells to be edited. |
Visible | Menu: Yes, No. Default: No default. Explanation: Yes = The column is visible. No = The column exists but does not appear. |
Header | Menu: None. Default: No default. Explanation: The title that will appear at the top of the column when displayed in a table gadget. If left empty, the table gadget uses the column name. |
Label | Menu: None. Default: No default. Explanation: Applies only when the Data Source Assistant is used to create a form. The caption that appears next to the form gadget containing the data for the column. If empty, the column name is used. (The Header row on the Look page is not used.) |
Mapping Page The Mapping page is used to display data in a column by referring to data in a column in another table.
Label | Description |
|---|---|
Data Source | Menu: Current data sources. Default: No default. Explanation: The foreign data source containing the columns to which the values for the current column are to be mapped. If a foreign data source is specified here, creates a combo box pull-down menu in the cell showing the values in foreign data source. |
Value column | Menu: Columns of the data source selected in the Data source row. Default: No default. Explanation: Column containing the value to which the current column is to be mapped. |
Display column | Menu: Columns of the data source selected in the Data source row. Default: No default. Explanation: Column associated with the Value column containing the data to be displayed. |
Constrained | Menu: Yes, No. Default: No default. Explanation: Applies only when the value entered in the Value column and Display column rows is the same. Yes = Can only enter a value that belongs to the foreign data source. No = Can enter any value. |
Completion | Menu: Yes, No. Default: No default. Explanation: Is only in effect when Constrained = Yes. Yes = Can enter a combo box list item by typing enough of its initial characters to make it unique, then validating it or leaving the cell. No = Cannot enter a combo box list item by typing its initial characters. |
General Page
For a description of this notebook page, refer to the section General Notebook Page.
Specific Page
Column | Description |
|---|---|
Read only | Menu: Yes, No. Default: No default. Explanation: Yes = Prevents the column cells from being edited. No = Allows the column cells to be edited. |
Global | Menu: Yes, No. Default: No. Explanation: Yes = Allows more than one user panel to use the current memory data source. No = Only one user panel can use the current memory data source. |
Allow insert | Menu: Yes, No. Default: Yes. Explanation: Yes = Allows a new row to be inserted into the data source table. No = Prevents the user from inserting a new row into the data source tables, but does not prevent the user from editing existing rows. |
Transaction manager | Menu: List of available transaction managers. Default: No default. Explanation: Name of the transaction manager used by this data source. |
Use property manager | Menu: Yes, No. Default: Yes. Explanation: Yes = The data source uses a property manager. No = The data source does not use a property manager. |
Data Page
The Data page is used to edit the data source data. But the data source schema must be defined and validated.
Callbacks Page
In addition to the callbacks described in the section Callbacks Notebook Page, this inspector uses the callbacks listed below.
ValidateRowFetchRowEnterRowQuitRowEnterUpdate ModePrepareUpdateQuitUpdateModeEnterInsertModePrepareInsertQuitInsertModePrepareDeleteModeCancelEditsDeleteRowEnterModifiedStateButtons
The Memory Data Source inspector panel has two buttons at the bottom:
ApplyClose Button | Description |
|---|---|
Apply | Applies changes made in the Memory Data Source inspector panel to the data source table(s). |
Close | Closes the Memory Data Source inspector panel. |
Published date: 05/24/2022
Last modified date: 02/24/2022
