Home » Developer & Programmer » Forms » Data type error..
Data type error.. [message #584895] Mon, 20 May 2013 06:58 Go to next message
mist598
Messages: 986
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,
Re: Data type error.. [message #584897 is a reply to message #584895] Mon, 20 May 2013 07:03 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle says that SUM_TOTAL_RECEIVED item's datatype is not a NUMBER.
Re: Data type error.. [message #584898 is a reply to message #584897] Mon, 20 May 2013 07:05 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks,

So, which type of data type select?
Re: Data type error.. [message #584900 is a reply to message #584898] Mon, 20 May 2013 07:07 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you think?
Re: Data type error.. [message #584902 is a reply to message #584898] Mon, 20 May 2013 07:09 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
what type of data type ,to select for this..

Thanks,
Re: Data type error.. [message #584903 is a reply to message #584902] Mon, 20 May 2013 07:11 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
NUMBER.
Re: Data type error.. [message #584904 is a reply to message #584902] Mon, 20 May 2013 07:13 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
Ok,

But i gave Number, it gives an error..
Re: Data type error.. [message #584905 is a reply to message #584904] Mon, 20 May 2013 07:15 Go to previous messageGo to next message
Littlefoot
Messages: 19697
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 Go to previous messageGo to next message
mist598
Messages: 986
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 68 times)
Re: Data type error.. [message #584915 is a reply to message #584910] Mon, 20 May 2013 08:07 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
Sorry Littlefoot, actually my system had been hanged, that's why i post lately..

Thanks,
Re: Data type error.. [message #584916 is a reply to message #584910] Mon, 20 May 2013 08:08 Go to previous messageGo to next message
cookiemonster
Messages: 11076
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's the datatype of total_received?
Re: Data type error.. [message #584917 is a reply to message #584916] Mon, 20 May 2013 08:09 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
Char data type..
Re: Data type error.. [message #584920 is a reply to message #584917] Mon, 20 May 2013 08:17 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
thanks, Littlefoot..


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

Thanks.
Re: Data type error.. [message #584986 is a reply to message #584920] Tue, 21 May 2013 02:11 Go to previous messageGo to next message
mist598
Messages: 986
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 56 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 Go to previous messageGo to next message
Littlefoot
Messages: 19697
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?
Re: Data type error.. [message #584988 is a reply to message #584987] Tue, 21 May 2013 02:25 Go to previous messageGo to next message
mist598
Messages: 986
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..
Re: Data type error.. [message #584989 is a reply to message #584988] Tue, 21 May 2013 02:26 Go to previous messageGo to next message
Littlefoot
Messages: 19697
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?
Re: Data type error.. [message #584990 is a reply to message #584989] Tue, 21 May 2013 02:28 Go to previous messageGo to next message
mist598
Messages: 986
Registered: February 2013
Location: Hyderabad
Senior Member
Ok,

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

Thanks,
Re: Data type error.. [message #584991 is a reply to message #584990] Tue, 21 May 2013 02:31 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I already told you; re-read message #584987.
Re: Data type error.. [message #584992 is a reply to message #584991] Tue, 21 May 2013 02:36 Go to previous messageGo to next message
mist598
Messages: 986
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,
Re: Data type error.. [message #584993 is a reply to message #584992] Tue, 21 May 2013 02:39 Go to previous message
Littlefoot
Messages: 19697
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).
Previous Topic: matrix form in oracle
Next Topic: Need Help on Oracle Forms to MS-Excel
Goto Forum:
  


Current Time: Sat Oct 25 11:03:53 CDT 2014

Total time taken to generate the page: 0.25146 seconds