I have a table in a database and I want to access the latest 10 records which were added.
Table name : discussions
number - incremental number
headline - text
article - memo
numitems - integer
The number field increments for each record that is added and say there are 100 records I would like to retrieve record 100 down to 91 in that order using the 'number' field to find out the latest/highest records.
I would like to get this information into variables inside a VB6 program so I can process it within my program.
Any ideas anyone ?