Message
From
17/03/2010 09:59:56
To
17/03/2010 09:54:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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:
43
>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).
>
>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).