identity and auto-increment columns

When inserting records into tables with auto-incrementing or identity type fields it is possible to retrieve the auto-generated value and write this value back to the IMan dataset.

Due to the differences between the implementations across databases IMan supports the following databases:

• Access
• Microsoft SQL Server
• MySQL
• Oracle
• Postgres

To obtain the auto-generated value it is necessary to map an empty field onto the identity/auto-increment field using the table.

Database Type	Field Name Mapping Convention
Access	Field name can be anything.
Microsoft SQL Server
MySQL
Oracle	The field name must match the column name.
Postgres