OraFAQ Forum: Forms » Data type error..

Home » Developer & Programmer » Forms » Data type error..

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

Data type error.. [message #584895]

Mon, 20 May 2013 06:58

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hello every body!

"SUM_TOTAL_RECEIVED" ,this is Item name and i set all Calculation Properties correctly and when compile the form , i got an error

FRM-30405: Datatype for Sum/Avg/Variance/Stddev summarized item must be Number.
Item: SUM_TOTAL_RECEIVED
Block: RHCLANDEDCOSTDET_PROMPT
FRM-30085: Unable to adjust form for output.

Thanks,

Report message to a moderator

Re: Data type error.. [message #584897 is a reply to message #584895]

Mon, 20 May 2013 07:03

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

Senior Member
Account Moderator

Oracle says that SUM_TOTAL_RECEIVED item's datatype is not a NUMBER.

Report message to a moderator

Re: Data type error.. [message #584898 is a reply to message #584897]

Mon, 20 May 2013 07:05

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks,

So, which type of data type select?

Report message to a moderator

Re: Data type error.. [message #584900 is a reply to message #584898]

Mon, 20 May 2013 07:07

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

Senior Member
Account Moderator

What do you think?

Report message to a moderator

Re: Data type error.. [message #584902 is a reply to message #584898]

Mon, 20 May 2013 07:09

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

what type of data type ,to select for this..

Thanks,

Report message to a moderator

Re: Data type error.. [message #584903 is a reply to message #584902]

Mon, 20 May 2013 07:11

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

Senior Member
Account Moderator

NUMBER.

Report message to a moderator

Re: Data type error.. [message #584904 is a reply to message #584902]

Mon, 20 May 2013 07:13

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok,

But i gave Number, it gives an error..

Report message to a moderator

Re: Data type error.. [message #584905 is a reply to message #584904]

Mon, 20 May 2013 07:15

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

Senior Member
Account Moderator

Could you post SUM_TOTAL_RECEIVED item's Property Palette screenshot?

Also, try to Compile All (Ctrl + Shift + K).

[Updated on: Mon, 20 May 2013 07:15]

Report message to a moderator

Re: Data type error.. [message #584910 is a reply to message #584905]

Mon, 20 May 2013 07:55

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

I tried to ctrl+shift+k ,i successfully compiled, but,when i tried to generate .fmb to .fmx

it shows same as

FRM-30405: Datatype for Sum/Avg/Variance/Stddev summarized item must be Number.
Item: SUM_TOTAL_RECEIVED
Block: RHCLANDEDCOSTDET_PROMPT

FRM-30085: Unable to adjust form for output.

AND I ATTACHED SCREEN SHOTS..

Thanks,

Attachment: image1.png
(Size: 61.12KB, Downloaded 1112 times)

Report message to a moderator

Re: Data type error.. [message #584915 is a reply to message #584910]

Mon, 20 May 2013 08:07

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Sorry Littlefoot, actually my system had been hanged, that's why i post lately..

Thanks,

Report message to a moderator

Re: Data type error.. [message #584916 is a reply to message #584910]

Mon, 20 May 2013 08:08

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

What's the datatype of total_received?

Report message to a moderator

Re: Data type error.. [message #584917 is a reply to message #584916]

Mon, 20 May 2013 08:09

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Char data type..

Report message to a moderator

Re: Data type error.. [message #584920 is a reply to message #584917]

Mon, 20 May 2013 08:17

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

thanks, Littlefoot..

I forgot to change the data type of type "total_received" char to number..

Thanks.

Report message to a moderator

Re: Data type error.. [message #584986 is a reply to message #584920]

Tue, 21 May 2013 02:11

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hello sir,

I have 2 blocks named RHCLANDEDCOSTDET,RHCLANDEDCOSTDET_PROMPT and QUANTITY_RECEIVED is in Both Blocks and i set the all properties correctly, but error's are showing in Applications like that below:

frm-40212 invalid value for field QUANTITY_RECEIVED
frm-41805: ambiguous item name QUANTITY_RECEIVED

Attachment: Error1.jpg
(Size: 32.00KB, Downloaded 1032 times)

[Updated on: Tue, 21 May 2013 02:17]

Report message to a moderator

Re: Data type error.. [message #584987 is a reply to message #584986]

Tue, 21 May 2013 02:20

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

Senior Member
Account Moderator

Oracle errors

FRM-40210: Invalid value for field %s.

CAUSE: Caused by one of the following: 1. The value is not of the proper data type. 2. The value does not match any of the list of acceptable values. 3. For a text field, the value does not match the specified range.

ACTION: Retry with another value. Level: >20 Type: Error

FRM-41805: Ambiguous item name: %s.

CAUSE: Application design error. Ambiguous item name.

ACTION: Level: >25 Type: Error

Do you have more than one item whose name is QUANTITY_RECEIVED?

Report message to a moderator

Re: Data type error.. [message #584988 is a reply to message #584987]

Tue, 21 May 2013 02:25

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

yes, i have more than one item QUANTITY_RECEIVED, other items are fine,but QUANTITY_RECEIVED shows an error..

Report message to a moderator

Re: Data type error.. [message #584989 is a reply to message #584988]

Tue, 21 May 2013 02:26

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

Senior Member
Account Moderator

You shouldn't have it. Item names should be unique.

Why did you do that, anyway?

Report message to a moderator

Re: Data type error.. [message #584990 is a reply to message #584989]

Tue, 21 May 2013 02:28

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok,

why this error came..FRM-40210: Invalid value for field ,i set all properties correctly

Thanks,

Report message to a moderator

Re: Data type error.. [message #584991 is a reply to message #584990]

Tue, 21 May 2013 02:31

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

Senior Member
Account Moderator

I already told you; re-read message #584987.

Report message to a moderator

Re: Data type error.. [message #584992 is a reply to message #584991]

Tue, 21 May 2013 02:36

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thank you Littlefoot..

My Query is in "Functional" properties, Justification(Right,Left..) is there
why we are using these, can you explain please..

Thanks,

Report message to a moderator

Re: Data type error.. [message #584993 is a reply to message #584992]

Tue, 21 May 2013 02:39

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

Senior Member
Account Moderator

Click with a mouse into that property. At the bottom of the Property Palette you'll see a short explanation. For more information, press F1 (Help).

Report message to a moderator

Previous Topic:	matrix form in oracle
Next Topic:	Need Help on Oracle Forms to MS-Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:27:39 CST 2025