Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uncommitted changes in buffered data
Message
From
03/08/2006 07:51:40
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/08/2006 06:51:40
Richard Candeland
Richard Candeland Software Services
Keighley, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01142637
Message ID:
01142648
Views:
9
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform