Update and Rand() Doesn't work?

[Ivan Smahin]

Hello Antuan,

Saturday, June 13, 2009, 9:06:06 AM, you wrote:

> Is there a reason the update query doesn't work with the random
> function? Just wondering if this is a bug or not, because I'm not
> quite sure of the purpose of the Rand() function if it can't update
> as well. It works technically but it always returns the same value - that's not random.

> Update TableA Set FieldA=  RAND() 

Probably  FieldA  is  long  or  something  field type but RAND returns
random  float  values  and  internal  casting  to  long  leads to zero
results.

Please  provide  some  more  info or you may send database for testing
directly to me.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com