b7p1zh9.htm
Notes:
C | The Clarion data type can be used to manipulate the ODBC data type. CREATE does create the ODBC data type. |
• | The Clarion type can be used to manipulate the ODBC data type, however, CREATE does NOT create the ODBC data type. |
1 | Clarion LONG, SHORT, and BYTE can be used with ODBC DECIMAL and NUMERIC data types if the ODBC field does not have any decimal places. |
2 | ODBC TIMESTAMP fields can be manipulated using a STRING(8) followed by a GROUP over it which contains only a DATE field and a TIME field. |
Example:
TimeStampField STRING(8),NAME('TimeStampField')
TimeStampGroup GROUP,OVER(TimeStampField)
TimeStampDate DATE
TimeStampTime TIME
END
CREATE creates a TIMESTAMP field if you use a similar structure.
3 | Some loss of precision may occur. |
4 | Rounding errors may occur. |
5 | CREATE attempts to create a TINYINT for a BYTE. If the backend does not support TINYINT, CREATE treats BYTE as a SHORT. CREATE attempts to create a SMALLINT for a SHORT. If the backend does not support SMALLINT, CREATE treats SHORT as a LONG. CREATE attempts to create an INTEGER for a LONG. If the backend does not support INTEGER, CREATE creates a decimal field. |
b7p1zh9.htm.txt · Last modified: 2021/04/15 15:56 by 127.0.0.1