|
LotusScript constants for LS:DO / lsxodbc are contained within the LSX and are not documented. This article is intended to be a reference to some known constant values.
|
SQL Data Types
Constant | Value |
SQL_CHAR | 1 |
SQL_NUMERIC | 2 |
SQL_DECIMAL | 3 |
SQL_INTEGER | 4 |
SQL_SMALLINT | 5 |
SQL_FLOAT | 6 |
SQL_REAL | 7 |
SQL_DOUBLE | 8 |
SQL_DATE | 9 |
SQL_TIME | 10 |
SQL_TIMESTAMP | 11 |
SQL_VARCHAR | 12 |
SQL_BINARY | -2 |
SQL_SQL_VARBINARY | -3 |
SQL_LONGVARCHAR | -1 |
SQL_LONGVARBINARY | -4 |
SQL_BIGINT | -5 |
SQL_TINYINT | -6 |
SQL_BIT | -7 |
LS:DO Data Types
Constant | Value |
DB_TYPE_UNDEFINED | 0 |
DB_CHAR | 1 |
DB_SHORT | 2 |
DB_LONG | 3 |
DB_DOUBLE | 4 |
DB_BINARY | 5 |
DB_BOOL | 6 |
DB_DATE | 7 |
DB_DATETIME | 8 |
DB_TIME | 9 |
FieldInfo Array Index Constants
Constant | Value |
DB_INFO_COLUMNNAME | 1 |
DB_INFO_TABLENAME | 2 |
DB_INFO_COLUMNID | 3 |
DB_INFO_COMPUTED | 4 |
DB_INFO_NATIVE_DATATYPE | 5 |
DB_INFO_EXPECTED_DATATYPE | 6 |
DB_INFO_LENGTH | 7 |
DB_INFO_DISPLAYSIZE | 8 |
DB_INFO_PRECISION | 9 |
DB_INFO_SCALE | 10 |
DB_INFO_NULLABLE | 11 |
DB_INFO_UNSIGNED | 12 |
DB_INFO_MONEY | 13 |
DB_INFO_AUTOINCREMENT | 14 |
DB_INFO_CASESENSITIVE | 15 |
DB_INFO_SEARCHABLE | 16 |
DB_INFO_READONLY | 17 |
DB_INFO_SETTABLE | 18 |
DB_INFO_SQLDATATYPE | 19 |
|