Attribute |
Definition |
Syntax |
ColNum |
Retrieves the column's ordinal number in the table. This attribute is read only at runtime. |
tablename.column(columnid).ColNum |
Data |
Retrieves or assigns the value of binary data columns. The data attribute contains binary data which, in most instances, may be manipulated as a string. |
tablename.column(columnid).Data |
Datatype |
Retrieves the column's data type. It contains a constant integer value indicating the data type of the column. This attribute is read only at runtime. |
tablename.column(columnid).Datatype [constant] These are the possible values for constant: � fcString - character or text data � fcInteger - long integer numeric data � fcLong - long Integer numeric data � fcSingle - double floating point numeric data � fcDouble - double floating point numeric data � fcCurrency - currency data � fcDate - date and time data � fcBinary - binary data. |
Name |
Retrieves the column's database identifier. This attribute is read only at runtime. |
tablename.column(columnid).Name |
Nullable |
Returns whether or not the column can be null. This attribute is read only at runtime. |
tablename.column(columnid).Nullable |
Precision |
Retrieves the column's (or parameter's) maximum number of digits used by the data type of the column or parameter. This attribute is read only at runtime.  Note For character types, this is the length in characters of the data; for binary data types, column size is defined
as the length in bytes of the data. For the time, timestamp, and all interval data types, this is the number of characters in the character representation of this data. |
tablename.column(columnid).Precision |
Scale |
Retrieves the maximum number of digits to the right of the decimal point for the column. This attribute is read only at runtime. Note For approximate floating point number columns or parameters, the scale is undefined, since the number of digits
to the right of the decimal point is not fixed. For datetime or interval data that contains a seconds component, the decimal digits is defined as the number of digits to the right of the decimal point in the seconds component of the data. For the SQL_DECIMAL and SQL_NUMERIC data types, the maximum scale is generally the same as the maximum precision. However, some data sources impose a separate limit on the maximum scale. |
tablename.column(columnid).Scale |
Text |
Retrieves or assigns the text string of the column on the current row. Text may also contain date information. Text and Value are the default attributes for columns. |
tablename.column(columnid).Text |
Value |
Retrieves or assigns the numeric value of the column on the current row. Value may also contain date information. Text and Value are the default attributes for columns. |
tablename.column(columnid).Value |
