Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Filter
Message
De
26/09/2017 08:52:23
Mike Yearwood
Toronto, Ontario, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01654550
Message ID:
01654570
Vues:
51
>Hi,
>
>I am going back in time :)
>
>I need to - temporarily in IDE - process some records of a .DBF table. I need to see only records that meet certain criteria. For example where some field is EMPTY. If I use SET FILTER TO I see there records but as soon as I make an entry in this field, the record is gone (because it is no longer matching the SET FILTER). How can I make these records, initially selected with SET FILTER TO stay on the screen so I see what entries I made? I need a quick a dirty approach, not views and other approaches. Possible?
>TIA

In the records that you edit, put a single value. SET FILTER TO YourCriteria and ChangedFieldName = SingleValue. EMPTY is not Rushmore Optimizable.

Then when you're done, you can see all the changed records. If you need to codify the SingleValue, add data to the end of the field.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform