Hi

We are using DBISAM for a small image registration service in our office.
The service is called by our isapi extension to lookup images etc.

I want to fetch the last 10 images registered from the database-- but im not
sure about the most efficient way of doing this with SQL and DBISAM?

the table is simply called "files" and it has a DateTime field called
"made". Also an autoinc ID field and title field (perhaps that is the best
to query?).

Any help or hints is very welcome.

Kind regards

Jon Lennart Aasenden

Jon


DBISAM has a TOP command but not a BOTTOM so you have to stand the problem on its head

Something like

SELECT * FROM table ORDER BY datefield DESC TOP 10



Roy Lambert [Team Elevate]

That did the trick.

Thank you for your help!

Kind regards

Jon Lennart Aasenden
Norway


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:CFC472CE-898A-4854-93D3-637285AEC589@news.elevatesoft.com...
> Jon
>
>
> DBISAM has a TOP command but not a BOTTOM so you have to stand the problem
> on its head
>
> Something like
>
> SELECT * FROM table ORDER BY datefield DESC TOP 10
>
>
>
> Roy Lambert [Team Elevate]
>