Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter
Message
From
26/09/2017 08:52:23
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
25/09/2017 17:07:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01654550
Message ID:
01654570
Views:
52
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform