>Hi Michelle,
>It's normal behaviour in FP (all versions AFAIK). If the same variable name exist in the table that's open in current workarea then table fieldname takes precedence. To avoid it you must alias the memvar with "m.".
>* Table mytable has fields clname and cfname
>clname = "aaaaaa"
>cfname = "bbbbbb"
>use mytable
>select 0
>? clname,cfname
>select mytable
>? clname,cfname
>? m.clname,m.cfname
Cetin
Sigh. Everyone seems to be missing the point. Or does it seem to be such an obvous question that no one is actually reading what I'm saying?
The variable name and the field name are _NOT_ the same. If it was, this would be a no brainer. One is "lname" and one is "clname".
Sorry if I sound cross. I'm just getting a bit frustrated.
Thanks,