Re: Forms 4.5 to Reports 2.5 parameters

From: Joe Strano <jstrano_at_dulcian.com>
Date: 1997/08/24
Message-ID: <01bcb093$c5b0a320$136465cf_at_Paul.dulcian.com>#1/1

When passing quotes in a parameter, you need to double them up. For some reason, Oracle strips off one set of quotes.

WHERE PROPERTY_NAME = ''LITERAL'' That is two single quotes.

Joe Strano
Dulcian, Inc.

---

Tracey Berukoff <"<tlberukoff>"_at_boco.co.gov> wrote in article <33FE19FA.4C23_at_boco.co.gov>...
> I am passing a where clause from forms to reports. The value of the
> variable containing the where clause is WHERE PROPERTY_NAME = 'LITERAL'.
>
> ie: where_clause := 'WHERE PROPERTY_NAME =' || '''' || 'LITERAL' ||
> '''';
>
> It seems that the single quotes around the literal are causing problems.
> Basically, reports never executes. Does reports interpret those single
> quotes as some sort of termination character??
>
> If I eliminate the single quotes, I get a message from reports saying
> unable to parse the query. Makes sense.
>
> If I don't pass the where_clause as a parameter, the default parameter
> form comes up, I can enter WHERE PROPERTY_NAME = 'LITERAL' and it works
> just fine. Any ideas out there? Thanks in advance.
>
> Tracey
>
Received on Sun Aug 24 1997 - 00:00:00 CEST