Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote cursor update in SQL Server 2005
Message
De
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:
01455077
Vues:
52
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform