I am trying to use Foxpro to add & update some SQL files.

I have a remote view called userids and I have ALL fields checked in the “Update Criteria” and the box checked for “Send SQL updates” and I have tried checking the Update using both ways (SQL DELETE, Then insert and also SQL update).

When I do a browse of the table it works OK, but if I try to append or append blank (add a new record), it seems to work until I try to close the file and I get and error that says

Connectivity error [Microsoft [ODBS SQL Server driver][SQL Server]incorrect systax near the keyword ‘level’.

The field level is the last field in a record.

After that, NO command works, not even quit or exit from the menu. The system is LOCKED. I have to do Ctrl Alt Del and shut task at least 4 or 5 times before it finally Quits Foxpro.

Any thoughts??????????