Hi S�ren, Just put them into a text file, and add 3 line in the top with this content (maybe even just the first) : Line 1 : !Workspace Line 2 : !Version 300 Line 3 : !Charset WindowsLatin1
Save with a "wor" extension. Run "Add workspace" in Pro, select your file and magic happens :-) Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ http://www.gispro.biz/ http://hjem.get2net.dk/lars-online/ WGS84: 10.26'40"E 55.20'20"N ----- Original Message ----- From: "S�ren Lindqvist" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 3:53 PM Subject: MI-L Update table with sql > 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 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8330
