跳至內容
選單
此問題已被標幟
1 回覆
7941 瀏覽次數

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

頭像
捨棄
最佳答案

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

頭像
捨棄
作者

thanks martin

相關帖文 回覆 瀏覽次數 活動
0
2月 16
5399
2
3月 15
5291
1
7月 19
3283
2
11月 16
6000
6
6月 21
25708