Inserting generated queries into firebird

[sc]

We used the standard firebird template to generate the stored procedures and views and we use the program SQL Manager 2005 for firebird to insert them into the database.

The first problem we encountered was an error on \"set autoddl off\" and \"set autoddl on\". So we removed all of those lines and we managed to compile them. The program however put all procedures at the stored prodecures and none with the views so basically we can't make any Business Views.

Could this be due to the removal of those autoddl parts? Or does anyone have another suggestion on a good program to insert the stored procedures and views into the database?

[mike.griffin]

Database Workbench @ http://www.upscene.com, use their trial or buy it, it's an excellent program.