Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote cursor update in SQL Server 2005
Message
From
17/03/2010 09:54:19
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01455035
Message ID:
01455077
Views:
51
The error is 1491, http://msdn.microsoft.com/en-us/library/aa976103(VS.71).aspx

According to this, the base tables haven't been declared, yet the following commands return .T.

? cursorsetprop('Tables', 'TestTable')
? cursorsetprop('Tables', 'dbo.TestTable')
? cursorsetprop('Tables', 'NursingPersonnel.dbo.TestTable')

I have tried with all 3 commands to make sure that the DB operator wasn't also required.

Is there anything specific I need in my stored SQL procedure to allow the returning dataset to be updatable?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform