Hi All!!

How can I get dbexpress in delphi to return only the selected amount
of rows in the recordcount and not process the entire database and
return the entire recordcount for that database?

I use a simple TSQLQUERY component with :

SELECT FIRST 5 IndexKey,AccountNo FROM TARIFF
WHERE IndexKey >= '020110 '
ORDER BY IndexKey;

But with this I get a resultant recordcount of 8000 and not 5!! As a
result our program is hellishly slow!!

Please help!!

Thanx!!

Harry Roets!!