Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote cursor update in SQL Server 2005
Message
 
 
To
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:
01455079
Views:
40
>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?

Did you try it as a simple select for now (not as a stored procedure)? I'm not sure, I just compared the code we have with yours and I don't see much difference, but also we use direct sql commands (which I think is worse from security point of view).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform