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.
