Options
The Options screen shows the configuration settings for a table:
You can configure the following properties on the Options screen:
|
Property: |
Description: |
Value: |
|||||
|
Name |
Name of the table. |
<Text> |
|||||
|
Description
|
Description of the table. |
<Text> |
|||||
|
Filegroup/ |
Name of the MSSQL filegroup or Oracle tablespace, as defined by the database administrator. |
<Text> |
|||||
|
Add timestamp fields |
Whether the following read-only fields will be added to the database. Possible values: Default (set in Application Options), Yes, and No. |
|
|||||
|
Name: |
Type: |
Length: |
Format: |
||||
|
LIONMODIFIEDDATE |
Numeric |
8 |
yyyymmdd |
||||
|
LIONMODIFIEDTIME |
Numeric |
6 |
hhmmss |
||||
|
LIONCREATEDDATE |
Numeric |
8 |
yyyymmdd |
||||
|
LIONCREATEDTIME |
Numeric |
6 |
hhmmss |
||||
|
These fields are maintained by LION whenever a record is added or modified. These fields can be used in program code and can also be viewed in RTQuery. |
|||||||
| Unicode | Whether the table will use Unicode coding. Possible values: Default (set in Application Options), Yes, and No.
|
||||||
| Length of Lionrecno | Sets LIONRECNO to a Numeric 18 field instead of the default Numeric 9.
Possible values: Default (set in Application Options), Numeric 9,
and Numeric 18.
|
||||||