Auto Increment Fiels not Working

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lfgarrido
Posts: 3
Joined: Wed 29 Oct 2014 19:24

Auto Increment Fiels not Working

Post by lfgarrido » 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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Auto Increment Fiels not Working

Post by MaximG » Wed 06 Jun 2018 11:10

Currently, the feature you are interested in is absent in our components. You can leave your suggestions at our UserVoice page (https://devart.uservoice.com/forums/104 ... 939-unidac), and if there are many votes for your suggestion, we will implement it.

Post Reply