Hello Christine,
MapInfo's Update statement is a little different to other SQL based updates.
Looking at the manual it shows that it only supports the "Where RowID"
condition.
A simple way around this is to run the select Query.
select * from Facilities_Test2 where Service_Type = "H" into temp
then
update temp set Mapping_Type = "A"
This should make the changes back to the Facilities_Test2 as temp is only a
filter or view of the Facilities_Test2 table.
cheers,
Geoff Pearce
Road Management Systems Officer
Pyrenees Shire
5 Lawrence St
Beaufort 3373
Phone (03) 53492000
Fax (03) 53493019
-----Original Message-----
From: Ronning, Christine [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 May 2005 4:54 AM
To: [email protected]
Subject: MI-L Updating a field
Hi all,
I'm trying to update the mapping type field for one of my tables based
on the service type.
I have used the following:
Update Facilities_Test2 Set Mapping_Type = "A"
This works fine. However the following does not:
Update Facilities_Test2 Set Mapping_Type = "A" Where Service_Type = "H"
Any ideas? Thanks,
Christine
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16585
