Re: OPO : Default Condition

[Quoted] [Quoted] Webmestre Orisoft <Webmestre_at_orisoft.com> wrote in article <32C98160.2021_at_orisoft.com>...
> Hi
>
> I'm trying to do the following with Oracle Power Objects 2.0; I would to
> set the default condition property of a form or a report using a global
> variable. For example, I declare a global variable and initialize it in
> the initialization() method of my application, let's say the Maximum
> amount payable by a member, called MaxAmt.
>
> I would like the default condition to be: AMTSUM > MaxAmt where AMTSUM
> is a field in a table. I doesn't work. If I put AMTSUM > 400, then it
> works perfectly. I know the value of MaxAmt is carried into the current
> form because I can display it with MSGBOX.

Try this: In the Qyery() method of your form or report put:  self.defaultcondition="amtsum>" & str(maxamt)  inherited.query()

this ensures that your condition is always applied to the query, with the current value of 'amtsum'..

regards
 Kári Poulsen   Received on Thu Jan 02 1997 - 00:00:00 CET