Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Result of a SQLEXEC is a view instead of a cursor
Message
From
06/10/2002 21:46:28
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00708247
Message ID:
00708249
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform