sqliteodbc icon indicating copy to clipboard operation
sqliteodbc copied to clipboard

Published 20 hours ago • verified publisher icon softace

Edit/Update and Delete Operations on Table without Primary Keys not Supported using RecordSet

Open Samba143 opened this issue 1 year ago • 0 comments

I am using CRecordset (MFC) to perform Edit/Update and Delete operations on table which doesn't have Primary key. I get error saying "incompatible rowset"

For quick reference, I tried the same scenario against MS Access using Access driver and everything works fine.

Could you please clarify why Update and Deletes can't be supported on tables having no PKs?

Samba143 avatar Sep 20 '24 16:09 Samba143