Re: developer 2000 master detail relationship

You must write code in POST-INSERT (Forms) trigger to synchronize server-derived table column(s) and Forms block item(s). For example, if master block is DEPT and detail block is EMP, you must write following (or simile) code in POST-INSERT trigger for DEPT block:

/* Refresh items corresponding to server-derived columns */ BEGIN
  SELECT deptno -- if deptno is server-derived column     INTO :dept.deptno
    FROM dept
   WHERE deptno = :dept.ROWID;
END; This work OK because commit sequence of master-detail events is:

1. INSERT into master table (plus database trigger(s))
2. POST-INSERT trigger for master block
3. Copy value from item for detail block
4. INSERT into detail table

Regards

Zlatko Sirotic

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 20 2000 - 00:00:00 CEST