Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do you RLOCK?
Message
From
20/10/2003 17:36:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00837183
Message ID:
00840480
Views:
37
>I hadn't seen any purpose for me to use data buffering until I just read the post from Martín on another thread I have going. It never dawned on me that I could get a speed increase from using it. I'm gonna give it a go. :)

I don't really know about speed. But I do use it to trap errors, before VFP traps me.

Consider this example:
append blank
replace;
  Field1 with Value1,;
  Field2 with Value2
* or: gather name, etc.
Without buffering, the first command can easily cause an error message, because some rule is violated (the field has to have a value).

With buffering, you can postpone this validation until you have all the data ready, and then issue TableUpdate().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform