hi,
thank you , i try but the same error,at the last line.
>You must check that the Select really finds any records at all!

>Select * from rami3 ;
>  where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ                                   ");
>  into cursor curdummy nofilter
>If _tally=0
>  Messagebox('No records found!'
>Else
>  Use rami4
>  append from dbf('curdummy')
>Endif

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