>Hi Claude,
>
>>I have two tables with the same names and structure in two different folders. They include meno fields. I want to copy (append) records from table in folder a to similar table in folder b (excluding deleted records). What is the best way of doing this? Pseduo code
>>
>> copy from c:\a\b\table to c:\x\y\table for not deleted
>
>APPEND FROM should do the trick!
If you need to be more selective you could
SELECT ... FROM c:\a\b\table WHERE ... INTO CURSOR whatever
USE AGAIN c:\x\y\table ALIAS table2
APPEND FROM DBF('whatever')