TypeError: 'long' object is not iterable .....when i add one2many field

one2many sale.order object

1 ตอบกลับ

12455 มุมมอง

Krishna

in .py file--

class hotel_folio(osv.osv):


         _name = 'hotel.folio'
        _description = 'hotel folio new'
        _columns = {
            'sale_lines':fields.one2many('hotel.sale.line', 'folio_id', ondelete='cascade'),
            }

hotel_folio()

    class hotel_sale_line(osv.osv):

        _name = 'hotel.sale.line'
        _description = "Sale Line"
        _columns = {
                'order_line': fields.one2many('sale.order', 'order_line', 'Order Lines'),
                'folio_id':fields.many2one('hotel.folio'),
                }

hotel_sale_line()

And in .xml file--

                        <field name="sale_lines" colspan="4" nolabel="1">
                            <form string="Sale Order Line">
                            <separator string="Sale Order"/>
                            <field name="order_line" select="1" colspan="4" nolabel="1"/>                               
                            </form>
                            <tree string="Sale Order Line">
                            <field name="order_line" select="1"/>                               
                            </tree>
                        </field>

the error is---

File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\orm.py", line 4469, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\fields.py", line 557, in set File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\sale_stock\sale_stock.py", line 75, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\sale\sale.py", line 337, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\mail\mail_thread.py", line 242, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\orm.py", line 4469, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\fields.py", line 554, in set TypeError: 'long' object is not iterable

saad

Hi,

the ondelete attribure isn't in the right place
we don't use select="1" in one2many fields
You should create the relation id field (order_line) in sale.order object

Try this for your python file:

class hotel_folio(osv.osv):
         _name = 'hotel.folio'
        _description = 'hotel folio new'
        _columns = {
            'sale_lines':fields.one2many('hotel.sale.line', 'folio_id','Lines' ),
            }

hotel_folio()

class hotel_sale_line(osv.osv):

        _name = 'hotel.sale.line'
        _description = "Sale Line"
        _columns = {
                'order_line': fields.one2many('sale.order', 'order_line', 'Order Lines'),
                'folio_id':fields.many2one('hotel.folio','Related Folio', ondelete='cascade'),
                }
hotel_sale_line()

Krishna

ผู้เขียน

in sale.order, the relation was established already like this--------------------------- 'order_line': fields.one2many('sale.order.line', 'order_id', 'Order Lines', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}),

saad

This relation is between sale.order and sale.order.line. Your need is not clear, you may want that your 'hotel.folio' has many sale.order.line !!

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
One2Many relation - pass the parent id one2many relationship sale.order	0 มี.ค. 15	6288
how to add a tree view in openerp 7? treeview one2many object	1 มี.ค. 15	10216
How to change tree view column structure on One2many selection? one2many sale.order.line sale.order odoov11	1 ต.ค. 20	6284
Display field only for one company on list view แก้ไขแล้ว sale.order	1 พ.ค. 25	3210
how pass value to on2many field from parent form via context one2many	1 ม.ค. 25	4428

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!