trigger after querying

[Toe]

hi,

i want to trigger something to happen in a multirow block *after* it has finished querying back all the records.

now a post-query fires after *each* row - i want soemthing to fire after *all* rows have been queried.

anybody any thoughts?

thanks,

andy

 

[LKBrwnDBA]

Queried?

Or do you mean "Inserted/Updated/Deleted"?

For the second, just create an AFTER {statement} ...
trigger.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Toe]

No.... i do mean after *quering* the data....

so.... picture a master-detail form whith the detail block itself a multirow block.

I want to perform an action after it has *completely* populated the lower block. ie. once it has queried back all the data.

as i say - post query is the nearest i can find..... but i want it to fire *once* after *all* records have been retreived.

 

[ChrisHunt]

We're talking Oracle forms here guys, not database triggers.

My Forms is a bit rusty (and I don't have a copy to hand to crib from), but as I recollect the triggers you need to home in on are KEY-EXEQRY and KEY-ENTQRY. If the block you want to work on is the detail part of a master/detail relationship, you may have to change the default master/detail code too.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[LKBrwnDBA]

Oh, you must be talking about Oracle Forms...

Tough luck, don't know/don't care -- sorry


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb