Re: Bizzaire Reports Parameter Problem

Your question is a little unclear, but what I thought you were saying is that you could not use quotes in parameters....

I was able to use them in Reports 3. Here are my findings:

From Forms, the quotes must be placed explicitly with the use of quote-quote is in:

    wrkParm := 'The quick brown fox ''jumped'' over the lazy dogs';     Add_Parameter(ParmID, 'Parm_Parm',TEXT_PARAMETER, wrkparm); The resulting report (select :parm_Parm mydata from dual) show the following output:

   The quick brown fox 'jumped' over the lazy dogs

If you are launching from COMMAND LINE, then a different approach is needed.

    xxx> r30run32 userid=xxx/xxx_at_xxx report=xxx

         parm_parm=the quick brown fox
Will not work.
Neither will

    xxx> r30run32 userid=xxx/xxx_at_xxx report=xxx

         parm_parm='the quick brown fox'

Because the DOS interpreter uses double quote for strings, you must use them:

    xxx> r30run32 userid=xxx/xxx_at_xxx report=xxx

         parm_parm="the quick brown fox" Then, for quotes in the string, single quotes may be used normally:

    xxx> r30run32 userid=xxx/xxx_at_xxx report=xxx

         parm_parm="the quick 'brown' fox" produces report output of:

    the quick 'brown' fox

HTH
Robert Proffitt
RTProffitt AT beckman DOT com

D:\ORANT\BIN>r30run32 userid=rtproffitt/beckman_at_sqis report=d: \proffitt\vamp\dev
\junk2.rep parm_parm="the quick 'brown' fox"

In article <095f7cb4.53650cd3_at_usw-ex0103-018.remarq.com>,   mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote:
> I can't use quotes, it doesn't like them either!
> I'm not sure if that is the answer but it is a fair point about
> the operating system though.
>
> M
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 18 2000 - 18:38:26 CET