Article View: borland.public.vdbase.data.sql
Article #1505Re: Problem with Order Tag on SQL Tables
From: Romain Strieff [TeamB]
Date: Thu, 18 Dec 1997 00:00
Date: Thu, 18 Dec 1997 00:00
26 lines
1425 bytes
1425 bytes
In article <3497FA1D.52F4@corp.borland.com>, kmayer@corp.borland.com says... > > Suggestion: Don't use pure SQL for everything. Instead, use a > combination of the SQL and the database classes. For example, you can > create a QUERY and use that. This has the rowset class (automatically) > attached to it, and you can use any index tag you want from there: > > qMyQuery = new Query() > qMyQuery.sql = "select * from mytable" > qMyQuery.active = true > qMyQuery.rowset.indexName = "myindextag" > Suggestion (Wishlist): Add a new property, so we'll need _no_ SQL whatsoever.<G> qMyQuery = new Query() qMyQuery.tablename = ":mydatabase:.mytable" qMyQuery.active = true qMyQuery.rowset.indexName = "myindextag" -- Romain Strieff [TeamB] A few VdB utilities at: http://ourworld.compuserve.com/homepages/RStrieff/
Technical Details
Message-ID:
<MPG.f0295758416203e98a1ee@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bd0a7b$56007e50$74ffc2d0@wells> <3497111B.235C@corp.borland.com> <01bd0a81$ba0ee840$74ffc2d0@wells> <3497FA1D.52F4@corp.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,3ddd9c9af1c9a349 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: Problem with Order Tag on SQL Tables Date: 1997/12/18 Message-ID: <MPG.f0295758416203e98a1ee@forums.borland.com> X-Deja-AN: 299188574 References: <01bd0a7b$56007e50$74ffc2d0@wells> <3497111B.235C@corp.borland.com> <01bd0a81$ba0ee840$74ffc2d0@wells> <3497FA1D.52F4@corp.borland.com> Reply-To: teamb@opto-pps.com Organization: TeamB Newsgroups: borland.public.vdbase.data.sql