Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last NN entries
Message
 
 
To
10/05/2000 08:46:05
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00368038
Message ID:
00368044
Views:
21
>Hi
>
>Can anyone tell me if there is a way of filtering a table to the last NN entries in the table?
>
>Thanks

Kev,
If your PK is sequential (integer or character), you could use the TOP clause of the SQL Select command after ordering it by PK descending. If you are looking at modifications as well as insertions, then you would have to introduce some type of auditing feature to your tables. Take a look at FoxAudit at www.takenote.com.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform