hi,
thank you for reply,

i get error messagr Alias is not found at line

append from dbf('curdummy')

thanks
>>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
>
>Remember HELP is your friend, your syntax is completely crazy! With VFP8, you must separate this, with VFP9 you could have writtern a oneliner, if I understand correctl what you really want. Is this what you want?

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

>I suggest you spend 30 USD and buy Tamar Granor's book "Taming Visual FoxPro's SQL", you can read about it and download it at http://www.hentzenwerke.com/catalog/tamingvfpsql.htm