Skip to Content
Menu
This question has been flagged
1 Reply
7821 Views

hi all

i have this field

class holidays_detail(models.Model):
    _name = 'holiday.detail'

    date_start = fields.Date(string='Start Date',required=True )   

     hari = fields.Char(string='Day')

i want when i choose date ini field date_start its onchange to field hari with value (weekday name ex :Sunday)

i have this method


def onchange_date(self, cr, uid, ids, date_start):
        res ={}       

         if date_start :
            a = datetime.strptime(date_start,"%Y-%m-%d")           

             if a :
                b = datetime.strftime(a, '%A')               

                res = {'hari': b }                

             return {'value': res}      

          return True


its work ! but when i save its getting error  like this

File "/home/susi/odoo/openerp-8.0/openerp/sql_db.py", line 234, in execute    res = self._obj.execute(query, params)

DataError: invalid input syntax for integer: "Friday"

LINE 1: ...('holiday_detail_id_seq'), 7, '2016-09-23', NULL, 'Friday', ...

                                                             ^

anyone can help me what wrong with my code ? thanks before

Avatar
Discard
Best Answer

Check hari field on DB table, it seems to be an integer instead of char.

Did you initially defined the field as an integer? If so, restart the service and update the module. After that, the field should be defined as char in DB

Avatar
Discard
Author

thanks martin

Related Posts Replies Views Activity
0
Feb 16
5212
2
Mar 15
5111
1
Jul 19
3145
2
Nov 16
5865
6
Jun 21
25396