Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Buffering not supported in VFP 7 using MSSQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00752417
Message ID:
00752518
Vues:
12
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform