>>>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.
>
only VFP9
INSERT INTO targettable ;
SELECT S.* FROM sourcetable S join (SELECT TOP 300 PK,RAND() FROM sourcetable ORDER BY 2) X ON X.PK=s.PK
>>
>>>>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