MySQL gives me an error when Torque attempts to execute my generated .sql file. This happens because the a CREATE TABLE statement has a foreign key pointing to a table that hasn't been created yet.
There are two possible ways I can think of to resolve this problem, but don't know how to implement them in the XDoclet/Torque framework. Perhaps someone could help. 1. Insert "SET FOREIGN_KEY_CHECKS = 0;" at the beginning of and "SET FOREIGN_KEY_CHECKS = 1;" at the end of the project-schema.sql file. Is there any way to get Torque to do this when it generates that file? 2. Control the order in which XDoclet generates the table descriptions in the project-schema.xml file. As far as I know there is no way of doing this. Is there? All other solutions I can think of would be hacks. Thanks, Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
