Re: [FORMS] add_parameter problem - parenthesis
From: qba <rzoof_at_onet.pl>
Date: Tue, 28 Oct 2003 10:57:03 +0100
Message-ID: <bnlehv$fc0$1_at_news.onet.pl>
add_parameter(list_id, param_name, TEXT_PARAMETER, :block_name.param_value); ...
run_product(reports,.......);
Date: Tue, 28 Oct 2003 10:57:03 +0100
Message-ID: <bnlehv$fc0$1_at_news.onet.pl>
> I use CHR() function to concatenate "special" characters;
> such as parenthesis or signle quote marks, into VARCHAR2 variables.
>
I have got the situation: there is an element (param_value) on the canvas which is edited by users, I take the value this elmt and with add_parameter add to the list of parameters, then I run reports.
add_parameter(list_id, param_name, TEXT_PARAMETER, :block_name.param_value); ...
run_product(reports,.......);
Replacing sign " with chr(ascii('"')) in the string :block_name.param_value changes nothing - list still contains bad sign. Received on Tue Oct 28 2003 - 10:57:03 CET