Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid performance. Need more help
Message
From
28/05/1998 03:04:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/05/1998 02:55:16
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00101832
Message ID:
00102640
Views:
16
>>Carlos, you can store the record number of the active row in a form property, and compare the stored value with the new one in AfterRowColChange. If the row is changed, go to the old one, do your calculations then return to the new one and store the value. There's probably a simpler way - I'll think about it.
>>
>>Barbara
>
>Barbara, the problem is biggest: each time the user adds an item and validates it with the command button, i ask him to save changes, if yes =tableupdate(), if not =tablerevert(). With rowbuffering that's not possible. In the aftercolchange event, record has yet updated and i can't revert.
>If the user changes values of a record, i need to know the oldest values via oldval(). With rowbuffering, in the aftercolchange that's not possible.
Carlos,
When using beforerowcolchange (a class of mine was for that but under revision now) besides key capturing you could capture mouse with mdown() + mcol, mrow. Complex for the moment I try to classify it. If your VFP version uses Spanish messages (I can't use because there is no Turkish version) then only table valid could handle your situation.
Another thing I do is to use table buffering instead of row buffering. And finally you could keep all the editing in a transaction and therefore could rollback even all tableuodated.
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
Next
Reply
Map
View

Click here to load this message in the networking platform