>Hi,
>
>How do you append from one cursor to another with FOR?
>
>I tried:
>
>select C_CURSOR1
>append from DBF("C_CURSOR2") fields FLD1, FLD2 FOR C_CURSOR2.FLD1 = "123"
>
>
>But it appends ALL records from the cursor C_CURSOR2 instead of just the ones matching the FOR
>
>What am I missing?
Why not simply
insert into c_cursor1 (fld1, fld2);
select fdl1, fdl2 from c_cursor2 where fld1='123'
If it's not broken, fix it until it is.
My Blog