Article View: borland.public.cppbuilder.database.ado
Article #2671Re: Creating a table dynamically with ADO
From: Mike Ruskai
Date: Wed, 14 May 2003 18:58
Date: Wed, 14 May 2003 18:58
23 lines
1924 bytes
1924 bytes
On 14 May 2003 11:26:54 -0700, Bryan wrote: >I am trying to switch BDE components over to ADO components in my C++Builder 6.0 software. > >My software dynamically creates a table in an Access (switching from Access97 to 2000) database based on user input. > >In BDE, I used a TTable component to create a table: [snip] >Also, there is no CreateTable method for TADOTable. > >Am I on the right path? Is this the best way to do this? Any help would be very much appreciated. >Thanks in advance. You can't create a table that way. You must either use SQL to create the table, or import the ADOX library (called ADO security extensions, or something like that), and use the Catalog, Table, and Column objects. Search the Borland groups on Google for some examples. -- - Mike Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID:
<gunaalqrneguyvaxarg.hew4py0.pminews@207.105.83.65>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3ec28a6e$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,c03844264cac6a97 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-05-14 12:10:22 PST Newsgroups: borland.public.cppbuilder.database.ado From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> Message-ID: <gunaalqrneguyvaxarg.hew4py0.pminews@207.105.83.65> References: <3ec28a6e$1@newsgroups.borland.com> Date: Wed, 14 May 2003 14:58:46 -0400 (EDT) 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: 7bit Subject: Re: Creating a table dynamically with ADO NNTP-Posting-Host: 65.41.86.200 X-Trace: newsgroups.borland.com 1052938727 65.41.86.200 (14 May 2003 11:58:47 -0700) Lines: 25 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail