That fixed it! On Thursday, April 21, 2016 at 3:30:39 PM UTC-4, Anthony wrote: > > Try with a fresh table and see if cascade works. > > On Thursday, April 21, 2016 at 3:27:25 PM UTC-4, Mark Billion wrote: >> >> It was added later. >> >> On Thursday, April 21, 2016 at 3:23:19 PM UTC-4, Anthony wrote: >>> >>> Was Income_Src a reference field when you first created the table, or >>> did you make that change later? >>> >>> On Thursday, April 21, 2016 at 2:16:10 PM UTC-4, Mark Billion wrote: >>>> >>>> No, I mean the first one. I delete an income entry and the associated >>>> deduction entries still stick around..... >>>> >>>> Btw, when I run MYSQL> SHOW CREATE TABLE deductions, I get: >>>> >>>> deductions | CREATE TABLE `deductions` ( >>>> `id` int(11) NOT NULL AUTO_INCREMENT, >>>> `client` varchar(512) DEFAULT NULL, >>>> `Deduction_Type` varchar(512) DEFAULT NULL, >>>> `Income_Src` varchar(512) DEFAULT NULL, >>>> `Deduction_Amount` decimal(18,2) DEFAULT NULL, >>>> `B_22_Deduction_Amount` decimal(18,2) DEFAULT NULL, >>>> `Additional_Description` varchar(50) DEFAULT NULL, >>>> `deduction_type_string` varchar(512) DEFAULT NULL, >>>> `deduction_line_string` varchar(512) DEFAULT NULL, >>>> `income_src_cat` varchar(512) DEFAULT NULL, >>>> `income_src_string` varchar(512) DEFAULT NULL, >>>> PRIMARY KEY (`id`) >>>> ) ENGINE=InnoDB AUTO_INCREMENT=302 DEFAULT CHARSET=utf8 | >>>> >>>> >>>> >>>> >>>> On Thursday, April 21, 2016 at 2:11:34 PM UTC-4, Leonel Câmara wrote: >>>>> >>>>> Do you mean you delete something in table "income" and nothing is >>>>> deleted in "deductions"? >>>>> >>>>> Or do you mean you delete something from the set DEBTOR_TOGGLE_NO_BOTH >>>>> and no row is deleted in table "income"? >>>>> >>>>> The second one is obviously to be expected since cascading is a >>>>> database operation and the element you deleted would be in a set in your >>>>> code not in the dabatase. >>>>> >>>>
-- 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.
