🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: alt.comp.databases
Article #130

Table is read only?!?

#130
From: JonathanC
Date: Thu, 28 Jan 1999 00:00
24 lines
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-mail

Show 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