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 |