>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