Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form.BufferMode versus DE.BufferModeOverride
Message
 
To
09/04/1998 05:03:50
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Poland
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00090702
Message ID:
00090758
Views:
26
>Imagine you have updatable local view with optimistic buffering (5). When you want to save changes to involved table, all you would to do is to issue TABLEUPDATE(.T.) on the view. But...
>The table musn't be buffered. If not, you have to issue second TABLEUPDATE on the updated table.
>
>The question:
>How to force the table to be not buffered in DE?
>
>Answer 1 (wrong):
> Set the form's BufferMode to '0-None'
> Set DE.table's BufferModeOverride to '1-Use Form Setting'
>
>Answer 2 (working):
> Ignore form's buffering setting - set '0-None' directly to DE.table.
>
>Do you know any other solutions?

Are you including the table in the DE? I just built a view, added it to a form, set buffering to 5, dropped it on the form as a grid, added a button with

IF !TABLEUPDATE(2)
MESSAGEBOX("Problem!")
ENDIF

and ran the form. I changed a number of records, clicked the button and the update worked. I verified the changes in the original table and the changes were there.

So it's not necessary to add the table the view is based on to the DE.

HTH,
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Previous
Reply
Map
View

Click here to load this message in the networking platform