[web2py] Re: cannot make ondelete='SET NULL' to work

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, J

[web2py] Re: cannot make ondelete='SET NULL' to work

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

[web2py] Re: cannot make ondelete='SET NULL' to work

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. Thanks for your help. El jueves, 28 de enero de 2016, 13:13:50 (

[web2py] Re: cannot make ondelete='SET NULL' to work

I found the trick on the internet : db.table.drop() what a beautiful day today conclusion: destruction can only be 'cured' by destruction :) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/w