OraFAQ Forum: Forms » Trigger not working

Home » Developer & Programmer » Forms » Trigger not working (10g developer suite, 10g ,win xp)

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

Trigger not working [message #328391]

Fri, 20 June 2008 00:56

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Hi,

I know this is easy but I am not getting it.

Attached is the screen shot, I want that when I select an item from the LOV (cupboardno) the detail table below (which is on Books table) should be populated with the related books. I am using PRE_TEXT_ITEM trigger on the item (cupboardno) but it is not working

begin
 execute_query;
end;

Should I be doing something else? What trigger should be used for this case?

Attachment: lov_selection.gif
(Size: 61.10KB, Downloaded 469 times)

Report message to a moderator

Re: Trigger not working [message #328402 is a reply to message #328391]

Fri, 20 June 2008 01:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The default way to do that is:
- enter query mode
- select value from the list of values
- execute query.

What's wrong with that?

Any other way requires setting the DEFAULT_WHERE clause for that block (using the SET_BLOCK_PROPERTY built-in) which is, of course, unnecessary coding.

I'd rather keep it simple.

Report message to a moderator

Re: Trigger not working [message #328483 is a reply to message #328402]

Fri, 20 June 2008 05:42

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Thanks.

Yes, I would rather stick to the default

Report message to a moderator

Previous Topic:	validation code required
Next Topic:	How to attach add LOV to list item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 08:48:03 CST 2025