Re: Forms Set_Block_Property

You are right, my bad. Do I get partial credit for getting the ASC right? :-) Mike

"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sp713tkbn4t138_at_corp.supernews.com...
> "Breno de Avellar Gomes" <brenogomes_at_ieee.org> wrote in message
> news:3992D0C8.17B79EA8_at_ieee.org...
> >Set_Block_Property(blk_id, DEFAULT_WHERE, 'PACRESULT.TELEFONE1 LIKE %' ||
> :findpac.item_contacto || '% ASC');
>
> Change to
>
> Set_Block_Property(blk_id,DEFAULT_WHERE,'PACRESULT.TELEFONE1
> LIKE(%'||:findpac.item_contacto||'%)');
>
> (The "ASC" probably was confusing Forms, and you also needed a pair of
> parentheses around your LIKE argument because LIKE is a function just like
 any
> other function (except it's a built-in one and not a user-defined one).)
>
> -Matt
>
>
Received on Fri Aug 11 2000 - 00:00:00 CEST