Hi Try to define a n ALIAS for the column:
Dim ColAlias as Alias ColAlias = AC.Action and use that in your loop instead of the direct reference AC.Action Regards Thomas Brix Lyng Frederikshavn Municipal Administration Denmark -----Oprindelig meddelelse----- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sendt: 7. december 2004 20:51 Til: [EMAIL PROTECTED] Emne: MI-L Map Basic Runtime Error Hello, All Keeping in mind that I am New to MapBasic. I am trying to update an existing table from an new table (Called AC) where conditions exist in a column called "ACTION" in the new table. I have written the following program which compiles ok but when I run it I get the following error. [Variable or field Ac.phone_nbr not defined](on line 13) What am I doing wrong? Include "mapbasic.def" Open Table "EXISTING" Browse * from EXISTING Open Table "AC" Browse * from AC Fetch First From AC Dim i as integer i=0 Do While Not EOT(AC) If AC.Action="D" Then Update Existing Set Phone_nbr=AC.Phone_nbr End If Fetch Next from AC i=i+1 Loop ___________________________________________________________ Fidelity Communications Webmail - http://webmail.fidnet.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14411 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14526
