Hello Tadi, Make a copy of any workspace you have and open that copy in a texteditor like Notepad for example. Remove everything except for the 3 first lines that says !Workspace, !Version 600, !Charset WindowsLatin1. Then put your SQL query in the next rows. I did also put in a note telling the process is finished. Open your "myTable" and then Open your new created workspace and it should start to run through your SQL querys. Example:
!Workspace !Version 650 !Charset WindowsLatin1 Select * from myTable where HOUSE = "1" and CAT = "2" and DOG = "N" and KIDS = "2" into NewTable Update NewTable Set Husband = "1", Wife = "1" close table NewTable Note "Process finished" Regards Soren -----Ursprungligt meddelande----- Fr�n: Tadi Seetharamayya [mailto:[EMAIL PROTECTED] Skickat: den 14 september 2003 07:53 Till: Svren_Lindqvist �mne: Re: SV: MI-L Update table with sql Hi soren i have the same prob.. i saved them the text file as Wor Extension. can you tell me know i can now run that workspace.. where shd i do that.. thanks for ur time ram --- S�ren_Lindqvist <[EMAIL PROTECTED]> wrote: > 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 > ===== Seetharamayya Tadi GIS Database & Systems Administrator Anglo American plc. Udaipur - INDIA Ph # :- 0091-0294-433123 E-mail: [EMAIL PROTECTED] __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8377
