Re: Quote within quote (using double apostrophe not good enough)

your might creating a variable containing the apostrophes or you could use CHR(39) for each apostrophe.

Sean McMurray (smcmurr_at_admin.dce.utah.edu) wrote:
: This is a variation of the FAQ, "How do I represent an apostrophe within
: a string?" Mine goes like this,
: In Forms 4.5 I frequently do something like this:

: myvar:='table_key = ''' || :table_block.key_column || '''';
: set_block_property('BLOCK_NAME', DEFAULT_WHERE, myvar);

: Forms chokes on the last ''''. It can't figure out that this is a '
: followed by a '' followed by a ', meant to concatenate a single ' to the
: end of my string.

: It seems like I saw a different technique used one time, but I can't
: remeber it. Any hints?

: Thanks.

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.