Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter
Message
 
 
To
26/09/2017 21:07:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01654550
Message ID:
01654608
Views:
45
>>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  && Or do an INDEX ON to primary key field if needed
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform