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