>Even if you restore it before the ENDSCAN? I've never had problems in doing so.
>
>Vlad
>
>>There is one subtle difference between SCAN/ENDSCAN and DO WHILE. Don't move the record pointer of the table being scanned. It gives really unpredicatble results.
If you restore it, it works. However, I've always avoided doing that.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer