>Eric,
>
>The field name is DESC and the field is updatable and the AERROR() returned:
>
>10 - "Syntax Error"
>
>I will change the field name to something else and try again. I gave up last night and didn't get back on till this morning.
>
>Thanks
I am 100% sure that this is the problem. VFP is usually ok with field and variable names that are VFP keywords, but using an SQL keyword (DESC is short for descending) as a field name is bad news because the SQL engine can't make sense of it. (As you know, doing a TABLEUPDATE on a view causes VFP to build and execute an SQL UPDATE statement, inevitable containing your field name).
Erik Moore
Clientelligence