Re: Forms 3.0 pre-query question ???

In article <1994Jan5.144710.1_at_cmu.unige.ch>, stouder_at_cmu.unige.ch wrote:

> Hi,
>
> We are developing with SQL*Forms 3.0 for DOS and Oracle RDBMS 7.0
> I want to execute the trigger execute-query and I want to have a
> condition in the pre-query trigger that goes like this:
> :bk1.stat = 'R' or :bk1.stat = 'L' and :bk1.total>1200
>
> Is that possible ? If so, what's the syntax???
>
> Alain STOUDER, University of Geneva

Yes, make your character field, e.g. stat, big enough to hold a piece of a query, let's say 240 characters - just on the form, not in the database. Then do something like the following in the pre-query:

:stat := '#=stat and (stat='R' or stat='L') and total>1200';

See the Advanced SQL*Forms Techniques manual in the section about queries.

Jennifer R. Amon            PHONE: (216) 775-6987
Houck Computing Center        FAX: (216) 775-8573
Oberlin College
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu
_____________________________________________________________________