Ticket 1581
On Thursday, July 11, 2013 1:13:06 PM UTC-5, Jim S wrote: > > 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.
