OraFAQ Forum: Forms » returning list item datatype values to number datatype

Home » Developer & Programmer » Forms » returning list item datatype values to number datatype

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

returning list item datatype values to number datatype [message #214816]

Thu, 18 January 2007 03:23

ataufique
Messages: 79
Registered: November 2006

Member

hi..
I have a table in which a column name DCH is having datatype as
number(2).
In my form i am keeping DCH as list item and the code for
record group is
'SELECT DISTINCT TO_CHAR(DCH),TO_CHAR(DCH) FROM TAP
ORDER BY TO_NUMBER(DCH)');

While updating when i select the value from list item it gives error as "Acceptable values are 0-9".

Please support

Thanks in advance.

Report message to a moderator

Re: returning list item datatype values to number datatype [message #214922 is a reply to message #214816]

Thu, 18 January 2007 10:50

scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England

Senior Member

Are you using the LOV to return a value to a field on the form? You are returning your LOV values as char, so if your form field is a number then you will get your error. Is there any reason you use TO_CHAR in the LOV?

Report message to a moderator

Re: returning list item datatype values to number datatype [message #215365 is a reply to message #214922]

Sun, 21 January 2007 21:43

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yes. Don't use the to_char.

David

Report message to a moderator

Re: returning list item datatype values to number datatype [message #215384 is a reply to message #214816]

Sun, 21 January 2007 23:44

sameer_am2002
Messages: 129
Registered: September 2002

Senior Member

You can define LOV's such way please find my attachment fmb file..

You will c tablecreation_script program unit in this file..First copy that and run in sqlplus. Then delete this program unit and run fmb file..

This is because only 1 file uploading is allowed per message..

Attachment: LOVTEST.fmb
(Size: 40.00KB, Downloaded 1051 times)

Report message to a moderator

Previous Topic:	Insert a record in the first row
Next Topic:	Conversion of Developer 2000 forms to Visual .net

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 03:42:17 CDT 2025