 |
Both FCAS and databases require that all data contained in their data structures have explicit data types.
If your application will be connecting to a database, you must be sure to use data types that are compatible with the corresponding database data types. These are the FCAS counterparts for common ODBC database data types:
FCAS |
ODBC database |
Integer |
integer, int, smallint, tinyint, boolean, bit, yes/no |
Long |
integer, int, smallint, tinyint, boolean, bit, yes/no |
Single |
float, double, single, double precision, decimal, numeric |
Double |
float, double, single, double precision, decimal, numeric |
Currency |
monetary, money, currency, smallmoney |
String |
char, character, varchar, variable character, text, memo |
Date |
date, time, date/time, datetime, smalldatetime |
| |
