🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #11

Read-only Rowset

#11
From: 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
Technical Details
Message-ID: <36B71230.22FB@visi.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: ff5a1,aa784570fa17f871,start
X-Google-Attributes: gidff5a1,public
From: chuck crawley <novasof@visi.net>
Subject: Read-only Rowset
Date: 1999/02/02
Message-ID: <36B71230.22FB@visi.net>
X-Deja-AN: 439770595
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql