Re: Duble "" inside of the query
Date: Sat, 14 Apr 2001 14:05:28 +0200
Message-ID: <05fgdt0dgjkpiimd4qe5no38djf2s9524p_at_4ax.com>
On Wed, 11 Apr 2001 14:08:24 +0200, "moshe" <mpawlowski_at_wigor.com.pl> wrote:
>I have writen a triger to filtrate data.
>I would like to build "where" condition in oracle Forms's block.
>It is string.
>How to build something like that:
>
>aa := 'field like :ss.si' || ' "%" '
>
>set_block_property('ss',defauld_where, aa)
>
>it is of cause wrong because it is not accepted "" inside of ' '.
>I want to help user when he will forgot add % in the text field :ss.si on
>the form.
>
>
>Regards Moshe
>
>
>
>
aa := 'field like :ss.si||''%'''
(2 single quotes, as the quote needs to be escaped, after the || and
three sinqle quotes, and escaped quote and the string quote, at the
end.
Hth
[Quoted] Sybrand Bakker, Oracle DBA Received on Sat Apr 14 2001 - 14:05:28 CEST