>>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
>
>Here's a different approach using older technology
>
>
>Assuming that your table has a primary key you can do something like
>SELECT myTable
>SET ORDER TO primaryTag
>BROWSE
>
>SELECT * FROM myTable WHERE <some field is EMPTY> INTO CURSOR curHold
>SET RELATION TO keyfield INTO myTable
>BROWSE
>
>You can now select record by record in your derived cursor and then go back and edit the main table.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham