Home » Developer & Programmer » Forms » Trigger not working (10g developer suite, 10g ,win xp)
Trigger not working [message #328391] Fri, 20 June 2008 00:56 Go to next message
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?

Re: Trigger not working [message #328402 is a reply to message #328391] Fri, 20 June 2008 01:32 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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.
Re: Trigger not working [message #328483 is a reply to message #328402] Fri, 20 June 2008 05:42 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks.

Yes, I would rather stick to the default
Previous Topic: validation code required
Next Topic: How to attach add LOV to list item
Goto Forum:
  


Current Time: Tue Dec 06 00:10:28 CST 2016

Total time taken to generate the page: 0.05533 seconds