Can selection fields save floats to the DB or just integers and strings?

Question

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

Prakash · 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'),

関連投稿	返信	ビュー
how can I make a one2many field a selection field in view fields selection	2 12月 17	16870
How to pass values to a method that defines selection for multiple fields? fields selection	0 4月 15	3901
How To Change Field Value According To Selection Field Openerp? fields selection	1 3月 15	9450
Why in Selection Field Only Key is Store in Database Not the Value ? 解決済 fields database selection	1 12月 24	1537
Missing Field error fields missing	1 3月 24	1576

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！