Article View: alt.comp.databases
Article #130Table is read only?!?
From: 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!
Technical Details
Message-ID:
<78pvn1$put$1@birch.prod.itd.earthlink.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10de66,51e1edc819db1251,start X-Google-Attributes: gid10de66,public X-Google-Thread: fc5c9,51e1edc819db1251,start X-Google-Attributes: gidfc5c9,public X-Google-Thread: 10a90d,51e1edc819db1251,start X-Google-Attributes: gid10a90d,public From: "JonathanC" <Jonathan@Camenisch-junk.net> Subject: Table is read only?!? Date: 1999/01/28 Message-ID: <78pvn1$put$1@birch.prod.itd.earthlink.net> X-Deja-AN: 437961850 X-Posted-Path-Was: not-for-mail X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 X-ELN-Date: 28 Jan 1999 15:28:33 GMT X-ELN-Insert-Date: Thu Jan 28 07:35:05 1999 Organization: EarthLink Network, Inc. Newsgroups: alt.comp.databases,borland.public.delphi.database.sqlservers,comp.databases