| FRM-30457 [message #318530] |
Wed, 07 May 2008 02:07  |
lakshmisaran
Messages: 26
Registered: May 2008
|
Junior Member |
|
|
Hi,
FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item C_BLK.REF_CODE.
I'm calling the report from Forms. When I make the max length zero, while adding/assigning the parameter value, the system doesnot goes to the next line. hangs up with the code
Ex:
add_parameter(para_id,'p_rc',text_parameter,nvl(:c_blk.ref_code,''));
message(1);
add_parameter(para_id,'p_amt',text_parameter,nvl(TO_CHAR(:c_blk.amount,'999,999,999,999.00'),''));
its not going to 2nd line. simply message 1 is not displayed.
but when i give the max length as like mirror item, its work fine but i get this warning message while executing to fmx, however fmx is built.
How to suppress this warning message????
Thx n advance
Lakshmi
|
|
|
|
|
|
| Re: FRM-30457 [message #318584 is a reply to message #318541] |
Wed, 07 May 2008 04:03  |
lakshmisaran
Messages: 26
Registered: May 2008
|
Junior Member |
|
|
Hi DJ,
For the item C_BLK.REF_CODE, the Synchronize with item is set as I_ref_code, whose data type is char, with max length 30
hope i should get the message in the status bar.
if i add message before the parameter like the ex. message will popup in normal circumstances.
Ex:
message(0);
add_parameter(para_id,'p_rc',text_parameter,nvl(:c_blk.ref_code,''));
message(1);
Rgds,
Lakshmi
|
|
|
|
| Re: FRM-30457 [message #318761 is a reply to message #318584] |
Wed, 07 May 2008 20:58 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Wrong!! Put a 'pause' or 'synchronize' after each 'message' and run the code again. You will see a DIFFERENT message in the status bar when an error is encountered than when you didn't have the extra commands.
You describe one item as 'C_BLK.REF_CODE' but the other item as 'I_ref_code'. Did you or did you not use a 'block' qualifier in your property definition that uses 'I_ref_code'? Are they the same length and data type?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
