<https://lh3.googleusercontent.com/-KB-DKKw4Z0I/U6W30JqtjtI/AAAAAAAAAIA/odunfsgC47s/s1600/grid_commit.png> Dear web2py Community,
Does SQLFORM.grid editable=True require an *explicit* db.commit()? I did a search for "commit" on the book page "http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid-and-SQLFORM-smartgrid";. It came back empty. Here's my grid code: ... grid = SQLFORM.grid(query=query, fields=fields, headers=headers, orderby =init_sort_order, searchable=False, # just return results # changed by joe to test https://joecodeswell.com/fish/default/ex_grid_custom_search/edit/contact/92 # RESULT it allows the edit now from the above URL # PLUS the Edit buttons & the Add Record button show up in the form as well user_signature=False, links = [ (lambda row: A('Trips',_href=URL("default", "view_or_add_client_trips", vars={"client_id":[row.id]} ) )), #(lambda row: A('Trip',_href=URL("default","find_or_add_trip", vars={"client_id":[row.id]}, args=[row.id]) )), # joe note: args & vars contain same stuff ], create=True, deletable=False, editable=True, maxtextlength= 100, paginate=25) grid = SQLFORM.grid(query=query, fields=fields, headers=headers, orderby =init_sort_order, searchable=False, # just return results # changed by joe to test https://joecodeswell.com/fish/default/ex_grid_custom_search/edit/contact/92 # RESULT it allows the edit now from the above URL # PLUS the Edit buttons & the Add Record button show up in the form as well user_signature=False, links = [ (lambda row: A('Trips',_href=URL("default", "view_or_add_client_trips", vars={"client_id":[row.id]} ) )), #(lambda row: A('Trip',_href=URL("default","find_or_add_trip", vars={"client_id":[row.id]}, args=[row.id]) )), # joe note: args & vars contain same stuff ], create=True, deletable=False, editable=True, maxtextlength= 100, paginate=25) return dict(form=form, grid=grid) Here's a screenshot of some of the grid at ... default/find_or_add_contact?keywords=d: <https://lh3.googleusercontent.com/-KB-DKKw4Z0I/U6W30JqtjtI/AAAAAAAAAIA/odunfsgC47s/s1600/grid_commit.png> When i try to edit 63(Daniele, Grady) to be 63(Grady, Daniele). All goes well except the db.commit() DOES NOT SEEM to take. I.E. no change occurs in the db. What did i miss? Does anyone have any ideas? Thanks in advance. Love and peace, Joe -- 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/d/optout.
