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? >>>> >>> --
