Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Filter
Message
 
 
À
26/09/2017 21:07:47
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:
01654608
Vues:
46
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform