Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select records
Message
From
11/09/2004 16:04:06
 
 
To
09/09/2004 09:56:12
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00940543
Message ID:
00941359
Views:
4
hi,
i use just your code to get 2400 records .ok.
but when i change to 7200 records ,after run, he get just 3200 records only, my table have 23662 records,

any idea.
CLOSE ALL
use one &&23662 records
copy structure to TempResult
use TempResult in 0
select *, rand() * 0.000000 as random;
  from one;
  into cursor Temp;
  order by area ,random
go top
for i = 1 TO 3
  select Temp
BROWSE
wait
 locate for area= i 
  copy next 7200 to temp2 while area = i 
    select TempResult
  append from temp2
NEXT 
thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform