sqlextendedfetch - movelast

[sprot]

Desperately trying to find a way to move fast to the last record in a recordset.
I use the odbc sqlextendedfetch function with the option SQL_FETCH_LAST. For some reason this seems to be a very slow way to get to the last record in a recordset.
When executing this statement, every record is being fetched until the end of recordset is reached. "Select count(*)..." is no solution to the problem.
Can anybody help me with this problem.

P.S. I don't want to use the MFC classes.

Many thks in advance.

Perhaps SQLFetchScroll will work faster. Have you examined the index(s) on the table?

Good Luck.

[sprot]

Can't find info on SQLFetchScroll function...
(Using VC++ 5)