On 27 Feb, 18:58, "shakespeare" <what...@[EMAIL PROTECTED]
> wrote:
> "nick048" <nicosia.gaet...@[EMAIL PROTECTED]
> schreef in
berichtnews:e75b09e8-75db-42b5-9618-be91723981a9@[EMAIL PROTECTED]
>
>
>
> > Hi,
>
> > I need to run a re****t from a Form.
> > The Re****t Parameter are stored in a table and with this parameters I
> > want to set the re****t properties
>
> > Now if I use this statement (this is an example):
>
> > SET_RE****T_OBJECT_PROPERTY(rep_id, RE****T_DESFORMAT,
> > MYTABLE.REP_DESFORMAT);
>
> > the property is set correctly.
>
> > But If I use this code:
>
> > DECLARE PR$Format VARCHAR2(100);
> > .....
> > BEGIN
> > SELECT RE****T_DESFORMAT
> > INTO PR$Format
> > FROM MYTABLE
> > WHERE ........
> > SET_RE****T_OBJECT_PROPERTY(rep_id, RE****T_DESFORMAT, PR$Format);
> > .......
> > END;
>
Yes, I have tested the values returned from statement Select.
Bye
Gaetano
> > the parameter is not set.
>
> > And so for the others parameters. I do not understand this curious
> > behaviour.
>
> > Can anyone help me ?
>
> > Greetings...
> > Gaetano
>
> Are you sure the select statement returns one and only one value? No
> exceptions?
>
> Shakespeare


|