Specifications

Using Databases with ID Works Projects 95
ID Works Standard and Enterprise Version 5 Administrator’s Guide
of every table name when SQL strings are created in ID Works
Production.
If you are using public synonyms, you should not select the Use
schema/owner name to identify tables in Production option.
Data Types
Datacard has tested the databases listed in the following tables.
Corresponding data types for ODBC databases depend on the
database product vendor. Refer to the ID Works ReadMe file for a
complete list of databases tested with your version.
ID Works fields of type Text map to:
Access data types Text(255)*, Number(Integer)†,
Number(Long Integer)†,
AutoNumber(Long Integer)†,
Number(Single)†, Number(Double)†
* Maximum length.
† Production operators will not be able to use wildcard characters in
the Quick Search dialog box for fields connected to a database
column of this type. The Advanced Search dialog box can be used
to search for a range of numeric values.
DB2 data types Varchar(255)*, Integer†, Smallint†,
Decimal†, Double‡, Real‡
‡ Production operators will not be able to search fields connected to
a database column of this type using the Quick Search dialog box.
Consider clearing the Searchable field option for Production Form
fields connected to database columns of this type. See “Field
Options” on page 68.
Oracle data types VarChar2(255)*, Number(x,y)†
SQL Server data types Varchar(255)*, Integer†, Smallint†,
Decimal†, Numeric†, Float‡, Real‡