Home » Developer & Programmer » Forms » update/insert on non database block
update/insert on non database block [message #215396] Mon, 22 January 2007 02:05 Go to next message
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.
Re: update/insert on non database block [message #215399 is a reply to message #215396] Mon, 22 January 2007 02:28 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try to check the triggers ON-INSERT and ON-UPDATE

By
Vamsi
Re: update/insert on non database block [message #215432 is a reply to message #215399] Mon, 22 January 2007 04:56 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
on-insert and on-update doesn't fire for non database blocks
Re: update/insert on non database block [message #215435 is a reply to message #215396] Mon, 22 January 2007 05:12 Go to previous messageGo to next message
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
Re: update/insert on non database block [message #215436 is a reply to message #215432] Mon, 22 January 2007 05:13 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Another thread on this

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


Current Time: Fri Dec 02 16:46:52 CST 2016

Total time taken to generate the page: 0.16280 seconds