Alex,
Just noticed that it is not the calculation. The error lies in the Size 1 &
Size 2 of my db. These values could be decimal. So let me post this again.
db:
Field('size1'),
Field('size2'),
Field('color','reference color'),
error:
Traceback (most recent call last):
File "Applications/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
File
"Applications/web2py/applications/MosaicCatalogBuilder/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/MosaicCatalogBuilder/controllers/appadmin.py>,
line 463, in <module>
File "Applications/web2py/gluon/globals.py", line 412, in <lambda>
self._caller = lambda f: f()
File
"Applications/web2py/applications/MosaicCatalogBuilder/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/MosaicCatalogBuilder/controllers/appadmin.py>,
line 299, in update
if form.accepts(request.vars, session):
File "Applications/web2py/gluon/sqlhtml.py", line 1686, in accepts
self.id_field_name]).update(**fields)
File "Applications/web2py/gluon/packages/dal/pydal/objects.py", line 2020, in
update
ret = db._adapter.update("%s" % table._tablename,self.query,fields)
File "Applications/web2py/gluon/packages/dal/pydal/adapters/base.py", line
996, in update
raise e
IntegrityError: FOREIGN KEY constraint failed
Thanks!
On Thursday, July 16, 2015 at 3:30:24 PM UTC-7, Alex wrote:
>
> Posting the error information would probably help. Leaving the type blank
> sets 'string' as default. According to the documentation there is only a
> type 'double' but no type 'float'. What's the data type of your column in
> the db?
>
> Alex
>
--
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.
