Article View: borland.public.cppbuilder.database.ado
Article #2596SQL in ADO
From: Edward Diener
Date: Sun, 20 Apr 2003 19:59
Date: Sun, 20 Apr 2003 19:59
21 lines
2238 bytes
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-mailShow 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