>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
rand(-1)
select top 3 rand(), * from myTable order by 1
Cetin