 | |
Strange behaviour in SET_REPORT_OBJECT_PROPERTY
comp.databases.oracle.tools comp.databases.oracle.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Strange behaviour in SET_REPORT_OBJECT_PROPERTY -
02-26-2008
, 07:09 AM
#2
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#3
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#4
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#5
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#6
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#7
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#8
| |||
| |||
|
|
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 |
exceptions?
Shakespeare
#9
| |||
| |||
|
|
"nick048" <nicosia.gaet... (AT) moonsoft (DOT) it> schreef in berichtnews:e75b09e8-75db-42b5-9618-be91723981a9 (AT) p25g2000hsf (DOT) 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
Quote:
|
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 |
#10
| |||
| |||
|
|
"nick048" <nicosia.gaet... (AT) moonsoft (DOT) it> schreef in berichtnews:e75b09e8-75db-42b5-9618-be91723981a9 (AT) p25g2000hsf (DOT) 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
Quote:
|
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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.