Skip to Content
0
Apr 17, 2010 at 03:14 AM

Update or append data from internal table to transparent table .

3648 Views

Dear Guru ,

I need a program which can compare the records between internal table and transparent table .

If the transparent table already have the record (check with PK) , it only update the record from internal table .

If not , append the record from my internal table to the transparent table ...

My solution is a stupid way that is to check the transparent table before we take the decision ... if it has , update , if not , append ...

Does any fast way can do this ?

Thanks .

Best Regards,

Carlos Zhang