Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering in VMP form
Message
From
23/11/2017 18:00:41
 
 
To
23/11/2017 16:26:41
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Database:
Visual FoxPro
Application:
Desktop
Virtual environment:
VMWare
Miscellaneous
Thread ID:
01655793
Message ID:
01655796
Views:
61
>>I tested 3 and 5 and it seems to not make a difference. The other thought was whether it matters performance wise or not if it is 3 or 5 (does VFP somehow have to scan all rows for changes if it is a 5?).
>
>That depends on the 1st parameter in tableupdate() - check to see what your framework uses there. It may go one record at a time so it can check each record (postsave etc) or do them all at once and then get recno()s (of those causing an error) in an array (last parameter of tableupdate()) or it may not even care. Look under the hood.

Disagree. Unless reasons are given for a specific problem, ***always*** use table buffering - if biz logic needs working via single record tableupdates, implement logic to fire for each record - do not let possible "vfp-automatic" record pointer move fire record saves.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform