At 02:39 AM 12/05/2003 +0000, you wrote:

>Hi Helen,
>
>I'm not wrinting this statement, I believe that Jboss sent a command
>to Jaybird asking if a table exists and Jaybird generated this
>statement, based on the stack traces.

Not sure which statement you refer to. The error message you got was a
database engine message.

>What I did that make some sense, at least to me, was to take off
>the "?='T'" and replace the "and ? = RDB$RELATION_NAME" with "and
><tablename> = RDB$RELATION_NAME". It seems that works fine, it
>returns a row if this table exists with some attributes.

Stylistically, I prefer

and RDB$RELATION_NAME = value

I think that inverting it to "and value = fieldname" can lead to some very
awkward evaluations when expressions and subqueries are involved. For some
expression operations the inverted syntax doesn't actually work at all. I
used to admonish people in the support list for this but these days I
generally shut up about it. Everybody's parachute is a different colour. :-))

>[snip stack trace]

No, the stack trace doesn't help me, though it will be meaningful to you
Java guys. I'm just bogging in here on the SQL, since an engine error
indicates you tried to do something that the db engine can't do...

Helen

---------------------
See you at the First European Firebird Conference May 19-20 in Fulda,
Germany
http://www.firebird-conference.com