Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding data in table
Message
De
17/03/2003 14:57:11
 
 
À
17/03/2003 14:53:16
Billy Bramhall
Interdirect Usa, Inc.
Houston, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00766682
Message ID:
00766684
Vues:
20
>I would like to find (and print) the last record in a table that has specific data.
>
>Example: a table consisting of 300 records, record numbers 3, 41 & 250 has the field (field.computer) populated with the name "hellcat". I would like to find/print record number 250. (The tricky part of course is, I do not know that recno()=250 has the data I need.)
>
>Any help on the proper syntax is greatly appreciated.
>
>Thanks,
>Billy

if you have an index on that field in your table you can try this:
SET ORDER TO MyTag DESCENDING
seek "hellcat"
this should give you the 'last' entry

hope this helps
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform