Inserting generated queries into firebird

Any template questions or comments or suggestions

Inserting generated queries into firebird

Postby sc on Mon Mar 06, 2006 7:18 am

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?
sc
Lurker
 
Posts: 4
Joined: Thu Mar 02, 2006 11:41 am

Postby mike.griffin on Mon Mar 06, 2006 10:35 pm

Database Workbench @ http://www.upscene.com, use their trial or buy it, it's an excellent program.
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to General Template Questions/Comments

Who is online

Users browsing this forum: No registered users and 2 guests