Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Buffering not supported in VFP 7 using MSSQL
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00752417
Message ID:
00752518
Views:
19
>>It's a normal behavior (and also a Feature), I'm pretty sure you are using Record Buffering (3), and as default it came with an Implicit TableUpdate() when you SKIP records. If you want to No-Save records while you are skipping, try Optimistic Table Buffer (5).
By the way Remote Views have Implicit Transaction.

>Even if you set Buffering to 5 changes are sent back to SQL Server everytime I skip to the next record.


I have all my details Views settings at Buffering 5 and I don't have this behavior. My Servers are MS-SQLServer & MySQL. So, I don't really know what's happening with your views but I could bet Buffering 5 always works as it should do.
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform