At 01:12 AM 12/05/2003 +0000, mmatthias0 wrote:

>Hi,
>
>I tryed the sql statement without "? = 'T'" through IBExpert and it
>worked without problems.
>
>Isn't Jaybird generating this SQL? If yes, why is it generating a
>wrong statement? What am I doing wrong?
>
>Thanks,
>Marcelo
>
>--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
><rrokytskyy@a...> wrote:
> > Helen,
> >
> > > >select null as TABLE_CAT, null as TABLE_SCHEM,
> > >
> > > This is the "feature not supported". You can't have an untyped
>column
> > > in an output set.
> >
> > When this behavior was changed? Note, following statement works
> > perfectly with Firebird 1.0.2 (build 908):
> >
> > select null as bla from rdb$database

Confirmed, it does.

> >
> > Personally I suspect another part: "... WHERE ? = 'T' ...", but this
> > should be confirmed.

Agreed. The statement prepares just fine. Of course, the problem comes
when applying values to these three parameters. The only way that the
query could possibly return any rows would be if every one were passed as
'T', i.e. the SQL parses to 'WHERE 'T' = 'T'

Could you provide an example of what you are trying to pass as the six
parameter constants?

cheers
Helen

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