How about: UPDATE Copy_KGH_Surgeries_LHA SET Elective_vs__Urgent = 1 WHERE RTRIM&( Elective_vs__Urgent) = 'Elective'
Because Elective_vs__Urgent might be, say, 'Elective '. Terry -----Original Message----- From: Ronning, Christine [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 19:31 To: Terry McDonnell Subject: MI-L Can't update field Hi again, Sorry but I'm pretty new to using SQL so these questions are probably pretty easy to figure out. I would like to create pie charts for each geographic region that will show elective vs. urgent surgeries. As far as I can tell I will need to do this with a numeric field so I'm trying to change all 'elective' strings to 1 and 'urgent' strings to 2. I've used the syntax written in MapBasic below: UPDATE Copy_KGH_Surgeries_LHA SET Elective_vs__Urgent = 1 WHERE Elective_vs__Urgent = 'Elective' When I try to update the message I receive is "Cannot perform this function on field Elective_vs__Urgent" Does anyone know why or what I can change so I can update? Thanks again, 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: 15955 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15963