Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
How to update the fields of record in a old table |
Wed, May 12 2010 11:42 AM | Permanent Link |
Carlos | 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 |
Wed, May 12 2010 9:37 PM | Permanent Link |
Gregory Sebastian | 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 |
Thu, May 13 2010 3:38 AM | Permanent Link |
Carlos | "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 |
Thu, May 13 2010 2:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 13 2010 8:05 PM | Permanent Link |
Gregory Sebastian | 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 |
Tue, May 18 2010 2:55 PM | Permanent Link |
Don Patrick | 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 > > > |
Thu, May 20 2010 8:55 AM | Permanent Link |
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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |