>
>In this layout, it really makes sense. When I think further, it's just a very smart strategy. I'm just wondering how do you find a random deleted record? I guess it's something like
>Set Order to Deleted
>Seek .t.
>count next rand()*100 while deleted()
>if deleted()
> do your_thing
>...etc
>
>Or you've come up with something better?
>
Hi Dragan,
How about something like...
x= INT(RAND()*RECCOUNT()) + 1
GO x
LOCATE REST FOR DELETED()
IF ! FOUND()
LOCATE FOR DELETED()
ENDIF
might be a little faster??