Subject Re: [firebird-support] Re: Select + Update in a single SPROC?
Author Martijn Tonies

>Wow - I got to say that the support in here is really awesome. Thank
>you very much (although the postet sproc is not working, too).
>Maybe I´m too much involved in using MSSQL so far. Everything is a lot
>easier, faster to develop and easier to debug. I tried the
>IBExpert-GUI, which *sorry* s_c_s and I tried Flamerobin, which
>miserably fails compared to IBExpert. The best GUI I found was "EMS
>SQL Manager for Interbase/Firebird", and it s_c_s, too: SET TERM is
>not supported correctly, debugging a sproc leads in not in useful
>error-messages, no way to develop fast and stable procedures.

Get a better debugger ;-)

Database Workbench can do both MS SQL Server and Firebird and
it has, frankly, the most precise Stored Procedure Debugger available.

You should know that Firebird does not have a server side debugger
interface, so developer tools emulate the server behaviour.

>And until now I was only trying some easy things. What will be, when I
>try to port my 300+ lines sprocs from msssql to firebird? No offense,
>but this is just not practicable for me.

You might want to restate your exact requirements, perhaps post your
MS SQL source even and restart :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!