Article View: borland.public.cppbuilder.database.ado
Article #1001Renaming Table
From: M.Leister
Date: Tue, 30 Nov 2004 07:55
Date: Tue, 30 Nov 2004 07:55
11 lines
1500 bytes
1500 bytes
Dear all, I was trying yesterday to find a solution on how to rename a table in either MsAccess, or Paradox or even DBASE using TADO... components. With BDE it's extremely simple, and using the syntax I'm used in Oracle 'alter table <oldname> rename to <newname>' it has failed. Could someone give a hint on how to do it programatically? Just as information, I'm using CBuilder 6.0. Thanks in advance for the contributions, Marcelo Leister.
Technical Details
Message-ID:
<41ac2787$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,d9e78c2e0d78555b,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Tue, 30 Nov 2004 08:55:53 +0100 From: "M.Leister" <marceloleister@yahoo.com> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Renaming Table Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 195.65.184.250 Message-ID: <41ac2787$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1101801351 195.65.184.250 (29 Nov 2004 23:55:51 -0700) Lines: 12 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail