Home » Developer & Programmer » Forms » returning list item datatype values to number datatype
returning list item datatype values to number datatype [message #214816] Thu, 18 January 2007 03:23 Go to next message
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.
Re: returning list item datatype values to number datatype [message #214922 is a reply to message #214816] Thu, 18 January 2007 10:50 Go to previous messageGo to next message
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?
Re: returning list item datatype values to number datatype [message #215365 is a reply to message #214922] Sun, 21 January 2007 21:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes. Don't use the to_char.

David
Re: returning list item datatype values to number datatype [message #215384 is a reply to message #214816] Sun, 21 January 2007 23:44 Go to previous message
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 158 times)
Previous Topic: Insert a record in the first row
Next Topic: Conversion of Developer 2000 forms to Visual .net
Goto Forum:
  


Current Time: Tue Dec 06 10:12:14 CST 2016

Total time taken to generate the page: 0.19008 seconds