Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Result of a SQLEXEC is a view instead of a cursor
Message
De
06/10/2002 21:46:28
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00708247
Message ID:
00708249
Vues:
8
>I am using SQLEXEC to get the data from a SQL Server and I found out that the returned cursor (according to VFP doc) is set to ROW_OPTIMISTIC_BUFFERING mode and I cannot remove it in any way.
>
>This sort of behaviour is only happens with views and I am not sure whay with the results of a SQLEXEC?
>
>Does anybody know how to remove the buffering?


Try:
SELECT MyCursor
CURSORSETPROP("Buffering",1)
Is that what you are looking for?


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform