Duble "" inside of the query

From: moshe <mpawlowski_at_wigor.com.pl>
Date: Wed, 11 Apr 2001 14:08:24 +0200
Message-ID: <9b1g7q$c1q$1_at_news.tpi.pl>


[Quoted] [Quoted] 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 - 14:08:24 CEST

Original text of this message