Thanks for the correction, I was overlooked that point. However, your correction is also not correct, so I show the updated vesion:

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

>Hi Mohammed,
>
>Adjust Tore's code a little : instead of:

use rami4

try

use rami4 in 0

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