Article View: borland.public.cppbuilder.database.ado
Article #2944Re: Creating Access DB in Builder
From: Mike Ruskai
Date: Wed, 12 Feb 2003 02:47
Date: Wed, 12 Feb 2003 02:47
38 lines
2363 bytes
2363 bytes
On Mon, 10 Feb 2003 18:20:07 +0100, Inés Fernández wrote: >> I found that creating a table via SQL results in the table data itself >taking >> up about twice as much space as it's supposed to, and taking twice as long >to >> search through. I don't know why this is, but when the same exact table >> definition is created via ADOX, the table size and speed is normal. >Needless >> to say, this is after compacting that the size comparison is made, since >> creating and populating an Access database will give you a file almost >twice >> as large as it is after compacting. > >Just a silly newbies question: >I have been using BDE controls, but just some days ago I started to use ADO >controls. >I am creating a table using the SQL sentence "CREATE TABLE..." as the >command text of a TADOCommand. >Is that creating it via SQL or via ADOX? >(sorry, I don't understand what does mean "via ADOX") You're using SQL. ADOX is the only way to create an Access database, and also allows you to create table definitions (using table and column components). -- - Mike Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID:
<gunaalqrneguyvaxarg.ha6d3b0.pminews@207.105.83.65>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3e3ef595$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.h9s1xy0.pminews@207.105.83.65> <3e47df45$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,cf0428e56f70fa7d X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-02-11 18:51:21 PST Newsgroups: borland.public.cppbuilder.database.ado From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> Message-ID: <gunaalqrneguyvaxarg.ha6d3b0.pminews@207.105.83.65> References: <3e3ef595$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.h9s1xy0.pminews@207.105.83.65> <3e47df45$1@newsgroups.borland.com> Date: Tue, 11 Feb 2003 21:47:35 -0500 (EST) Reply-To: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> X-Newsreader: PMINews 2.00.1205 For OS/2 Organization: TLF MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Creating Access DB in Builder NNTP-Posting-Host: 65.40.238.56 X-Trace: newsgroups.borland.com 1045018053 65.40.238.56 (11 Feb 2003 18:47:33 -0800) Lines: 40 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail