RE: [MI-L] Re: Help: MapInfo Update Query [SEC=UNOFFICIAL]
SMITH,Stephen (ACT)
Unofficial
Use the update command in the Mapbasic window inside MapInfo to update many columns.
Example:-
Update MyTab set Lat =centroidx(OBJ) , Long=centroidY(obj) , ObjType =STR$(OBJ)
Regards
Steve Smith
Geospatial Intelligence & Support
Research Branch
Social Policy & Economic Strategy Group
Dept of Education Employment and Workplace Relations
email:- Stephe...@DEEWR.gov.au
Wk:- (02) 6240-9048
Location:- Level 5, near C11
50 Marcus Clarke St, Canberra City Act 2601
GPO Box 9880 Canberra Act 2601
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Richard Greenwood
Sent: Thursday, 23 May 2013 6:05 AM
To: Theudys Mejia; mapinfo-l
Subject: [MI-L] Re: Help: MapInfo Update Query
I am sorry to say that I have never found a way to update more than one column at a time in MapInfo. It seems like a most unfortunate shortcoming. I am cc'ing mapinfo-l in case there is a solution.
Best regards,
Rich
On Wed, May 22, 2013 at 9:45 AM, Theudys Mejia <theudy...@pisgahti.com> wrote:
Dear Richard Greenwood,
I am contacting you because I saw this post from 2/17/2008 on a Google forum asking how to query more than one column at the same time using MapInfo. Here is a copy of the post you made:
I would like to update more than one column with a single SQL
statement but it appears that MapInfo only allows updating one column
in a SQL statement. Am I correct about this? Can anyone suggest a work
around?
Thanks,
Rich
--
Richard Greenwood
richard....@gmail.com
www.greenwoodmap.com
I am trying to figure out how to do the same thing on MapInfo but I have yet to find an answer. I tried using the Update Column option under the Table tab and then tried the option Expression (see attached). However, in the text box I could not type more than a few characters. I would like to know, if you have already found an answer? And if yes, where do I exactly type the syntax to do the query? Please, if you have the time to assist me on this I would deeply appreciate it since I have tried but failed miserably.
Best regards,
Theudys Mejia
Engineer Assistant
EDS / Pisgah Telecommunications Inc.
Authorized FiOS Contractor for Verizon
(O) 718-993-3241
(F) 718-993-3486
(C) 646-260-2658
--
Richard Greenwood
richard....@gmail.com
www.greenwoodmap.com
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Notice:
The information contained in this email message and any attached files may be confidential information, and may also be the subject of legal professional privilege. If you are not the intended recipient any use, disclosure or copying of this email is unauthorised. If you received this email in error, please notify the sender by contacting the DEEWR Switchboard on 13 33 97 (1DEEWR) during business hours (8am - 5pm Local time) and delete all copies of this transmission together with any attachments.