Re: Max Length and Query Length in Forms 6.0

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/06/07
Message-ID: <sju6i8mu2t548_at_corp.supernews.com>#1/1


"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sju585ja2t5128_at_corp.supernews.com...
> 2. On PRE-QUERY of the block, concatenate your criteria above with the
> default_where that's in your control item:
>
> IF <your extra criteria> is not null THEN
> IF :controlblock.controlitem is null then
> set_block_property('blockname',default_where, <your extra criteria>);
> ELSE
> set_block_property('blockname',default_where,:controlblock.controlitem ||
 '
> AND ' || <your extra criteria>);
> END IF;
> END IF;
Whoops. I take that back. Should be:

IF :controlblock.controlitem IS NULL THEN   set_block_property('blockname',default_where, <your extra criteria>); ELSE
  IF <your extra criteria> IS NOT NULL THEN     set_block_property('blockname',default_where,:controlblock.controlitem || ' AND ' || <your extra criteria>);
  ELSE
    set_block_property('blockname',default_where,:controlblock.controlitem);   END IF;
END IF; (Removed the outermost IF clause - it would have prevented the where-clause from being reset properly if you didn't enter extra query criteria. Added additional IF-clause in the second part to handle the 'AND' depending on if your extra criteria is null or not.)

-Matt Received on Wed Jun 07 2000 - 00:00:00 CEST

Original text of this message