>hi,
>thank you for reply,
>
>i get error messagr Alias is not found at line
>
>

>append from dbf('curdummy')
>

>
>thanks

The UT community (if I may be so bold as to speak for them on this) is happy to provide help and advice when you run across new problems. But you need to remember that people here are giving you SUGGESTIONS and not necessarily proven code. Occasionally there are typos. Occasionally (as is the case here) a small step will be missed. It is up to YOU to LEARN how to make those suggestions work. The first step, as has been said many many many many.... times is LEARN HOW TO USE THE DEBUGGER.

There is a command called SET which will show (among other things) what is open in each workarea. Had you invoked this command (any by now you should have known about it), and then stepped through the code in the debugger, you would have noticed that

Select * from rami3 ;
  where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ");
  into cursor curdummy nofilter

created the cursor curDummy and make it the active workarea

Use rami4

Closed the table open in the current workarea (curDummy) and then opened rami4

append from dbf('curdummy')

CAN'T work because the cursor had been closed.

In giving you a quick answer, Tore simply forgot to put a SELECT 0 before USE rami4. That has happened to all of us. It's an error you have made several times in the past.

You'll continue to get help and advice and answers to your questions. But when a proposed solution gives an error message, YOU HAVE TO LEARN HOW TO FIND AND FIX THESE SIMPLE PROBLEMS ON YOUR OWN!!!!


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