Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding data in table
Message
From
17/03/2003 14:57:11
 
 
To
17/03/2003 14:53:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00766682
Message ID:
00766684
Views:
21
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform