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.