Re: Master-Detail form problem

Damir Dezeljin wrote:

> Hi.
>
> I created a Master-Detail form in Oracle developer 6.0. In the master form I
> disabled data integrity checking and I also removed all records as being
> 'required'. Then I program a lot of trigers so that my master forms works.
>
> The problem is that I don't know how to programaticaly update detailed
> forms.
>
> I have a fielt MY_ITEM in the master form (this is the primary ID - number)
> on which the detailed section is colegated. If I just press 'F8' and use up
> / down cursors, I can navigate trough already inserted records. The problem
> arise when I type manualy a number in this MY_ITEM field. I programed a
> POST-TEXT-ITEM triger to check if the given number already exists. If it
> doesn't I output an Alert and clear it, but if it exists I have to fill
> other records in master and the entire detailed form. How can I do this? I
> spend a lot of time trying with ENTER_QUERY / EXECUTE_QUERY and other, but I
> didn't do anything that works.
>
> Any hint?
>
> Regards,
> Dezo

You wrote: "In the master form I disabled data integrity checking and I also removed all records as being
'required'. Then I program a lot f trigers so that my master forms works. The problem is that I don't know how to programaticaly update detailed forms."

Here's the solution:
[Quoted] [Quoted] If you don't know what you are doing don't do it. If you want to make a mess [Quoted] don't ask others to clean it up for you. The sentences above that I quoted are [Quoted] the root of the entire problem. If you didn't keep a back up from before you [Quoted] destroyed the functionality you seemingly want ... start from scratch.

Daniel Morgan Received on Sun Jan 26 2003 - 02:08:39 CET