It does work great. Anyway to do this to all map windows at once, instead of just one at a time?
S�ren Lindqvist <[EMAIL PROTECTED]> writes: >Lars > >Many thanks, works like magic, no need for MapBasic. Great. > >Regards >S�ren > >-----Ursprungligt meddelande----- >Fr�n: Lars V. Nielsen, GisPro [mailto:[EMAIL PROTECTED] >Skickat: den 10 september 2003 17:29 >Till: S�ren Lindqvist >Kopia: [EMAIL PROTECTED] >�mne: Re: MI-L Update table with sql > >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: 8332 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8353
