> You are using a client (IBConsole, could be any old version)
> that is highly likely to throw unfounded errors with Firebird.
> Older versions of IBConsole are highly likely to throw errors,
> period.

I am using the following:

IBConsole version 1.01.334
Windows NT 5.1 (Build 2600)

Is there a newer version of IBConsole? How can I obtain it? I
receive the error message not just with Firebird, but also with the
Windows INTERBASE 1.0 that came with my Delphi 6.0 and IBConsole
software.

> > > It might be fun to put an SQL Monitor over IBConsole's
> > > query and see what it's doing to your statement. It works fine
> > > in IB_SQL and ISQL.
> >
> >I really have no idea how to "put an SQL Monitor over IBConsole's
> >query". How do I do this? What is an SQL Monitor, and how do I
> >obtain one?
>
> IBConsole has one. IB_SQL has one. Such a tool monitors the SQL
> statement that the client passes across to the API. If you
> activated the monitor when you are running your statements in
> IBConsole, you would see what error the tool's parser was creating
> when it constructs the statement.

I have looked for anything related to an SQL Monitor in my
IBConsole; no success in finding it. How do I activate IBConsole's
SQL Monitor?

> > > Anyway, this is a pretty useless sort of view to make,
> > > considering that you can get exactly the same data back
> > > (and optionally push up the generator value) via the plain
> > > ol' statement.
> >
> >Useless or not, I am trying to follow along with Marco Cantu on
> >page 677 of his "Mastering Delphi 6" (Sybex, 2001).
>
> As often happens with book examples, they are given to demonstrate
> a generic point, not necessarily to provide an optimal way to work
> SQL in a specific database. This list is for Firebird and
> InterBase support...so it would be fairly surprising if people
> didn't offer comments and tips when they see something like this...

Marco Cantu is giving a "Real-World" technique for generating unique
keys for Delphi applications working with Interbase. He offers what
appears to be valid reasons for his techniques. I have his sample
Interbase database loaded onto my computer and even his code
produces the same Interbase/Firebird error message. Obviously there
is something about my particular Firebird/Interbase setup that is
causing the error. I need help determining the source of the error.
I do not need advice on whether or not Mr Cantu's techniques are
useful; I can make that determination for myself after I have found
a way to eliminate the error message that I am receiving.

Thanks,
Paul