🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2596

SQL in ADO

#2596
From: Edward Diener
Date: Sun, 20 Apr 2003 19:59
21 lines
2238 bytes
Is there any generic way to determine elements of SQL support for any given
RDBMS data provider ? The areas of SQL I am interested in are:

1) Case sensitivity for database object names ( true or false ).
2) Delimiter for database object names ( usually a pair of double quotes
around the name but could be something else ).
3) Delimiter for string value ( usually a pair of single quotes around the
value but could be something else ).
4) Table.Column format style ( ie. if the database object name delimiter is
double quotes, then the correct format could be either "table"."column" or
"table.column" ).

Needless to say I do not want to have to know the property names and values
for finding out these values for every RDBMS which exists but am seeking a
possible generic solution. Of course if ADO does not have such a generic
solution, I will have to hard-code the correct values for specific RDBMSs
or, in developing generic ADO type components for others, have BCB
properties
which the end-user must set. However it would be much better if ADO had
methods for finding out this information generically, but unfortunately I do
not see any of them.
Technical Details
Message-ID: <3ea2fb78$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!chi1.webusenet.com!news.webusenet.com!cyclone1.gnilink.net!wn14feed!wn13feed!worldnet.att.net!216.166.71.14!border3.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,452104fae4bb2af5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-20 12:58:26 PST
From: "Edward Diener" <eddielee@tropicsoft.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: SQL in ADO
Date: Sun, 20 Apr 2003 15:59:37 -0400
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 216.175.65.126
Message-ID: <3ea2fb78$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1050868600 216.175.65.126 (20 Apr 2003 12:56:40 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!chi1.webusenet.com!news.webusenet.com!cyclone1.gnilink.net!wn14feed!wn13feed!worldnet.att.net!216.166.71.14!border3.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail