>See Re: Random numbers - the most efficient way Thread #939849 Message #939864
>
>So, you just insert this part using INSERT-SQL.
>

1000000 * is useless and slow the process only.

>>>>VFP9: yes, VFP8: no.
>>>>
>>>Yes and the random problem can be solved in VFP9 in one insert command.
>>
>>I'm curious about how to solve also the random problem in one insert command(so how to insert randomly 300 records of the other table). Do you have any example code? I need it for something I want to do.
>>
>>>
>>>>>In VFP9 (8?) you can do
>>>>>
>>>>>insert into myTable from (select myfields from myOthertables where myFilterCondition).
>>>>>
>>>>>Check the INSERT-SQL command in Help.
>>>>>
>>>>>>hi all,
>>>>>>
>>>>>>any idea , help
>>>>>>i try to append new records to mytable, as under
>>>>>>
>>>>>>

>>>>>>Select * from rami3 ;
>>>>>> where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ                                   ") ;
>>>>>> append blank;
>>>>>>   into table rami4 nofilter
>>>>>>

>>>>>>thanks