don't know precisely how dal works, but if a table have a field referenced
in a table defined after that, wouldn't that cause a problem ?
i.e. db.define_table('route',
Field('photo_id', 'reference pictures', readable=False,
writable=False)
)
db.define_table('pictures',
Field('name'))
does not work, where
db.define_table('pictures',
Field('name'))
db.define_table('route',
Field('photo_id', 'reference pictures', readable=False,
writable=False)
)
instead works ?
Not using web2py, for normal sql development, you have to create "child"
tables before declaring a "parent" with references to it.