search

sqlite-sync / SQLite-sync.com

AMPLI-SYNC is a framework for synchronizing data between a Sqlite database and an MS SQL/MySQL/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated Bidirectional Synchronization when an internet connection becomes available.
https://ampliapps.com/sqlite-sync/
BSD 3-Clause "New" or "Revised" License
326 stars 82 forks source link

Identity insert error #53

Open ger2902 opened 3 years ago

ger2902 commented 3 years ago

Hi, I'm getting this error when I try to insert in the master db a new record that has an Identity primary key:

ERROR PushInsertRecords() Cannot insert explicit value for identity column in table 'Table' when IDENTITY_INSERT is set to OFF.

is an special configuration required??

Thanks

sqlite-sync commented 3 years ago

Check if you have IDENTITY property on primary key set to TRUE.

On 4 Dec 2020, at 17:24, ger2902 notifications@github.com wrote:

Hi, I'm getting this error when I try to insert in the master db a new record that has an Identity primary key:

ERROR PushInsertRecords() Cannot insert explicit value for identity column in table 'Table' when IDENTITY_INSERT is set to OFF.

is an special configuration required??

Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/sqlite-sync/SQLite-sync.com/issues/53, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACNU5N7C4CXANWAALM2VBM3STEENRANCNFSM4UNU5XNQ.

ger2902 commented 3 years ago

Yes it's set to TRUE, is it possible to insert new records with identity value? I wonder if should I send as null the value in the identity column...