
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
Kommentare zu diesen Handbüchern