finally found the culprit : lazy_tables = True on db = DAL('sqlite://test.sqlite', pool_size = 30, check_reserved = ['all'], migrate = True, fake_migrate_all = False, lazy_tables = True)
my question is why lazy_tables = True is affected the linked tables on the smartgrid? i found the solution just set lazy_tables = False or simply just remove lazy_tables = True check on web2py book it said : Because usually in web2py models are executed before controllers, it is possible that some table are defined even if not needed. It is therefore necessary to speed up the code by making table definitions lazy. This is done by setting the DAL(...,lazy_tables=True) parameter. Tables will be actually created only when accessed. just don't know the reason of it, i've accessed the tables by insert the data on it via sqlform smartgrid and the tables already created before i insert it for the first time (checked on database administration) any idea about this? thanks and 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.