OraFAQ Forum: Forms » Commit Changes to Non Database Items

Home » Developer & Programmer » Forms » Commit Changes to Non Database Items

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Commit Changes to Non Database Items [message #115369]

Sun, 10 April 2005 19:13

sikyip
Messages: 1
Registered: April 2005
Location: UK

Junior Member

I have a form with one master block and one detail block. Alos on the form is a non database block added onto the end of the details block.
Everything works fine and I can update the database blocks no problem but I want to be able to update the non database block too.

In the property pallette I have set the non base items to allow update and allow insert but still when I try to save changes in these fields it tells me that there are no changes to save. I am guessing that there is some PL/SQL code that I need to add but I don't know what this is.

I am fairly new to all this and I have to hand in this finished databse in 7 days for my tutor to mark so any help would be very appreciated.

Thanks in advance

Report message to a moderator

Re: Commit Changes to Non Database Items [message #115383 is a reply to message #115369]

Mon, 11 April 2005 01:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

There are many answers to your problem. It all depends on what you want the form to do.

Try putting a post-insert trigger on your database detail block that takes the values from the non-database block and inserts them into the database. [I hope that you have only one line of the non-database block showing.]

Are you retrieving these values as part of the post-query for the detail block? Do you change these values? If so, then try a post-update trigger on the database detail block.

Are you deleting entries in the detail block? If so then you may need either a pre-delete or post-delete trigger to remove the non-database fields.

FOR ME, it is easier to have these singularly occurring non-database fields in the detail block itself and not in another block.

Go to http://www.oracle.com/technology/documentation/dev_arch.html and http://www.oracle.com/technology/documentation/index.html and have a look at the 'Guidelines for Building Applications' to see how master/detail forms can be built. There is also the http://www.orafaq.com/faq/Oracle_Developer/Forms/ area of this site for Forms FAQs.

Report message to a moderator

Previous Topic:	Batch increase of canvas properties(height and width)
Next Topic:	Forms debugger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:16:42 CDT 2024