Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only