Specifications

Using Databases with ID Works Projects 97
ID Works Standard and Enterprise Version 5 Administrator’s Guide
ID Works fields of type List map to:
ID Works fields of type Print Count map to:
Access data types Text(100)*, Number(Integer),
Number(Long Integer),
Number(Single), Number(Double)
* Maximum length.
DB2 data types Varchar(100)*, Integer, Smallint,
Decimal
Oracle data types VarChar2(100)*, Varchar (if fixed
length), Number(x,y)
SQL Server data types Varchar(100)*, Char (if fixed length),
Integer, Smallint, Bit, Decimal
Access data types Number(Integer), Number(Long
Integer)
DB2 data types Integer, Smallint
Oracle data type Number(x,0)
SQL Server data types Integer, Smallint