Specifications

88 Using Databases with ID Works Projects
ID Works Basic Version 5 Administrator’s Guide
Data Types
ID Works Basic applications support the following data types:
Production Form Field Access Database Column Type
Text 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.
Photo OLE Object, Text‡
‡ Use a Text field if you chose File on the Storage tab of the Edit
Field Properties dialog box for the photo field.
Date Date/Time**
**Access assigns a default time value (00:00:00) to each inserted
date value. When searching using a date, ID Works software
searches for times between 00:00:00 and 23:59:59 on that date.
List Text, Number(Integer), Number(Long
Integer), Number(Single),
Number(Double)
Print Count Number(Integer), Number(Long
Integer)
Auto Sequence Number(Integer), Number(Long
Integer)
Static Text not applicable
Static Graphic not applicable
Composite not applicable