Monday, March 4, 2013

A problem related to query when using master-detail relationship-

The problem is that when records are queried it got vanished from the screen as soon as the mouse is clicked on the second, third or new record except the first one.


Reason-
Oracle Forms assigns names to relationships automatically. The name is created using the names of both the master and the detail blocks. For Example if the name of the master block is Criminal_Court_Cases and the name of the detail block is Criminal_Court_Parties then the name of the relationship will be Criminal_Court_Criminal_Court. If another detail block is added, for example Criminal_Court_Accusations the name of the new relationship will also be Criminal_Court_Criminal_Court. To avoid this conflict rename the names of the blocks.

No comments:

Post a Comment