Commit Problem

From: Scott <swesley_at_student.ecu.edu.au>
Date: Sun, 08 Oct 2000 16:31:36 +0800
Message-ID: <39E030E8.E0C7481C@student.ecu.edu.au>

G'day

I have finally found the cause of my commit problem. If I use the default smartbar on the form, and execute and scroll through the master records that way, insertions and deletions can be made in the detail block no prob.

But I'm populating the master block with an LOV, which executes the query on the tabular detail block.
Oracle seems to think that this master record has now been changed, and when the commit command appears, it tries to commit the master block as well - and unique key contraint gets violated.

Can anyone see a solution - ie - be able to search for the master record, without having the commit problem?

ps - does anyone know the built-in for the e-mail command? Received on Sun Oct 08 2000 - 03:31:36 CDT