Re: Duble "" inside of the query

[Quoted] 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 Wed Apr 11 2001 - 23:53:08 CEST