🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.database
Article #1978

Re: Write Delphi code to restructure a table???

#1978
From: Dennis Fantoni(Work)
Date: Fri, 05 Mar 1999 00:00
30 lines
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-mail
References: <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