Home » Developer & Programmer » Forms » FRM-30457 (10G)
FRM-30457 [message #318530] Wed, 07 May 2008 02:07 Go to next message
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 #318541 is a reply to message #318530] Wed, 07 May 2008 02:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
To get a message to appear you either have to issue the message command twice, use a 'synchronize' or use a 'pause'. I suggest the last.

Do you have a mirror item defined for 'C_BLK.REF_CODE'?

David
Re: FRM-30457 [message #318584 is a reply to message #318541] Wed, 07 May 2008 04:03 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Web.show_document Visual C++ error
Next Topic: How to find a duplicate record before commit?
Goto Forum:
  


Current Time: Fri Dec 02 20:42:07 CST 2016

Total time taken to generate the page: 0.12923 seconds