"nick048" <nicosia.gaetano@[EMAIL PROTECTED]
> schreef in bericht
news:c7f3b0b4-1608-4392-82bf-76a8d955f226@[EMAIL PROTECTED]
> 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
>
Any forgotten commits before you check? Try to put a commit after
set_re****t_object_property and see what happens....
Shakespeare
|
