Home » Developer & Programmer » Forms » Refresh datablock after DML operation(s) (Forms [32 Bit] Version 10.1.2.0.2 (Production))
Refresh datablock after DML operation(s) [message #456767] Wed, 19 May 2010 08:00 Go to next message
dgloeppky
Messages: 28
Registered: May 2010
Junior Member
All,

How do you refresh a datablock after DML operation(s) - INSERT, UPDATE or DELETE?

I know "EXECUTE_QUERY" retrieves records, but what trigger do I use to automatically refresh the datablock after these operations - my form only has 1 datablock.

Cheers!

Report message to a moderator

Re: Refresh datablock after DML operation(s) [message #456768 is a reply to message #456767] Wed, 19 May 2010 08:02 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
There is no easy way to do this so a better question would be why are you trying?
If you modify the data in the data block forms takes care of everything for you.

Report message to a moderator

Re: Refresh datablock after DML operation(s) [message #456809 is a reply to message #456768] Wed, 19 May 2010 09:51 Go to previous messageGo to next message
dgloeppky
Messages: 28
Registered: May 2010
Junior Member
For instance... I have an insert trigger that causes additional records to be inserted, besides the one entered on the form. Without refreshing, these additional records do not show up.

Report message to a moderator

Re: Refresh datablock after DML operation(s) [message #456817 is a reply to message #456809] Wed, 19 May 2010 10:12 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Odd design.
And very awkward to get around.
The only triggers guaranteed to fire during the insert process can not call execute_query (as it's a restricted procedure).
You can try using key-commit but I'd rethink the DB design personally.

Report message to a moderator

Previous Topic: MERGE statement
Next Topic: REP-52007: Parameter form format error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:55:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.