Re: Duble "" inside of the query
Date: Thu, 12 Apr 2001 10:57:47 +0200
Message-ID: <9b3qgh$rr5$1_at_news.tpi.pl>
Thank you very much Hans-Dieter
Uzytkownik "Dr. Hans-Dieter Wehe" <dieter_at_wehe.de> napisal w wiadomosci
news:3AD4D244.FB93E8F6_at_wehe.de...
> Try this
>
> aa := 'field like ''' || :ss.si || '%''' ;
> set_block_property('ss',defauld_where, aa) ;
>
> Do not use double quotes
> The two single quotes within a string constant (as after the "like"
> and after the "%"-Character) result in a single quote of the resulting
> string.
> Assuming that :ss.si contains "Hello World", the resulting string in
> aa would be: field like 'Hello World%'
>
> Regards Hans-Dieter
>
> moshe schrieb:
> >
> > 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
Received on Thu Apr 12 2001 - 10:57:47 CEST