Master Details Form.. [message #583875] |
Mon, 06 May 2013 07:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hello everybody!
Master Details b/w Dept and Emp tables and in Dept table ,when i enter the Dname and press the 'GO' Button ,then only display Employees Details , so, please help me..
Thanks,
|
|
|
|
|
|
|
Re: Master Details Form.. [message #583888 is a reply to message #583886] |
Mon, 06 May 2013 09:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Not that you can't do that - surely you can, but it makes things much more complex, and you gain absolutely NOTHING.
Is master block data block or control block? Depending on that, you will (or will not) have to enter query mode first.
Is detail block data block or not? Depending on that, you'll populate that block, either by executing a query (you might have to set block's ONETIME_WHERE or DEFAULT_WHERE property, or use PRE-QUERY trigger to restrict data to be fetched) or, for example, using a loop. Note that the latter option implies that values you "retrieved" Forms considers to be NEW records so - if you change any value and want to save it - Forms will perform INSERT instead of UPDATE and you'll get DUP-VAL-ON-INDEX. Then you'll have to develop logic to avoid such faulty behavior.
If it is a control block, you can't execute query anyway so you'll have to populate it somehow (a loop, as I said). As there's no mapping between control block items with table columns, you'll have to write your own code for inserting, updating and deleting values.
Therefore, go ahead, happy programming - I hope that a "GO button form" will work much better than the one Forms creates for you in a matter of several minutes.
|
|
|