Thanks Massimo, I will try this. 2017-03-20 11:41 GMT-03:00 Massimo Di Pierro <massimo.dipie...@gmail.com>:
> Unfortunately not out of the box. You need a custom button that does a > ajax query. > > > On Friday, 3 March 2017 17:52:30 UTC-6, 黄祥 wrote: >> >> is it possible to edit or delete child or detail table on SQLFORM.grid >> with left join? >> i've tried before it seems the edit is for the first table (parent or >> header), the child or detail table cannot be edited or deleted with left >> join in SQLFORM.grid. >> *e.g.* >> def report_production_result(): >> table_header = db.production_result_header >> table_detail = db.production_result_detail >> >> orderby = ~table_header.id >> left = table_detail.on(table_header.id == table_detail.production_result >> _no) >> fields = [ >> # header >> table_header.id, table_header.production_result_no, >> table_header.production_result_date, >> table_header.shift, table_header.origin, table_header.status, >> # detail >> table_detail.stock, table_detail.quantity] >> grid = SQLFORM.grid(table_header, fields = fields, left = left, orderby = >> orderby) >> return locals() >> >> 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/d/optout. > -- 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/d/optout.