I was able to Declare a cursor and then do a fetch with a certain Index using SQL 7.0 Query Analyzer. The reason for doing this is that I want to step through a huge table one row at a time.
Is there a way of doing this from VB? Using ADO and record sets have been a nightmare. The select is too complicated and SQL ends up doing a full Table scan.
I am using VB6 and SQL 7.0.