Agreed - give those stars to Hugo. Much better answer!
Regards,
>>I am not sure why You need to use the Key for this, I would think that you leave your program open for an "endless" loop, for example your Key lenght allows 100.000.000 different records while you "only" have less than 2.000.000 records in the table, thus leaving a probability of 1/50 of getting a valid key.
>>
>>If you think that the select statement can be slow, why don't you just generate a random record number?
>>
>>
>>Rand(-1)
>>lnRecno = Int(Rand() * Reccount('Table')) + 1
>>go lnRecno in Table
>>lcKey = Table.key
>>
>Hey Hugo
>
>You're completelly right.. Pretty nice your solution.. Even better than Jim's solution for sure..
>
>Thank you.. I already gave Jim the tree stars.. But, feel as you also got it !!
>
>:)
>
>Claudio
Jim