[
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: [email protected]
For additional commands, e-mail: [email protected]
