Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uncommitted changes in buffered data
Message
De
03/08/2006 07:51:40
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/08/2006 06:51:40
Richard Candeland
Richard Candeland Software Services
Keighley, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01142637
Message ID:
01142648
Vues:
10
>Can someone please tell me I'm not going mad.
>
>I have code attached to a 'cancel' button class to tablerevert any buffered tables open in the form. I have just accidentally bypassed this code and can't understand why I did not get an error code 1545 (table buffer contains uncommitted changes) when I click the cancel button. The table reverts without me doing anything. I've checked on VFP 6 and it is the same.
>
>Did it always do this? Or in the distant past (e.g. VFP 3) did this cause an error 1545? I don't have a copy fo VFP 3 to check this on. I'm wondering why I put this code onto the 'Cancel' button if this never caused a problem.
>
>.and given that VFP quite happily reverts the table itself when you close it, when would an error 1545 ever occur?

You want to create the error??? OK here is a simple way to create:

-Create a view (or use one from TestData)
-Use the view providing parameters if any
-Set buffering to table - ie: cursorsetprop('Buffering',5,'MyView')
-Browse and do any change
-Requery('myView')

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform