Hi Jocelyn, Just make a MapInfo macro (!) programmatically or in a good text editor with the following content : !Workspace !Version 400 !Charset WindowsLatin1 Alter Table T001 (Add NEW1 Integer,NEW2 SmallInt,NEW3 Char(7),NEW4 Date,NEW5 Float, ...etc... ,NEW40 Logical) Alter Table T002 (Add NEW1 Integer,NEW2 SmallInt,NEW3 Char(7),NEW4 Date,NEW5 Float, ...etc... ,NEW40 Logical) Alter Table T003 (Add NEW1 Integer,NEW2 SmallInt,NEW3 Char(7),NEW4 Date,NEW5 Float, ...etc... ,NEW40 Logical) Alter Table T004 (Add NEW1 Integer,NEW2 SmallInt,NEW3 Char(7),NEW4 Date,NEW5 Float, ...etc... ,NEW40 Logical) ...etc... Alter Table T300 (Add NEW1 Integer,NEW2 SmallInt,NEW3 Char(7),NEW4 Date,NEW5 Float, ...etc... ,NEW40 Logical) Exchange T001 - T300 with your own table names, and exchange NEW1 - NEW40 with your own column names and types. The above macro requires that the tables are opened in advance. Otherwise you'd need to add "Open Table" statements above. Save it with a .WOR extension. Run it using MI Pro menu item "Add workspace...". If you're uncertain about the exact syntax needed (given in the MB ref.manual), I can provide it for you. Best regards Lars Nielsen ********************************************************** Lars Nielsen [EMAIL PROTECTED] Development Manager, MapXtreme iGIS Specialist Kampsax / MapInfo GIS, Odense http://www.mapinfo.dk Authorized MapInfo Partner & Distributor in Denmark Address: Rugaardsvej 55, DK-5000 Odense C Telephone: +45 6313-5000 Facsimile +45 6313-5090 ********************************************************** "Jocelyn Charbonneau" <[EMAIL PROTECTED] Til: [EMAIL PROTECTED] 400.gc.ca> cc: Sendt af: Vedr.: MI-L MI - Update fields automatically? [EMAIL PROTECTED] nsmag.com 05-02-01 19:52 Besvar venligst til "Jocelyn Charbonneau" Hello all, I have to update 300 similars Mapinfo's table. For each table I must adding 40 empty fields.... Does anybody knows how update these files without adding one by one each 40 fields in each 300 Mapinfo's tables with Table Structure Function? ty Joe _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
