this is a well-known "bug" . MSSQL doesn't support creating references with cascades that reference something else that cascades (i.e. only one is allowed). There's a workaround : it's all documented here : http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#MSSQL--Microsoft-SQL-Server-
On Saturday, May 9, 2015 at 3:06:00 PM UTC+2, Paolo Valleri wrote: > > that's odd. Can you open an issue on github ( > https://github.com/web2py/pydal/issues) with a simple example to > reproduce it? I'll have a look in the next few days > > Paolo > > On Saturday, May 9, 2015 at 11:54:30 AM UTC+2, Claudinei Fernandes wrote: >> >> Hi, >> >> Has anyone used "auth.signature" attribute with MSSQL database? >> For me it is returning the following error: >> >> <class 'gluon.contrib.pypyodbc.ProgrammingError'> (u'42000', u"[42000] >> [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY >> constraint 'signature_test_modified_by__constraint' on table >> 'signature_test' may cause cycles or multiple cascade paths. Specify ON >> DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY >> constraints.") >> >> Can anyone help me please? >> > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
