Name of table (max characters). Used to identify the genie when on a graphics page

Pixel width of the table at runtime.

Note: Leave the size of the genie at design time as 100 pixels, as it will be automatically calculated at runtime.

Number of rows displayed on the page.

Pixel Height of header row in table display.

Pixel height of row in the table display.

The pixel padding between the bottom of the header text (column name) and the bottom of the header row

The pixel padding between the bottom of the cell text and the bottom of each row.

The pixel padding on the left-hand-side and right-hand-side of the cell text relative to the width of each column.

The minimum (quickest possible) rate that the control will be redrawn.

The control is only redrawn as required upon changes to the layout, scrolling or other user initiated events.

The number of page scan delay before the genie is initialized at runtime. this can be set to different number on different control genies to stagger the initialization order. If not set defaults to 1.

The ADO connection string to the database source. See the sConnect parameter of the built-in Cicode function SQLCreate for details.

The SQL query statement to return a table of records (recordset)

The name of the horizontal scroll bar genie on the page that allows the user to horizontally scroll the content displayed on the control genie If you will not require horizontal scrolling, leave this field blank.

The name of the horizontal scroll bar genie on the page that allows the user to vertically scroll the content displayed on the control genie If you will not require vertical scrolling, leave this field blank.

The pre-configured font for header text.

The pre-configured font for cell text.

The pre-configured font for cell text when it is selected.

True/False drop down box. False is selected by default. Determines whether the column width will be automatically adjusted to show full cell content when the control is redrawn.

Callback function that is called when the control initializes. The callback function should return either TRUE (1) for success or FALSE (0) if unsuccessful. By default, if the user specified function does not initialize, the control genie will retry the function a few times before giving up.

This callback only supports the #Name keyword which represents the name assigned to the control genie.

Note: The initialization callback function may be called multiple times whenever the table is re-initialized.

Callback function that is called when the user clicks the left mouse button. No particular return value is expected from this function, and it supports the following keywords in its argument list:

#Name = name assigned to the genie

#Row = row number of the cell (w.r.t. the underlying data) that is clicked

#Col = column number of the cell that is clicked

#RowDsp = row number of the cell relative to the display that is clicked

#ColDsp = column number of the cell relative to the display that is clicked

Callback function that is called when the user clicks the right mouse button. It uses the same specification as that of the Left mouse callback.

Callback function that is called when the user double-click the left mouse button. It uses the same specification as that of the Left mouse callback.