There's no need to change the field type. If you don't want to display the reference fields in the grid at all, just set the "readable" attribute to False. You can also pass a list of fields to the grid to display -- other fields will be excluded. If you do want to include the reference fields but want them to simply show the stored id values rather than doing recursive selects to retrieve values from the referenced table, just set db.tablename.field.represent = None.
Anthony On Wednesday, January 8, 2014 4:40:36 PM UTC-5, MVolpes wrote: > > Hi > > I am loving the smart grid but the amount of references is killing > it....very slow. > > Removing the references and using multiple lefts is a workable option > however I do want the goodness of references when editing a particular row > in the edit field > > Can I change the type dynmaically? > > eg it is a integer I would set it to reference > > I have tried > > db.tablename.field.type = "reference othertable" this changes it when I > view > > print db.tablename.field > >>"reference othertable" > > but when applied to the grid....nothing happens.... > -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
