>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
yes FULL is a reserved word, I woould shy away from using any reserved word.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope