Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote cursor update in SQL Server 2005
Message
 
 
À
17/03/2010 09:54:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01455035
Message ID:
01455079
Vues:
41
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform