General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MS SQL locks up from Foxpro??????
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??????????
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only