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