Article View: borland.public.delphi.database
Article #1978Re: Write Delphi code to restructure a table???
From: Dennis Fantoni(Work)
Date: Fri, 05 Mar 1999 00:00
Date: Fri, 05 Mar 1999 00:00
30 lines
1776 bytes
1776 bytes
>What kind of restructuration do you want to do ? > >You can use SQL statement "Alter table", you can also make call to dbi >functions but this is much complex. > >You can't restructure directly with Delphi code. There's a third option, allthough rather clumsy, it seems to work. 1 Rename the old table. 2 Use the ttable component to create the new table. 3 Copy all data from the old table to the new table. We use this to create tables based on the fields in our objects, in an attempt to do something at least a little object oriented with the borland databases. It seems to work. I haven't created a table by hand in more than a year now. It took a lot of programming to get it to work, though. We have had success with interbase, informix and paradox tables. Which leads me to this question : Have anyone had success with an object oriented database and Delphi?. Dennis Fantoni Senior Delphi Developer Danasoft A/S df@image.dk
Technical Details
Message-ID:
<O3OD2.262$RF.2724@news020.image.dk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<ckJt2.1382$57.870@typhoon.mbnet.mb.ca> <36C99418.EDC39500@cds-nv.be> <7bjcv8$jmq$1@news3.Belgium.EU.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 115d96,4748c9d03c6807e7 X-Google-Attributes: gid115d96,public From: "Dennis Fantoni(Work)" <df@image.dk> Subject: Re: Write Delphi code to restructure a table??? Date: 1999/03/05 Message-ID: <O3OD2.262$RF.2724@news020.image.dk> X-Deja-AN: 451502611 Content-Transfer-Encoding: 7bit References: <ckJt2.1382$57.870@typhoon.mbnet.mb.ca> <36C99418.EDC39500@cds-nv.be> <7bjcv8$jmq$1@news3.Belgium.EU.net> Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Complaints-To: news-abuse@image.dk X-Trace: news020.image.dk 920628590 194.234.182.197 (Fri, 05 Mar 1999 11:09:50 MET) MIME-Version: 1.0 NNTP-Posting-Date: Fri, 05 Mar 1999 11:09:50 MET Newsgroups: borland.public.delphi.database