Fabio,

The code below is not repeatable. The next time you open the table in a new VFP session and insert rows the newly inserted rows would have replicated rand() values generated. This is due to the way that all pseudorandom number generators work.

>A simple example for you:
>

>* fill a table/cursor
>* Now you want a random uniform scan:
>INDEX RAND() TAG T_RAND
>SET ORDER TO T_RAND
>SCAN
>...
>ENDSCAN
>* repeatable! regardless from the UPDATE/REPLACE operations
>* none update overload!
>* none field used!
>REPLICATE ALL .....
>* next scan is the same of previous scan
>SET ORDER TO T_RAND
>SCAN
>...
>ENDSCAN
>* with a simple way for change the order!
>REINDEX
>

>
>With DATE()/DATETIME() is possible do more complex operations.