Re: Forms Set_Block_Property
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/08/10
Message-ID: <sp713tkbn4t138_at_corp.supernews.com>#1/1
Date: 2000/08/10
Message-ID: <sp713tkbn4t138_at_corp.supernews.com>#1/1
[Quoted] "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 [Quoted] other function (except it's a built-in one and not a user-defined one).)
-Matt Received on Thu Aug 10 2000 - 00:00:00 CEST