>Hi - I am attempting to append records from one table to another. I open the source table and copy structure to get my target table. Then I use this code...
>
>
>SELECT tblTarget
>APPEND FROM tblSource FOR myField = .T.
>
>
>This adds records but they are blank. Is it not supposed to copy the data from the source table to the target table where myField is true?
>
>Thanks
Yes and it does. However it might be that fieldnames are not matching though you think they do. Double check (One has longfield names while the other not ?)
BTW if you're creating a new Target why not use :
select * from tblSource where myField into table tblTarget
Cetin