RANDOMIZE

[Silvio.Falconi]

I have a dbf with some record and I must take a record from this archive but on randomize
How I can make ?

[sambomb]

Select YOURDBF
DbGoTo( nRandom(LastRec()-1)+1 )

nRandom is 0 to nParam
LastRec() is your total recs
You need the -1 on LastRec to compensate the 0 start from nRandom and the +1 is to compensate the -1

[Silvio.Falconi]

NRANDOM HAVE PROBLEM
i REMEMBER THERE WAS ANOTHER WITH HB_

[BeoBeo]

Why u cry

[sambomb]

I never had a problem with nRandom, but...

DbGoTo( HB_Random(1, LastRec() ) ) should solve too.

[James Bott]

I think you are going to need to convert the values to integers.

And, I assume for what you want you will need to generate an array so you can check for duplicates and not add them. You are looking to create an array of unique values.

James