I explicitly define 'id' as primary key in b_tbl, in this case web2py
creates table with id as just INTEGER (not incremental) - I've checked it,
- it isn't problem
The problem is that web2py doesn't perform recursively search for base type
of referenced field.
It consider that FK-field couldn't reference to another FK-field
On Saturday, March 12, 2016 at 2:19:28 PM UTC+3, 黄祥 wrote:
>
> pls try :
> db.define_table('b_tbl', Field('a_tbl_id', 'reference a_tbl')
> ,Field('name') )
> db.define_table('c_tbl', Field('b_tbl_id', 'reference b_tbl')
> ,Field('name') )
>
> i think in b_tbl, field id is already there as the integer auto increment
> primary key, so when you redefine another field with the same name, it can
> cause an error.
>
> 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.
