Re: FORMS: What else can I use besides single quote for specifying literal value?
Date: Tue, 4 May 1999 23:23:19 -0400
Message-ID: <7godkr$1bbg$1_at_news.gate.net>
try 'claim_type = ''HP''' or 'claim_type = '||chr(39)||'HP'||chr(39) - it
might be better to set a variable to this and then use the variable in the
SET_BLOCK_PROPERTY -
declare x_wc varchar2(50);
.
.
x_wc := 'claim_type = '||chr(39)||'HP'||chr(39);
SET_BLOCK_PROPERTY('claim', default_where, x_wc);
hope this helps!
sam
Atsuko Miller <amiller_at_rhs.org> wrote in message
news:tKLX2.46$xr4.4573490_at_IConNet...
> I'm trying to do the following.....
>
> SET_BLOCK_PROPERTY('claim', default_where, 'claim_type = 'HP'');
>
> I need to use quote around the 3rd parameter but I also need to use single
> quote around HP since it is a literal value.....but it does not let me
> compile it.
> Is there a character to replace single quote for literal value????? or do
> you know the work around????
>
> I'd appreciate your response. Thank you :-)
>
>
>
>
Received on Wed May 05 1999 - 05:23:19 CEST