You have to change the name of your field. Level is a keyword in SQL Server and any SQL command using this field will fail because of this.
FWIW, I had to do the same thing when I migrated a VFP application to SQL Server and I had a USER table. USER is a keyword so I had to change it to USERS.
>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??????????
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao