Christine,
MapInfo does not support that "advanced" a Where condition on the Update
command, so you'll have to select the records to update and then only update
these selected records:
Select * From FACILITIES_TEST2
Where SERVICE_TYPE = "H"
Into TO__UPDATE NoSelect
Update TO__UPDATE
Set MAPPING_TYPE = "A"
Close Table TO__UPDATE
HTH,
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
-----Original Message-----
From: Ronning, Christine [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26, 2005 8:54 PM
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: 16584
