I have a Ztable with the following Fields:
of which OBJECT_ID, BEGDA, ENDDA, SEQNR are keyfields.
Consider I have a data with OBJECT_ID = 9400, BEGDA = '20080929', ENDDA = '99991231', SEQN = '001'.
now I am gonna save a new record to the table OBJECT_ID = 9400, BEGDA = '20081029', ENDDA = '99991231', SEQN = '001' through a program.
What I want to do in my program is I want the first data to be delimited to the new datas begda.
i.e., first data must change to OBJECT_ID = 9400, BEGDA = '20080929', ENDDA = '20081029', SEQN = '001'.
how to do it....
I cant use modify because the key fields are different so it will add a new record. Please tell me how to go about it???
Delete the Exisiting record and add the new record.