If your objective is to pick one record out of N records, since each record has a "record number", you could do the following:
RAND( -1 )
GO INT( RECCOUNT() * RAND() )
? "The winner is: " + ...table field...
I did something similar in a "video poker" game I wrote, where the record count was 52.
It seemed random enough because, in the end, I always lost ...
>I want to do an automatic computer drawing for certain people, I puted all the records in a cursor including how many times they have a chance to win, each chance is a seperate reocrd, what is the best method that it should pick random records ?, I worked with RAND(), I added a numeric field named no then I did
>
>RAND(-1)
>REPLACE ALL no WITH RAND()*1000
>
>then I did select top 1 from cursor order by no
>
>Can anyone advise me if with that way is it really random so I can be sure that the drawing is fare ?
>
>Any help will be greatly apriciated.
>
>Simon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only