Specifications

96 Using Databases with ID Works Projects
ID Works Basic Version 5 Administrator’s Guide
When Create Database from Production Form creates a database
table, it names the database the same as the ID Works project except
that it removes the characters listed above. For example, if your ID
Works project is named My Project, Create Database from
Production Form would create a database table named MyProject
(without the space).
When creating database field names, Create Database from
Production Form and Add Production Form Fields to Database
start with the Production Form field name, remove any characters
that are not allowed, and add “IDW” to the start of the name. Adding
this prefix prevents the inadvertent creation of a database field name
that is a reserved word. If removing characters from Production Form
field names results in duplicate database field names, the software
tells you to change a Production Form field name. For example,
Production Form fields named “First Name” and “FirstName” would
both result in the database field name “IDWFirstName” and you
would receive an error message.
Database field names are limited to 64 characters. If the field name is
longer than 64 characters after the characters mentioned above are
removed, only the first 64 characters are used.
The Access field types created are:
Database text fields created for ID Works text or list fields are set to
255 characters, which is the maximum length for ID Works text fields.
This ensures that all data entered in a Production Form text field will
+ plus # number sign (hash)
Production Form Field Type Database Field Type
Text or List Text
Date Date/Time
Photo BLOB: OLE Object
File: Text
Print Count Number(LongInteger)
Auto Sequence Number(LongInteger)