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 |