How to copy a record in a temp-table to a table?

[abhishek.shah]

I have a record in temp-table tt_pj1_mstr.
I want to copy/append that record into the existing table pj1_mstr.
Thanks in Advance.

 

[RealHeavyDude]

Have a look into the BUFFER-COPY statement.

Heavy Regards, RealHeavyDude.

 

[abhishek.shah]

BUFFER_COPY as you suggested helps copy records in a table to a temp-table. But not vice-versa. I have tried following:
/*================================*/
find first tt_pj1_mstr.
if available tt_pj1_mstr then do:
buffer-copy tt_pj1_mstr to pj1_mstr.
end.
/*================================*/

But this doesn't work. The record does not get appended to the table.

 

[Cringer]

You need to create the target record first. Otherwise it will just try to copy it to the current record int he buffer.

 

[abhishek.shah]

Can u please elaborate? or give a small example?

 

[Cringer]

find first tt_pj1_mstr.
if available tt_pj1_mstr then do:
  create pj1_mstr.
  buffer-copy tt_pj1_mstr to pj1_mstr.
end.

 

[abhishek.shah]

Thanks a ton. I know it sounds dumb but I did not use Create statement.
Thanks to both of you.