How to update the fields of record in a old table to new fields list without
rewriting by hand all fields modified ?

Eg.
Old table with 3 fields: Name, City, Country
New Table with 5 fields: Name, City, Country, Address, age

Dbisam 3.30

Thank you

Carlos

Hi Carlos,
Not really sure what you mean.

1. If you want to append all records from all table to new table, you can
use the BatchMove code that was posted on 10/May/2010.

2. If you just want to add the 2 new fields to the existing table without
affecting all records already in the table, easiest to use SQL eg :

ALTER TABLE YourTableName ADD Address Memo;

Regards
Gregory Sebastian

"Gregory Sebastian" <gregorys@nospam-ezysoft-dev.com> ha scritto nel
messaggio news:5C6BAC01-61FE-4B02-A79A-91177E31EC41@news.elevatesoft.com...
> Hi Carlos,
> Not really sure what you mean.
>
> 1. If you want to append all records from all table to new table, you can
> use the BatchMove code that was posted on 10/May/2010.
>
> 2. If you just want to add the 2 new fields to the existing table without
> affecting all records already in the table, easiest to use SQL eg :
>
> ALTER TABLE YourTableName ADD Address Memo;
>
> Regards
> Gregory Sebastian

The 2nd answer....

Yes, sure.
I apologize, I have not explained well

I wanted to know if there is a utility that read the structure of an old
table and comparing the structure of the new table, generate the appropriate
SQL command.

....and if possible for all table in the folder.... This is my dream !!

Thank you in advance

Carlos

Carlos,

<< I wanted to know if there is a utility that read the structure of an old
table and comparing the structure of the new table, generate the appropriate
SQL command. >>

There are some tools like this for DBISAM 4.x and ElevateDB, but I'm not
sure about DBISAM 3.x.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Carlos,
See the post : " 09/May/2010 - Re: Deploying NEW table structures -- Best
Way"  By Robert K. This is the same technique that I have been using since
DBISam 3 and now with DBIsam 4 as well.

If your upgrade involves adding new tables, use the Reverse Engineer feature
from the Database System Utility to help with the SQL so you don't have to
write everything by hand. If you just want to add or redfine fields on
existing tables, just use the ALTER TABLE SQL. I'm not aware of any tools/
utility.

cheers
Gregory Sebastian

Here's a link to an old component not a utility but it does what your
looking for.  Maybe with a few tweaks you can get it to work with your
version of Delphi.

http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_binaries&page=1&msg=313#313


"Carlos" <carlos@gmail.com> wrote in message
news:C2EA1A81-ACE8-4D7B-9B2E-ACFED810439E@news.elevatesoft.com...
> How to update the fields of record in a old table to new fields list
> without rewriting by hand all fields modified ?
>
> Eg.
> Old table with 3 fields: Name, City, Country
> New Table with 5 fields: Name, City, Country, Address, age
>
> Dbisam 3.30
>
> Thank you
>
> Carlos
>
>
>

"Don Patrick" <donpatrick@cox.net> ha scritto nel messaggio
news:0CAF76B8-3615-4B64-887A-F6E527B8A528@news.elevatesoft.com...
> Here's a link to an old component not a utility but it does what your
> looking for.  Maybe with a few tweaks you can get it to work with your
> version of Delphi.
>
> http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_binaries&page=1&msg=313#313
>
>

Thank you !!
I downloaded and installed this utility after a minor adjustment
And now I will try it.

Carlos