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.
