I may be wrong, and if you say so, I probably am. It's funny how fast you forget how old some features are. I guess I mixed this up with the new SQL Update options.

>>VFP9: yes, VFP8: no.
>>
>
>Tore, are you sure ?
>
>>>In VFP9 (8?) you can do
>>>
>
>this sintax is wrong
>
>>>insert into myTable from (select myfields from myOthertables where myFilterCondition).
>
>

>insert into myTable (myfiels) 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