>>>Thanks in advance for any suggestion
>>
>>You could use TOP clause of SQL:
>>
>>
>>currentkey = crsr.key
>>SELECT TOP 1 * FROM table WHERE table.key>currentkey INTO CURSOR crsr
>>
>>
>>this works for next record and use < for previous record.
>>
>><\PRE>
>
>Thanks to all for your ideas,
>In this weekend I've thought to something like to Fred's suggestion.
>Can you tell mes something about no-batch mode to have the SQL results usign the SQLMORERESULT(), doesn't it seem like to skip record by record ?
>
>Thanks
Im not familiar with the use of SQLMORERESULTS(). From its description, if you're set to retrieve 1 record at a time, it sounds like that may work. But I have no idea what kind of impact that has at the back-end, it that keeps SQL server tied up or not, waiting for your next request to deliver the next result set. All I can say is, try it!
