Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffered table versus not buffered table
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01315862
Message ID:
01315867
Views:
22
>I have a buffered table in a form which works fine. But, I need to print out from this table multiple specifications data, which is easy to do. I added a field to the table called SELECT, which the user can select (no pun intended) by clicking on a check box for each record the user wants. I plan to do a SQL Statement to gather up the records which have their SELECT field as TRUE and then print those in a REPORT FORM.
>
>I added an "UN-CHECK ALL" Button, but I am not sure which is the best way to go. Do I need to temporarily turn off the buffering to un-check ALL records, such as with a REPLACE ALL SELECT WITH .F. ? and then turn the buffering back on for the table, or is there a better way to do this? My SAVE button will turn on (ENABLE itself) as soon as it sees any changes in any record.

No, why?
REPLACE ALL SELECT WITH .F. will work on buffered table also.
The only thing you must have in mind that when you perform SELECT * ... from that table you should use WITH (BUFFERING=.t.)
and if you want to replace only these records where select=.t. then use:
REPLACE ALL SELECT WITH .F. FOR Select

BTW SELECT is not the best choice for field name :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform