Probably from the SQL SELECT: FULL OUTER JOIN. I know using a keyword as a field can cause quirky things to happen, even when from my perspective there is no reason for VFP to not be able to tell the difference in the particular situation.

Best idea is to change it, if that's possible.

Michelle

>Before I go and change all the table/view structures I thought I would ask about this first. There is a logical field called FULL. If it is modified and a TableUpdate is triggered it will return "Syntax error." It makes no difference whether the value is changed or not; just modifying it and then changing it back will still cause the error if the record pointer is moved from that record. Buffering is set to Optimistic Row. I wonder if FULL is a Keyword? It appears so according to my syntax coloring in the Command Window, but the help does not say it is. There are other commands, FULLNAME, FULLPATH, etc. that are though. Why would I get a syntax error on this anyway? Thanks!
>
>Regards, Renoir