I think the main point is that for a computed field you need to pass fields
which happens to be the factors of the calculation: how can pydal compute
the value if you don't pass the actual values are needed to compute ???
that being said, if you are using database callbacks you can just use that
callback to compute the value ^_^
On Sunday, January 24, 2016 at 3:31:18 AM UTC+1, 黄祥 wrote:
>
> still face the same error :
> e.g.
> db.define_table('default_size',
> Field('name'),
> Field('length_in_cm', 'double'),
> Field('width_in_cm', 'double'),
> Field('total_square_meter', 'double'),
> Field('acquisition_price', 'integer') )
>
> db.default_size.total_square_meter.compute = lambda r:
> (float(r['length_in_cm'] ) * float(r['width_in_cm'] ) ) / 10000
>
> def __after_insert_purchase_order_detail(f, id):
> db(db.default_size.id == f.default_size).update(acquisition_price =
> f.price)
>
>
> db.purchase_order_detail._after_insert.append(__after_insert_purchase_order_detail)
>
> Traceback (most recent call last):
> File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 227, in
> restricted
> exec ccode in environment
> File
> "/Users/MacBookPro/site/web2py/applications/glassworkshop/controllers/transaction.py"
>
> <http://127.0.0.1:8000/admin/default/edit/glassworkshop/controllers/transaction.py>,
> line 246, in <module>
> File "/Users/MacBookPro/site/web2py/gluon/globals.py", line 412, in <lambda>
> self._caller = lambda f: f()
> File
> "/Users/MacBookPro/site/web2py/applications/glassworkshop/controllers/transaction.py"
>
> <http://127.0.0.1:8000/admin/default/edit/glassworkshop/controllers/transaction.py>,
> line 174, in purchase_order_header
> price = price)
> File "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py",
> line 734, in insert
> [f(fields, ret) for f in self._after_insert]
> File
> "/Users/MacBookPro/site/web2py/applications/glassworkshop/models/db_wizard_4_purchase_order.py"
>
> <http://127.0.0.1:8000/admin/default/edit/glassworkshop/models/db_wizard_4_purchase_order.py>,
> line 66, in __after_insert_purchase_order_detail
> db(db.default_size.id == f.default_size).update(acquisition_price =
> f.price)
> File "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py",
> line 2056, in update
> fields = table._listify(update_fields,update=True)
> File "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py",
> line 686, in _listify
> raise SyntaxError('unable to compute field: %s' % name)
> SyntaxError: unable to compute field: total_square_meter
>
>
> is there any way to face this?
>
> thanks and best regards,
> stifan
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
