OraFAQ Forum: Forms » update/insert on non database block

Home » Developer & Programmer » Forms » update/insert on non database block

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

update/insert on non database block [message #215396]

Mon, 22 January 2007 02:05

ataufique
Messages: 79
Registered: November 2006

Member

I have a non database block in my form(5 rec)
I am populating the form using select statement.
once populated...the user can change the record or
insert new record in same form.
The updated/inserted records should go to the concern
table (2 tables)
how this DML can be acheived for non database blocks.

Report message to a moderator

Re: update/insert on non database block [message #215399 is a reply to message #215396]

Mon, 22 January 2007 02:28

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

Senior Member

Try to check the triggers ON-INSERT and ON-UPDATE

By
Vamsi

Report message to a moderator

Re: update/insert on non database block [message #215432 is a reply to message #215399]

Mon, 22 January 2007 04:56

ataufique
Messages: 79
Registered: November 2006

Member

on-insert and on-update doesn't fire for non database blocks

Report message to a moderator

Re: update/insert on non database block [message #215435 is a reply to message #215396]

Mon, 22 January 2007 05:12

shakti_goyal
Messages: 60
Registered: November 2006
Location: India

Member

Hello friend,

Place a command button on form and then collect One Record value(on trigger when-button-pressed)
from form using :block.item in any variable and then issue a insert command.........

hope it will work for u...........

Regards
Shakti

Report message to a moderator

Re: update/insert on non database block [message #215436 is a reply to message #215432]

Mon, 22 January 2007 05:13

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

Senior Member

Another thread on this

By
Vamsi

Report message to a moderator

Previous Topic:	Conversion of Developer 2000 forms to Visual .net
Next Topic:	FRM-41214- Unable to Run Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 03:42:40 CDT 2025