[ https://issues.apache.org/jira/browse/TORQUE-262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Fox updated TORQUE-262: ------------------------------ Summary: onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL (was: onUpdate="restrict" and onDelete="restrict" cause sql syntay error in MSSQL) > onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL > ---------------------------------------------------------------------------- > > Key: TORQUE-262 > URL: https://issues.apache.org/jira/browse/TORQUE-262 > Project: Torque > Issue Type: Bug > Components: Templates > Affects Versions: 4.0-beta1 > Reporter: Thomas Fox > Priority: Minor > Fix For: 4.0 > > > RESTRICT is unknown as foreign key action for MSSQL. > Semantically, restrict means that an error should be thrown by the database > if the foreign key is invalid. > This corresponds to the MSSQL action NO ACTION. > Thus, on delete="restrict" should be rendered in MSSQL's SQL as ON DELETE NO > ACTION. > Likewiese for onUpdate. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org For additional commands, e-mail: torque-dev-h...@db.apache.org