How to get an X number from the user and load a rendom X rows from data?

[#1]

Hi Everyone ,

Lets say I have a table with 3 columns : Id, name , country - with 100 different rows.

I need to get from the user (using an Input box object) some number  , lets say he will put the value: 20

I want that after the user will insert 20 , the table on the GUI will show only 20 random rows from the table .

I don't want him to see the first 20 rows, I want him to see 20 random rows from the 100 rows.

I know how to use the Input box object to take the number from the user, but I don't know how to show the random rows.

can someone help me ?

thanks,

Moni

[swuehl]

That's non trivial with standard QV means.

How important is that you show exactely a certain number of random lines?

You can probably try with a larger selection than needed and limit the number of shown records.

See attached.