UpdateSQL complains that table is read-only!!!

Article View: comp.lang.pascal.delphi.databases

Article #121

Back to comp.lang.pascal.delphi.databases Previous Next

#121

From: O.Morgan
Date: Tue, 11 Aug 1998 00:00

20 lines
1169 bytes

I'm using Delphi 3 C/S, and connecting to Oracle 7.  I have a large
number of open tables, and 2 queries using an updateSQL object .  

The first one is OK.

For the second, when I ApplyUpdates, it does its stuff and comes up
with an error message saying 'The table is read-only'.  
This does not cause an OnUpdateError event.

This query is master-detailed on another Dataset by setting the
datasource project pointing to that table and an appropriate (Where
KeyField = :KeyField)  clause in the SQL statement.

Any suggestions?

Thanks for your help.

Olly Morgan

If posting, please also email replies to O.Morgan@ed.ac.uk

Technical Details

Message-ID: <35cff9a5.2564257@newsread.ed.ac.uk>

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: ffff5,89a499a7eebf394e,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,89a499a7eebf394e,start
X-Google-Attributes: gid10de66,public
From: O.Morgan@ed.ac.uk (O.Morgan)
Subject: UpdateSQL complains that table is read-only!!!
Date: 1998/08/11
Message-ID: <35cff9a5.2564257@newsread.ed.ac.uk>
X-Deja-AN: 380004424
Organization: Edinburgh University
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers