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

[Quoted] [Quoted] 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