Re: Strange behaviour in SET_REPORT_OBJECT_PROPERTY
From: shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 28 Feb 2008 13:44:33 +0100
Message-ID: <47c6acb3$0$14349$e4fe514c_at_news.xs4all.nl>
>> "nick048" <nicosia.gaet..._at_moonsoft.it> schreef in
>> berichtnews:e75b09e8-75db-42b5-9618-be91723981a9_at_p25g2000hsf.googlegroups.com...
>>
>>
>>
>> > Hi,
>>
>> > I need to run a report from a Form.
>> > The Report Parameter are stored in a table and with this parameters I
>> > want to set the report properties
>>
>> > Now if I use this statement (this is an example):
>>
>> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_DESFORMAT,
>> > MYTABLE.REP_DESFORMAT);
>>
>> > the property is set correctly.
>>
>> > But If I use this code:
>>
>> > DECLARE PR$Format VARCHAR2(100);
>> > .....
>> > BEGIN
>> > SELECT REPORT_DESFORMAT
>> > INTO PR$Format
>> > FROM MYTABLE
>> > WHERE ........
>> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_DESFORMAT, PR$Format);
>> > .......
>> > END;
>>
>> > 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
>
Date: Thu, 28 Feb 2008 13:44:33 +0100
Message-ID: <47c6acb3$0$14349$e4fe514c_at_news.xs4all.nl>
"nick048" <nicosia.gaetano_at_moonsoft.it> schreef in bericht news:c7f3b0b4-1608-4392-82bf-76a8d955f226_at_p73g2000hsd.googlegroups.com...
> On 27 Feb, 18:58, "shakespeare" <what..._at_xs4all.nl> wrote:
>> "nick048" <nicosia.gaet..._at_moonsoft.it> schreef in
>> berichtnews:e75b09e8-75db-42b5-9618-be91723981a9_at_p25g2000hsf.googlegroups.com...
>>
>>
>>
>> > Hi,
>>
>> > I need to run a report from a Form.
>> > The Report Parameter are stored in a table and with this parameters I
>> > want to set the report properties
>>
>> > Now if I use this statement (this is an example):
>>
>> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_DESFORMAT,
>> > MYTABLE.REP_DESFORMAT);
>>
>> > the property is set correctly.
>>
>> > But If I use this code:
>>
>> > DECLARE PR$Format VARCHAR2(100);
>> > .....
>> > BEGIN
>> > SELECT REPORT_DESFORMAT
>> > INTO PR$Format
>> > FROM MYTABLE
>> > WHERE ........
>> > SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_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
>
Any forgotten commits before you check? Try to put a commit after set_report_object_property and see what happens....
Shakespeare Received on Thu Feb 28 2008 - 13:44:33 CET