Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Randomly records
Message
From
24/07/2004 04:44:25
 
 
To
20/07/2004 03:46:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00926023
Message ID:
00927564
Views:
19
Hi,

>>
select sys(2015) as SortOrder,* from ac ;
order by 1 descending
>>

Repeated calls to SYS(2015) won't give a random sequence.

Can you use something on the lines of:
INDEX ON RAND() TAG idx_rand
SET ORDER TO idx_rand
LOCATE
COPY NEXT 4500 TO ....
HTH,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform