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