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.
