ı have two different database block, both have a column named SCL_DATE.
In pre-insert trigger of BLOCK1 I write sth like this : BLOCK1.SCL_DATE = SYSDATE;
And in pre-insert trigger of BLOCK2 I write sth like this : BLOCK2.SCL_DATE = SYSDATE;
But ı wonder if ı can write a procedure such as :SYSTEM.CURRENT_BLOCK.SCL_DATE = SYSDATE and can I use this procedure in pre-insert trigger of two blocks. I tried but this syntax didn't work.
..... variable_name:=:SYSTEM.CURRENT_BLOCK; variable_name||.SCL_DATE=sysdate;
:blockname1.urdate := sysdate ;there is a property called copy value in the date item property of ur dsteitem in second block here u can write the date item name of the block1 where it has sysdate .
post or per text item or when validate item triggersin order to assign the sysdate to date on block1