Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Buffered table versus not buffered table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01315862
Message ID:
01315867
Vues:
24
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform