Auto Increment Fiels not Working
Posted: Sun 03 Jun 2018 02:23
Hello!
My scenario is PostgreSQL and SQLite databases, with IDs as auto increment fields.
I use FireDac, when I connect to database IDs are setted to be an AutoInc Field and AutoGenerateValue is set arAutoInc automaticaly, so when insert a record IDs gets -1 value in Cache Update mode.
But I testing UniDac, and the IDs is not recognized as Auto Inc. When I insert a record IDs values gets null.
I tried to set Provider Flags, and AutoGenerateValue but not work.
How can I work with auto inc fields in UniDac.
I wish work with -1... IDs values in cache update mode and Apply/Commit Master Detail with auto inc fields.
My scenario is PostgreSQL and SQLite databases, with IDs as auto increment fields.
I use FireDac, when I connect to database IDs are setted to be an AutoInc Field and AutoGenerateValue is set arAutoInc automaticaly, so when insert a record IDs gets -1 value in Cache Update mode.
But I testing UniDac, and the IDs is not recognized as Auto Inc. When I insert a record IDs values gets null.
I tried to set Provider Flags, and AutoGenerateValue but not work.
How can I work with auto inc fields in UniDac.
I wish work with -1... IDs values in cache update mode and Apply/Commit Master Detail with auto inc fields.