Home » Developer & Programmer » Forms » Update Data in a view (database 8i, Forms 6i and WindowXP)
Update Data in a view [message #421179] Sat, 05 September 2009 01:06 Go to next message
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
Re: Update Data in a view [message #421189 is a reply to message #421179] Sat, 05 September 2009 05:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Write your own code in ON-UPDATE trigger of forms.
Otherwise INSTEAD OF trigger is available at database level.

By
Vamsi
Re: Update Data in a view [message #421248 is a reply to message #421189] Sun, 06 September 2009 21:45 Go to previous messageGo to next message
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
Re: Update Data in a view [message #421405 is a reply to message #421248] Tue, 08 September 2009 02:35 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Then try ON-UPDATE trigger in Forms.
Have a look at the thread.

By
Vamsi
Previous Topic: Problem in opening template.fmb
Next Topic: Variables in single quotation signs
Goto Forum:
  


Current Time: Mon Dec 05 18:57:24 CST 2016

Total time taken to generate the page: 0.11811 seconds