Read-only Rowset

Thread View: borland.public.vdbase.data.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by chuck crawley Tue, 02 Feb 1999 00:00

#11

Author: chuck crawley
Date: Tue, 02 Feb 1999 00:00

20 lines
1233 bytes

Hello,
  I am using Vdb7 and I noticed that when I use a SQL statement other
than "select * from 'mytable.dbf'", if I attach that SQL statement to a
query and attach the query to a Grid and then try to edit the
information, it says that the rowset is "Read-only".  

Example:

 SELECT Callhistory.CONTACT_DT, Callhistory.CONTACT_TM,
Callhistory.RESPONSE, Callhistory.CONTACT_RESPONSE
FROM "callhistory.dbf" Callhistory, "rparams.dbf" Rparams
WHERE  Callhistory.SS_NO = Rparams.C3 
ORDER BY Callhistory.CONTACT_DT, Callhistory.CONTACT_TM

This sql statement when attached to a grid generates a "Read-only"
rowset.  Is there any way around this or a different way to Edit the
rowset generated by this sql statement?

Thanks in advance,
Trent Crawley

Re: Read-only Rowset

#13

Author: Gary Gary White
Date: Tue, 02 Feb 1999 00:00

12 lines
1052 bytes

On Tue, 02 Feb 1999 09:56:48 -0500, chuck crawley wrote:

>   I am using Vdb7 and I noticed that when I use a SQL statement other
> than "select * from 'mytable.dbf'", if I attach that SQL statement to a
> query and attach the query to a Grid and then try to edit the
> information, it says that the rowset is "Read-only".  

This is as designed and is a limit of the BDE when working with local
tables (*.dbf/*.db).  Check the help topic "live queries" for details.

The preferred method is to use the data objects to set relationships
and index orders.

Re: Read-only Rowset

#15

Author: Ken Mayer [TeamB]
Date: Wed, 03 Feb 1999 00:00

18 lines
1099 bytes

chuck crawley <novasof@visi.net> wrote:

>This sql statement when attached to a grid generates a "Read-only"
>rowset.  Is there any way around this or a different way to Edit the
>rowset generated by this sql statement?

Joins, WHEREs and ORDER BYs will almost always cause read-only on
local tables. Suggest you download BEGDATA.ZIP, MISCCODE.ZIP and
X2OODML.ZIP from my website ...

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm
Visual dBASE and InterBase WebRing - http://www.fghoche.com/dbasering.htm
TeamB: http://www.teamb.com

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