Rnd in a query 1

[matrixindicator]

I use the Random Function Rnd in a query.

      AdRandomNr = Int((243365 * Rnd) + 1)

However in the query I got always the same number for every row (so its not a random number). eg. 178596.

What is missing ?

 

[matrixindicator]

He always takes the actual time or seconds.
Is there a fuction to get the actual milliseconds ?

 

[mikej336]

You might want to post some more code and let know what you are trying to accomplish.

Mike

 

[matrixindicator]

well infact nothing more then an expression to get a random number via the function in a query. He always produce the same number (far from ad random). I looked up the function on the web.

Expr1:Int((1500000-1+1)*Rnd()+1)

The value should be an Integer (so not more then 32000 ?) or is 1.500.000 not a problem ?

 

[randy700]

Check this site:
What's this fuss about true randomness?


Randy

 

[MajP]

I did not see the answer in Randy's link, but the reason is that the numbe is generated once. Here is a solution

http://www.rechtman.com/randsql.html

 

[matrixindicator]

MajP, thanks,

I did no test it already but it have the idea that is a good answer (solution) to this problem.

 

[matrixindicator]

I tested one of the solutions (the update query) and it works fine even on 1.500.000 records.