Return IDENTITY for SQLCE3.5
Posted: Thu 04 Jun 2009 13:20
Hello, we also have a problem with retrieving IDENTITY fields after inserting records into TUniTable with SQLCE. For instance, I have TUniTable with QueryIdentity=True and Options.ReturnParams=True, and when I execute Append () and then Post (), the primary key filed isn't updated to reflect the value generated by DB. This causes many side effects, for example, it is impossible to edit newly appended value in TDBGrid, while trying to do so, it raises an exception saying 'Refresh failed. Found 0 records'.
How can I fix this? Thanks.
How can I fix this? Thanks.