Re: Execute_query in Form5.0
Date: Wed, 28 Jul 1999 13:51:53 +1000
Message-ID: <7nlv8k$abl71_at_atbhp.corpmel.bhp.com.au>
Hi,
You want to enter parameters in a control block and then feed these values
into the base table block query?
Create a Pre-Query trigger on the base table block, which assigns entered
control block values to your base table items.
To execute the query after entry of the parameters, navigate to the base
table block and execute_query (you skip enter_query altogether). The
Pre-Query trigger will then fire and load your values to qualify the query.
Igor Avramovic wrote in message <379D8747.F2D43EE3_at_sb.tel.hr>...
>I need help !
>I have my base form name "CUSTOMER" with this record:
>OrderNo Customer Price
>--------- --------- ------
>1 Mark 10,00
>2 John 12,00
>3 David 9,00
>4 Peter 10,00
>5 Mary 11,00
>... ...
>I create my own parameter form for input some parameters like
>
>Name of partner:
>or
>OrderNo:
>
>I can't execute_query for this parameters in base form.
>How can I done this ?!?
>
Received on Wed Jul 28 1999 - 05:51:53 CEST