Thread View: alt.comp.databases
1 messages
1 total messages
Started by JonathanC
Thu, 28 Jan 1999 00:00
Table is read only?!?
Author: JonathanC
Date: Thu, 28 Jan 1999 00:00
Date: Thu, 28 Jan 1999 00:00
24 lines
1916 bytes
1916 bytes
Delphi 3, MS SQL 6.5 Master & detail queries using cached updates for editing I am getting the rather non-sensical message, "Table is read only," when inserting records, and I can't figure out what is going on. Here is what the program is doing: In order to insert the master records, return the new identity field, and then insert the detail records, I use the OnUpdateRecord events of both queries. Database.ApplyUpdates([MasterQuery]) is first called. This inserts all the needed records to the database and stores the new identity value in a global variable. It then calls DetailQuery.ApplyUpdates and DetailQuery.CommitUpdates, so that the detail records are applied within the same transaction. When I step through the code, it gets all the way through all the above processes. Then as I step from "end;" on the master query's OnUpdateRecord event handler, it raises the EDBEngineError, "Table is read only." There are no read only tables involved. How can I get an error on that line of "code" anyway? Is there something wrong with the way I'm going about things? Thanks a million for any suggestions!
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads