Dear list I got loads of sql questions (about 60) when updating table. Is there a possibility to run through all this at once instead of hitting enter buttom for every row in MapBasic window?
If yes, how is it done or written? My sql looks something like this Select * from tableA where class = "1" And area = "46" And land = "16" into tableAB Update tableAB Set town = "100" Update tableAB Set pop = "1000" close table tableAB Select * from tableA where class = "2" And area = "44" And land = "20" into tableAC Update tableAC Set town = "200" Update tableAC Set pop = "2000" close table tableAC Etc. Etc. Regards Soren --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8324
