OraFAQ Forum: Forms » FRM-30047

Home » Developer & Programmer » Forms » FRM-30047

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-30047 [message #336714]

Mon, 28 July 2008 14:37

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Hi,

I have Form and I change the name of one of text item on that. I try to change the old name to new name in everywhere that needs. But I still get this error:

FRM-30047: Cannot resolve item reference CTRL_DB.ZIP_X2.
LOV CODE_LOV

Please advise.

Thanks in advance

Report message to a moderator

Re: FRM-30047 [message #336724 is a reply to message #336714]

Mon, 28 July 2008 15:39

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So did you check what items are referenced in the "code_lov" list of values? One of them must still be wrong.

How to do that? Open LoV's Property Palette, go to "Column Mapping Properties" and see what's in there.

Report message to a moderator

Re: FRM-30047 [message #337034 is a reply to message #336724]

Tue, 29 July 2008 13:28

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Thanks for your reply. I checked that but still I have same error.

Report message to a moderator

Re: FRM-30047 [message #337050 is a reply to message #337034]

Tue, 29 July 2008 14:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, if Oracle says that it "Cannot resolve item reference CTRL_DB.ZIP_X2", I'd say that it is not lying. So - did you check VERY carefully?

By the way, try to recompile the form (Ctrl + Shift + K); it will probably not help, but won't cost much to do it.

Also, you may attach the FMB file to your next message so that we could take a look.

Report message to a moderator

Re: FRM-30047 [message #338662 is a reply to message #337050]

Tue, 05 August 2008 10:29

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Hi,

I found out that I am getting this error because of one of the field of Record Group Query. The field is:

to_char(NVL(min_t,0), '$9,999,999.99') c

However I could not find anything wrong with this field. Please advice.

Thanks

Report message to a moderator

Re: FRM-30047 [message #338690 is a reply to message #338662]

Tue, 05 August 2008 11:49

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How did you find that out? As it looks, it has nothing to do with an error you have reported in the first message.

Report message to a moderator

Re: FRM-30047 [message #338691 is a reply to message #336714]

Tue, 05 August 2008 11:53

mhakimjavadi
Messages: 37
Registered: July 2008

Member

I just take out TO_Char function from that column and then recompile the form again and error not comes up any more. Please advice.

Report message to a moderator

Re: FRM-30047 [message #338692 is a reply to message #338691]

Tue, 05 August 2008 12:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Was it the "invalid number format model" error? Such as in this example (note use of decimal point and thousands separator):

SQL> select to_char(123, '$9,999.99') c from dual;

C
----------
   $123.00

SQL> select to_char(123, '$9.999,99') c from dual;
select to_char(123, '$9.999,99') c from dual
                    *
ERROR at line 1:
ORA-01481: invalid number format model


SQL>

If so, try to restore the previous form of this column in the Record Group's query, but use G (as thousands) and D (as decimal point) separators, such as

SQL> select to_char(123, '$9G999D99') c from dual;

C
----------
   $123.00

SQL>

If that's the point, then the answer might be in wrong use of current NLS settings.

Report message to a moderator

Re: FRM-30047 [message #338699 is a reply to message #336714]

Tue, 05 August 2008 13:06

mhakimjavadi
Messages: 37
Registered: July 2008

Member

No, it does not have any Error about To_Char conversion. I have just error FRM-30047 and I do not know why To_Char make this error. Please advice.
Thanks

Report message to a moderator

Re: FRM-30047 [message #338727 is a reply to message #338699]

Tue, 05 August 2008 18:35

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Using that lov and record group, does lov return that value into your block's item? check the item's data type and format.
Just my small idea. Razz

Report message to a moderator

Re: FRM-30047 [message #339001 is a reply to message #336714]

Wed, 06 August 2008 08:08

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Hi,

No the LOV does not return value to block. Also I found out that I can use TO_CHAR (NVL(min_c,0)) without mask and this is working fine without error but when I put '$9,999,999.99' mask in TO_CHAR function then I am getting error message. Is it anything wrong with this mask? Please advice.

Thanks

Report message to a moderator

Re: FRM-30047 [message #339111 is a reply to message #339001]

Wed, 06 August 2008 15:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Just being curious: did you, at least, try to modify the format mask from

$9,999,999.99

$9.999.999,99

or even

$9G999G999D99

Report message to a moderator

Re: FRM-30047 [message #339124 is a reply to message #336714]

Wed, 06 August 2008 17:53

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Hi All,

I found the problem. The problem was when TO_Char call will format mask, it will return the very big Char value and RG does not like that I just change that with:
CAST (to_char(NVL(min_t,0), '$9,999,999.99') AS VARCHAR(15))

And this is working find without any error.

Thank you to all

Report message to a moderator

Previous Topic:	WHAT IS FRM
Next Topic:	FRM-92102 Can you Help my

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:55:33 CST 2025