Home » Developer & Programmer » Forms » Executing query when display box value changes
Executing query when display box value changes [message #472858] Tue, 24 August 2010 06:52 Go to next message
ahazin
Messages: 39
Registered: August 2010
Member
Hello everyone, i have a small problem. In my form i have 2 datablocks, the first contains only a display item which is populated from a lov when a user presses a button. The second datablock shows a list of items which should be queried dependant on the value of the above LOV. What i thought i could do is on a post-change trigger for the display item is:

go_block('block_name');
do_key('execute_query');

However, i am told i cannot do these in a post-change trigger, would anyone have any suggestions on how to acheive what I am looking. Would i perhaps have to create my own trigger somehow or is their a simplier way.


Thanks

[Updated on: Tue, 24 August 2010 06:55]

Report message to a moderator

Re: Executing query when display box value changes [message #472862 is a reply to message #472858] Tue, 24 August 2010 07:05 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could put it in the code of the button that calls the LOV.
Re: Executing query when display box value changes [message #472866 is a reply to message #472862] Tue, 24 August 2010 08:18 Go to previous message
ahazin
Messages: 39
Registered: August 2010
Member
Thanks, was thinking more along the lines of triggers that an obvious answer didnt even appear to me.

Thank you.
Previous Topic: (+) Operator
Next Topic: Narrowing query using checkbox
Goto Forum:
  


Current Time: Thu Sep 19 17:23:17 CDT 2024