did you open an issue? http://code.google.com/p/web2py/issues/list
On Saturday, October 6, 2012 11:28:32 AM UTC-7, Gerd wrote: > > Hi! > > Any updates on this? > > Am Sonntag, 30. September 2012 16:16:33 UTC+2 schrieb Gerd: >> >> Hi! >> >> I'm actually using V2.0.9 and the error is still active. Is it fixed in >> 2.1.0? >> >> Thanks, >> Gerd >> >> Am Donnerstag, 13. September 2012 20:24:01 UTC+2 schrieb Mandar Vaze: >>> >>> For now, I'm calling db.commit on my own ondelete function >>> >>> def my_ondelete_function(table, record_id): >>> print "Deleting %s from %s" % (record_id, table) >>> >>> db(table[table._id.name]==record_id).delete() >>> >>> db.commit() >>> >>> so technically same delete() gets called twice - first in my ondelete >>> function (listed above) and then immediately in gluon/sqlhtml.py >>> I know it is wrong/incorrect, but seems to be working for me. >>> >>> Waiting for suggestions/comments from the group. >>> >>> -Mandar >>> >>> On Thursday, September 13, 2012 11:46:09 PM UTC+5:30, Mandar Vaze wrote: >>>> >>>> I'm using version 2.0.7 and seeing the same problem. >>>> I looked at the gluon/sqlhtml.py and it doesn't look like problem is >>>> specific to custom query (Although I too have custom query passed to the >>>> sqlform.grid) >>>> >>>> elif deletable and len(request.args)>2 and >>>> request.args[-3]=='delete': >>>> table = db[request.args[-2]] >>>> >>>> if ondelete: >>>> >>>> ondelete(table,request.args[-1]) >>>> >>>> ret = db(table[table._id.name]==request.args[-1]).delete() >>>> >>>> db.commit() # If I add this, the record is deleted from DB too >>>> return ret >>>> >>>> I confirmed this by adding "db.commit()" just prior to returning. >>>> Without this line, the record is removed from the table - but not form DB. >>>> So next time we refresh and re-render the table, the deleted record >>>> re-appears >>>> >>>> BTW, I have another function for bulk_delete (User selects from >>>> checkbox, and deleted selected records in one go) I am not calling >>>> db.commit() there explicitly but the records are indeed deleted from DB. >>>> >>>> What is going on ? >>>> >>>> -Mandar >>>> >>>> On Tuesday, June 12, 2012 6:14:38 PM UTC+5:30, rahulserver wrote: >>>>> >>>>> I have the following sqlform.grid: >>>>> COMMITMENTS=SQLFORM.grid((db.Commitments.Account==session.id >>>>> ),user_signature=False) >>>>> >>>>> When I try to edit any row of the form, the edit is not committing. Is >>>>> it that the sqlform.grid does not allow edits for query arguments? >>>>> >>>> --
