True, it worked this way. after db.table.drop() imported again the records and the ondelete='SET NULL' at the field definition does the job ok now.
Thanks Anthony El miércoles, 4 de julio de 2018, 16:20:04 (UTC+2), Anthony escribió: > > 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.
