[Openroad-users] Random Function

[Sean Thrower]

Or maybe use the execute immediate select just to get the first random
number, then derive the next limit-values from each random value in turn
- random()-generated values from random limits should be random ... -
using Mod if necessary to bring the final working value into range.

 

Sean.

 

Sean Thrower

Ingres Premium Services

 

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Bodo
Bergmann
Sent: Friday, December 14, 2007 9:01 AM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Random Function

 

Or you coud just use the Ingres random() functions (see SQL Ref Manual)

using a select (Execute Immediate if not supported directly).

 

Bodo Bergmann

Senior Software Engineer

OpenROAD Worldwide Engineering

Ingres Corp.

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Doug White
Sent: Friday, December 14, 2007 9:02 AM
To: openroad
Subject: [Openroad-users] Random Function

Hey All,

I finally got sick of the crappy support for random number generation in
OpenROAD, So hopefully this can be of use to someone.

Enjoy, and please email me if you spot any problems / improvements that
can be fixed

P.S It's an exported application, that will probably only work in XP

Doug White

 

________________________________

Listen now! New music from the Rogue Traders.
<http://ninemsn.com.au/share/redir/adTrack.asp?mode=click&clientID=832&r
eferral=hotmailtaglineOct07&URL=http://music.ninemsn.com.au/roguetraders
>  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20071214/a6bf376f/attachment-0001.html