Hello again!
Say... has anyone had any problems getting the "deletable" function to work properly with SQL FORMs? My database is MS SQL Server, btw. Here's my code: items_form=SQLFORM(db_bosswalk.BW_items, record=items_records[0], deletable=True, showid=False, delete_label='Delete this item?:', submit_button = 'Save', fields=items_field_list, labels=items_field_labels) My form is rendering properly (the check box and label are there). When I check the box and 'save' the record, the 'Record was saved' message is shown. Unfortunately however, the row is NOT deleted from the MS SQL Server table when I check the table using SQL Studio, or pull up a Web2py grid that displays this table. The row CAN be deleted using MS SQL Server's Studio app. And my Web2py app CAN add and update records just fine, so permissions don't appear to be part of the problem. The only "special" thing about this table is that another table has a foreign key on it, with a cascading delete trigger on it. The delete fails whether this other table has a corresponding row in it or not. I'm just looking to see if anyone else has experienced any problem(s) using this feature. Thanks! Todd B. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
