OraFAQ Forum: Forms » Update Data in a view

Home » Developer & Programmer » Forms » Update Data in a view (database 8i, Forms 6i and WindowXP)

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

Update Data in a view [message #421179]

Sat, 05 September 2009 01:06

sadiq106
Messages: 22
Registered: February 2009

Junior Member

I want to update data in a view through forms. Can you please guide me .

Thanks in advance.

sadiq

Report message to a moderator

Re: Update Data in a view [message #421189 is a reply to message #421179]

Sat, 05 September 2009 05:38

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Write your own code in ON-UPDATE trigger of forms.
Otherwise INSTEAD OF trigger is available at database level.

By
Vamsi

Report message to a moderator

Re: Update Data in a view [message #421248 is a reply to message #421189]

Sun, 06 September 2009 21:45

sadiq106
Messages: 22
Registered: February 2009

Junior Member

Vamsi, Thanks for you reply.

I have written a instead of trigger and i can update it in SQL but I'm unable to do it through form. The form status showing 'Working...'

I need your suggestion or can u please provide a sample form with detail or a link which gives me detail about updating a view.

I will be very thankful to u.

sadiq

Report message to a moderator

Re: Update Data in a view [message #421405 is a reply to message #421248]

Tue, 08 September 2009 02:35

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Then try ON-UPDATE trigger in Forms.
Have a look at the thread.

By
Vamsi

Report message to a moderator

Previous Topic:	Problem in opening template.fmb
Next Topic:	Variables in single quotation signs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:37:23 CDT 2024