This content has been marked as final. Show 3 replies
If you save the record, and data blocks are same, then1 person found this helpful
User trigger - When Tab Page Changed ,
yOU WILL GET WHAT YOU EXPECT
I need to show it before saving,
I tried this and it is successful somehow, do not know about any further problems,
I took the record count of both blocks
if :B1.reccount <> :B2.reccount
for i in 1..:B1.reccount
assign values from B1 to variables.
assign values from variables to B2
This is working, Now I just want to know, if my block is having numerous fields, say more than 100 (may not be a value for large databases)
how can I replace these variables here.
I mean is it possible to declare something like a cursor record type.
For eg : r1 cursor%rowtype
Could a describe a little more detailed what the purpose of this is?