>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 ?
ThanksRenato Bertuol (EMail:renato.bertuol@elmec.it
Homepage:www.geocities.com/SiliconValley/Horizon/3216)
Elmec Informatica (URL www.elmec.it)