Hi Jason,
Here's one relatively simple way of creating a batch file in MapInfo. This technique
can also be useful for doing other batch tasks.
1. In MapInfo, close all your tables and open only the tables you want to alter.
2. Create a new blank browser with a long char column in it (say 250 characters).
3. Create a blank row in the new browser for each table you want to alter. This
can be done quickly by pressing <Control>+E repeatly.
4. Use the "Update Column.." command to add the following value to the blank
column in the browser.
"Alter Table """ + TableInfo(RowId,1) + """ (Add {Column Name1} {Type1}, {Column
Name2} {Type2} ...etc )"
(if you're unsure of the syntax, alter one table with the mapbasic window
open to get the correct syntax)
5. Now Copy and Paste all the rows from the browser into the MapBasic window.
Highlight them in the MapBasic window and press Enter.
Hope this helps.
Regards,
Peter.
+++++++++++++++++++++++++++++
[EMAIL PROTECTED]
http://www.spatialplus.com
Spatial Plus
+++++++++++++++++++++++++++++
>
>Dear List-
>
>I've got several dozen tables, and all have the same table structure. I
>need to add 4 columns (all exactly the same) to each of these tables. Is
>there any way to do these all at once, or do I need to modify each table
>individually?
>
>Hope I'm making myself clear.
>
>Thanks in advance,
>
>Jason McMahan
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
