I see serial(fk) in your tables definition, but FK couldn't be serial,
serial means generative id by sequence
There is a little singularity in web2py - if you specify "id" as "reference
..." but don't specify it as primarykey=['id'] explicit then web2py treats
it as serial id and ignores fk-
db.define_table('table_1_name',
Field('field_1_name','string'))
db.define_table('table_2_name',
Field('table_1_reference_field','reference table_1_name'))
It looks like you defined the field as an integer field and then are
attempting to redefine it as a reference field.
-Mark
On Sunda
On Sunday, February 28, 2016 at 11:50:58 PM UTC+5:30, prashant joshi wrote:
>
> how to conecting table??
> how to use refernce??
>
*Field('sid','integer', 'reference stud_person')*
i use this
it is correct???
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http:/
3 matches
Mail list logo