>I am unsure what you are trying to accomplish. Could you please explain a little more?
>
1. draw a randon number among 1 and the number of records
2. go to the found record number
3. grab it data and process

>>
>>Thanks for your repli.. I have a routine to calculate a number (makes a draw) and to skip to that specific number.. So, on this case the best (or the only) option will be:
>>
>>

>>nwret=SQLexec(privCone, "SELECT * FROM `mytable` limit "+allt(str(nmydraw))+",1)"
>>

>>
>>Is that right ? Or that is anything better ?
>>>>
>>>>

>>>>nReco = 10
>>>>goto nReco
>>>>

>>>>
>>>>Is there something similar on mysql for the above issue ?
>>>>
>>>>What about reccount() !! Only using "select count(*).." or there is some other way to have it ?
>>>>
>>>>TIA
>>>>
>>>>Claudio