Yes, you're right.
>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