Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Buffering cursors
Message
De
11/12/2013 10:39:34
 
 
À
10/12/2013 11:15:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01589683
Message ID:
01589864
Vues:
61
I have no idea, but it isn't needed. Buffering is a way to protect the actual DB from changes until you commit. But if you're using SQL Server and reading into cursors (or views, which essentially are the same thing), the cursor acts as a buffer.

If you then buffer the cursor, you're doing double-buffering. I can't think of any reason to do it.


>Why would one do this?
>
>Scenario:
>
>Data is pulled from SQL server into cursor for an individual
>Cursor is then buffered
>Cursor is updated from input form (there is no update/commit on the cursor, just replaces)
>SQL server is updated from cursor.
>Data is repulled from SQL server into cursor for the same individual
>
>We have instances where (at least) one field is not making it 'back' from SQL server and is causing issues further downstream in the process and, of course, it's only happening on occasion.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform