On Wednesday, July 4, 2018 at 10:12:58 AM UTC-4, JSalvat wrote: > > Hi Pierre, how did you solve this ? > > ondelete='SET NULL' on sqlite is not working, it deletes all records on > the child table associated with the deleted record on the father table > instead of seting empty on the refered field. >
I think this is one of the things that cannot be changed, so if you started with the default "CASCADE" behavior, you may need to drop the table and create a new one with "SET NULL" specified from the beginning. Anthony -- 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.
