I'll make up a little test app, submit a ticket and add the app for testing.
On Thu, Jul 11, 2013 at 1:04 PM, Massimo Di Pierro < [email protected]> wrote: > Good point! It should be the first table mentioned in the query but, this > could be customizable. Please open a ticket about this. > > > On Thursday, 11 July 2013 12:47:42 UTC-5, Jim S wrote: > >> Thanks for the reply Massimo. I know grid can only edit one table and >> that is what I want. I'm just wondering how it chooses which table it is >> editing if the left parameter is specified. Also, in my example above, it >> should be >> >> grid = SQLFORM.grid(query, left=left) >> >> -Jim >> >> >> On Thu, Jul 11, 2013 at 12:08 PM, Massimo Di Pierro < >> [email protected]> wrote: >> >>> grid can only edit one table. smartgrid can edit referenced tables but >>> not join them. >>> Unfortunately we cannot support both because logically it would be too >>> complex. You can create your own custom button. >>> >>> >>> On Thursday, 11 July 2013 09:02:09 UTC-5, Jim S wrote: >>>> >>>> I have a controller method with a SQLFORM.grid in it. >>>> >>>> The following setup: >>>> >>>> >>>> query = db.pricingIngredient.**pricingIn**gredientId > 0 >>>> left = [db.productSite.on(db.**pricingI**ngredient.** >>>> productSiteId==db.**productSite.**productSiteId), >>>> db.site.on(db.productSite.**site**Id==db.site.siteId), >>>> db.product.on(db.productSite.**p**roductId==db.product.** >>>> productId**)] >>>> >>>> grid = SQLFORM.grid(query, left) >>>> >>>> When I click on the edit button I want to edit the pricingIngredient >>>> table. However, SQLFORM.grid is taking me to edit the product table. >>>> >>>> Is there a way to override this and force it to edit the >>>> pricingIngredient table without coding my own custom edit button? >>>> >>>> -Jim >>>> >>>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>> topic/web2py/Yl-6-oYA9C4/**unsubscribe<https://groups.google.com/d/topic/web2py/Yl-6-oYA9C4/unsubscribe> >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+un...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/Yl-6-oYA9C4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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/groups/opt_out.
