sprot
September 2nd, 1999, 10:36 AM
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.
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.