Skip to Content
This question has been flagged
decimalerrorfieldsselectionfloating
1 Respondre
8270 Vistes
Avatar
Eric

Hello, I am creating a module with a selection field. I would like a float number to be saved to the DB when a user selects a choice from the selection drop down, but when I make a selection then I get an error like this:

DataError: invalid input syntax for integer: "0.25"

So my question is, can floating numbers be used as values for a selection field, or can you use only integers or strings? Thank you

Avatar
Descartar
Avatar
Prakash
Best Answer

Yes Selection Field value save characters or Integer in Database.

Format of the selection parameter: tuple of tuples of strings of the form: (('key_or_value', 'string_to_display'), ... )

The below code shows display float value as string in Front view and Back-end store key value. 

 'type': fields.selection([('CodeA', '0.25'), ('CodeB', '0.50')], 'Type'),
Avatar
Descartar
Related Posts Respostes Vistes Activitat
how can I make a one2many field a selection field in view Solved
fields selection
Avatar
Avatar
Avatar
3
d’oct. 25
18560
How to pass values to a method that defines selection for multiple fields?
fields selection
Avatar
0
d’abr. 15
4955
How To Change Field Value According To Selection Field Openerp?
fields selection
Avatar
Avatar
1
de març 15
10429
Why in Selection Field Only Key is Store in Database Not the Value ? Solved
fields database selection
Avatar
Avatar
1
de des. 24
2555
Missing Field
error fields missing
Avatar
Avatar
1
de març 24
2479