Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
7848 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Autor

thanks martin

Powiązane posty Odpowiedzi Widoki Czynność
0
lut 16
5276
2
mar 15
5138
1
lip 19
3170
2
lis 16
5888
6
cze 21
25459