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