Article View: borland.public.vdbase.data.sql
Article #617QRe: Updating SQL files
From: Carl White
Date: Sun, 20 Sep 1998 00:00
Date: Sun, 20 Sep 1998 00:00
43 lines
2085 bytes
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-mailReferences:
<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