Hello everyone,
I have the following table definitions:
db.define_table('identities',
Field('name', 'string', required=True),
Field('profession', 'string', required=True),
Field('address','text', required=True),
Field('vat_number',unique=True, required=True, length=9,
requires=IS_LENGTH(9)),
Field('tax_office', 'string', required=True),)
db.define_table('items,',
Field('is_receipt', 'boolean', required=True),
Field('serial_number','integer', required=True),
Field('issue_date', 'date', required=True),
Field('issued_to', 'reference identities', required=True),
Field('item_value', 'decimal(10,2)', required=True),
Field('is_vat_liable', 'boolean', required=True),
Field('vat_percentage', 'decimal(3,2)', required=True),
Field('net_value', compute=lambda row:
row['value']/(row['vat_percentage']+1), writable=False),
Field('is_retained_value', 'boolean', required=True),
Field('retain_percentage', 'decimal(3,2)', required=True),
Field('retain_value', compute=lambda row:
(row['net_value']*row['retain_percentage']), writable=False),
Field('is_eu_transaction', 'boolean', required=True),)
That produce the following error:
Error ticket for "vivlio_b" Ticket ID
127.0.0.1.2013-08-31.18-30-38.e65726e8-d6a9-4059-8f43-41a45314340e
<class 'sqlite3.OperationalError'> near ",": syntax error Version web2py™
Version
2.5.1-stable+timestamp.2013.06.06.15.39.19 Python Python 2.7:
E:\web2py\web2py_no_console.exe (prefix: E:\web2py) Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
Traceback (most recent call last):
File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 212, in
restricted
File "E:/web2py/applications/vivlio_b/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/vivlio_b/models/db.py>, line 49, in
<module>
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7788, in
define_table
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7825, in
lazy_define_table
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 963, in
create_table
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1767, in
create_sequence_and_triggers
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1784, in execute
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1778, in
log_execute
OperationalError: near ",": syntax error
Maybe someone can shed some light on this ?
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
