>Dear Experts,
>
>I have a table, entitled abc, fields as follows
>sno n(3)
>figure n(5)
>
>The data of the table is as
>
>sno figure
>1 14587
>2 84871
>3 36548
>4 95972
>5 64788
>
>Now I want to brows only three records randomly from the dbf,such as 84871,95972,14587. What should be the source codes behind a click button?
>
>Please help
Tarik,
If you reply here me and everybody else have a much higher chance to reply. I rarely check my emails but could hear notification sounds from here :)
"...
rand(-1)
select top 3 rand(), * from myTable order by 1
Cetin
Sir, when I run it, the brows windows shows two fields as
Exp_1 and Figure.
The Exp_1 field has values as
0.17
0.36
0.43
There must be only one field in brows window.
Please suggest another method..."
rand(-1)
select top 3 rand(), * from myTable order by 1 into cursor crsRandom
Browse fields Figure
Would show only field.
Cetin