Re: Help! Very Urgent! Problem with quoted strings in Developer 6i

From: <mariaema_at_my-deja.com>
Date: Tue, 24 Oct 2000 15:56:31 GMT
Message-ID: <8t4bfa$a01$1_at_nnrp1.deja.com>


Thenk you for your reply but it doesn't resolve my problem. Because using [AFTER PRARAMETER FORM] the single quote remains in top and the end of the string always (in 60 and 6i). We have to pass for example a string wih a space (blank) at the begin. Without quotetion the report don't read the blank. In 60 with quotation (IN THE FORM, BEFORE PASSING THE PARAMETER) the report read ok the blank and the others character of the string. In 6i with quotation the single quote remains in top and end of the string. Thank you for any other help. Hallo Emanuela

In article <39F4D4F1.98D2DCAC_at_metrosystems.co.jp>,   Mitsunori Ishikawa <ishikawa_at_metrosystems.co.jp> wrote:
> How about using Reports Trigger [AFTER PRARAMETER FORM] for
> adding <single quote> in Reports.This will be fired after
> parameter form.
>
> Like this:
> ---
> function AfterPForm return boolean is
> begin
> if :paramstring is not null then
> :paramstring := '''' || :paramstring || '''';
> end if;
> return (TRUE);
> end;
>
> Emanuela Serpilli wrote:
> >
> > Hallo, we have the following problem:
> > In Developer 60 when we have to pass a string to a report from a form we
> > quote the string before.
> > This resolve some problem with special characters like space.
> > In 6i it is not ok. We have an error using the following syntax:
> > <single quote><double quotes><single quote>||STRINGA||<single quote><double
> > quotes><single quote>
> > If we use the syntax:
> > <single quote><single quote><single quote><single quote>||STRINGA||<single
> > quote><single quote><single quote><single quote>
> > we haven't error but the report read 'value of string' instead of value of
> > string.
> > Help us.
> > Ciao
> > Emanuela
>
> --
> Mitsunori Ishikawa
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 17:56:31 CEST

Original text of this message