Home » Developer & Programmer » Forms » Non-Deletable Master Preventing Delete of Detail (Forms 6i)
Non-Deletable Master Preventing Delete of Detail [message #326775] Thu, 12 June 2008 09:56 Go to next message
annagel
Messages: 220
Registered: April 2006
Senior Member
I am working on a new form which has a psuedo master block which is actually just a view which gives a distinct listing of person names from a person actions table. The person id value from this master view is used to populate a detail block which contains the actual actions. The actions themselves are sometimes deletable, other times not deletable and this is controlled by a WHEN-NEW-RECORD-INSTANCE trigger.

I had set the update, delete, insert properties for the master block to no as it is just a summarizing view and those actions don't really make sense for it. It appears doing this is preventing me from deleting detail records when I aught to be able to. I have gotten rid of the trigger on the detail block to make sure that is not causing my problem, and then tried turning the delete on for the master block. Turning on delete did then re-enable delete for the detail block.

This behavior does not really make sense to me, I should be able to set the deletion for the master relationship to non-isolation and get the same type of result, but in that case the button will still be enabled you would just always get an error if you pressed it.

Any ideas on why the behavior is this way? Or ways to get around it?
Re: Non-Deletable Master Preventing Delete of Detail [message #337075 is a reply to message #326775] Tue, 29 July 2008 20:50 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Are you sure you had the focus in the detail block when you tried to do the delete?

David
Previous Topic: Accesing Forms 6i on the web
Next Topic: FLUSH in TEXT_IO similar to one in UTL_FILE
Goto Forum:
  


Current Time: Mon Feb 10 11:28:42 CST 2025