>>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