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.
*ValidateRow
*FetchRow
*EnterRow
*QuitRow
*EnterUpdate Mode
*PrepareUpdate
*QuitUpdateMode
*EnterInsertMode
*PrepareInsert
*QuitInsertMode
*PrepareDeleteMode
*CancelEdits
*DeleteRow
*EnterModifiedState
Buttons
The Memory Data Source inspector panel has two buttons at the bottom:
*Apply
*Close
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