🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

QRe: Updating SQL files

#617
From: Carl White
Date: Sun, 20 Sep 1998 00:00
43 lines
2085 bytes
Gary,

>For a rather comprehensive overview of this, run (don't walk) to Alan
>Katz's web site and get OODML.HOW.  Alan has done a great job of
>explaining the why as well as the how of using the new language.

I've downloaded this article and am wading through it now, though so far
it hasn't really broached the subject of updating tables (maybe it comes
later - I'm only half way through).

>Your best bet is to use a query object and to set
>relationships and such using dataModules.

In this reference are you refering to the VdB 5 use of  QBE files?  I
thought I read somewhere that those shouldn't be used any more.

I can already see this is going to be a long uphill struggle - maybe I'm
getting too old to learn a new language (i.e., SQL) <g>


Gary White wrote:

> On Sat, 19 Sep 1998 15:26:03 -0500, Carl White wrote:
>
> > Is there a way (and I'm sure there is) to set up the SQL query so
> > I can update it?  What steps do I follow to do this?
>
> Hi Carl,
>
> Most SQL statements other than "select * from sometable" will yield a
> read-only rowset.  Your best bet is to use a query object and to set
> relationships and such using dataModules.
>
> For a rather comprehensive overview of this, run (don't walk) to Alan
> Katz's web site and get OODML.HOW.  Alan has done a great job of
> explaining the why as well as the how of using the new language.
>
> The URL is: http://www.ksoftinc.com/vdb/
>
> Gary
>
> Some dBASE Stuff at
> http://www.AppTools.com/dbase
Technical Details
Message-ID: <36054ED5.B98C06DC@earthlink.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3604135B.24D6F1A4@earthlink.net> <36041f6f.13146307@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,29f1301de53c716e
X-Google-Attributes: gidff5a1,public
From: Carl White <whitecw@earthlink.net>
Subject: QRe: Updating SQL files
Date: 1998/09/20
Message-ID: <36054ED5.B98C06DC@earthlink.net>
X-Deja-AN: 393052830
Content-Transfer-Encoding: 7bit
References: <3604135B.24D6F1A4@earthlink.net> <36041f6f.13146307@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql