Hello Mike,

> I use Database Workbench to work on my Firebird 1.5 database
>
> I have been working most of the morning on a new stored procedure.
>
> As I was just finishing clean up work on this new stored procedure, I
> decide to delete 2 input parameters that i no longer needed, so I select
> the first parameter and click the delete parameter button, then select the
> second parameter and click the "Drop Procedure" button by accident as the
> two buttons are within an inch of each other.

I'm sorry to hear you clicked the wrong button, but they appear in different
toolbars.

> So is there anyway to retreive this new stored procedure that I just
> dropped?

Unless you have a backup or script, no there is not.

The upcoming Database Workbench 4 has a feature called "Secure object drop"
that can help you to avoid this problem.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com