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