Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
7853 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Penulis

thanks martin

Post Terkait Replies Tampilan Aktivitas
0
Feb 16
5284
2
Mar 15
5147
1
Jul 19
3184
2
Nov 16
5896
6
Jun 21
25492