[ 
http://issues.apache.org/jira/browse/TORQUE-6?page=comments#action_12376498 ] 

Joerg Friedrich commented on TORQUE-6:
--------------------------------------

I have made the following changes and tested with Firebird 1.5 (directory 
...\templates\src\templates\sql\base\interbase:

1. remove the only active line from drop.vm since it creates exceptions if the 
table does not exist
2. modified file tablefk.vm (took the one from Oracle)
3. modified file foreignkey.vm (took the one from Oracle as suggested above)

Then it looks okay in my tests.






> Generator does not generate foreign key constraints for Interbase/Firebird
> --------------------------------------------------------------------------
>
>          Key: TORQUE-6
>          URL: http://issues.apache.org/jira/browse/TORQUE-6
>      Project: Torque
>         Type: Bug

>   Components: Generator
>     Versions: 3.2
>     Reporter: Joerg Friedrich

>
> The generator does not generate foreign key constraints for 
> Interbase/Firebird. This could probably be easily fixed by adding a file 
> foreignkey.vm to the sql/base/interbase directory in the templates jar 
> (torque-gen-templates-3.2.jar) containing this:
> #foreach ($fk in $table.ForeignKeys)
>     FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName 
> ($fk.ForeignColumnNames),
> #end

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
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]

Reply via email to