Hello Kjell,

> Thank you for jumping in Martin! I thought you would. :-)

;-)

> > > 1. Cant cancel a long-running query without opening a separate

instance

> > > of FlameRobin and deleting the statement from the new monitoring

tables.

> >
> > If the Firebird developers make this available via the API, like

InterBase

> > did, it would be much easier than running a query on the monitoring

tables.

>
> The client tool can expose this as a GUI command and handle the
> delete.... from monitor... behind the scenes. No need for FB to expose
> anything in its api for that.

Yes, one would think that ;-) Nevertheless, the way InterBase does it is
really
much much easier. I've created a report for it, most probably you can expect
this in the next version ( http://tracker.upscene.com/view.php?id=1547 )

> > > 3. No support for multiple result grids (need to open separate query
> > > windows for each query).
> >
> > None of the Firebird tools have that.
>
> :-( I need this a lot, because I need to view one or a few records from
> each of five-or-so tables to make decisions about update/delete/other on
> some specific records. UNION is not an option because the column sets
> are too different, and multiple query windows just isn't useful for this
> (too much work to get the data). MS Query Analyser does this very
> nicely, but I want to move off MSSQL.

The difference between MS SQL and Firebird is, that it allows for "batches"
and the ADO driver returns multiple (client-side) resultsets. Firebird
doesn't
do batches and only returns a single resultset per query.

For this to work, I would think of something like:

SQL Editor with multiple queries, execute each one manually and use a
special
execute functionality saying "Execute as new resultset" or something and
then
it would add a grid and display it. Feel free to request this in our tracker
(see
above for the URL).

Database Workbench does have "Pages" in each SQL Editor, but they don't
store resultsets, only query text in the upper part of the editor.

> > Hopefully, with Delphi 2009, this can be solved in a next major release
> > instead of having to jump through hoops with all sorts of 3rd party
> > components and so on.
>
> Any hints about release date? Progress? Status?

No progress yet :-/ IBO doesn't do Delphi 2009 and this might take a while,
I'm looking into FIBPlus instead and when it properly supports D2009, this
might be the time to convert everything. This will be a new major release
though
as a LOT has to be tested. Converting applications to Unicode isn't as easy
as it seems, not even with D2009.

> > > My colleague has had a quick look at Database Workbench but he wasn't
> > > very impressed. I'm interested to hear other's opinions on this tool,
> > > and also interested in comparisons between your recommended tool and
> > > FlameRobin as well as DB Workbench.
> >
> > Sorry to hear that, I do wonder what you expect then.
>
> What he said was this (my translation):
>
> The tool is often slow and has a tendency to freeze (at least on my
> computer).

I've never heard that before, if I could get details on that, it would be
nice
(you can write to me personally if you like so we don't bother others with
it on this list).

I'm not sure what he means by "freeze", is that temporarily or a complete
lockup? What OS? Has he been trying 3.2, which is more stable than 3.1?

>Very frustrating. Apart from that, it's full of features and
> neatly done. A lot more complete than FlameRobin.
>
> Feel free to comment - I haven't had time to test it myself yet, but I

will


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com