Hello Helen,

>>> Do you happen to be presenting this syntax via an app that uses IBO?
>>Yes, I'm using IBO via Database Workbench Pro 3.3.
>>
>>> Aliasing isn't meant to be used for a multi-object query
>>Excuse my ignorance, but what is a multi-object query?
>
> Sorry,
> 1) that statement said exactly the opposite of what it was intended to
> say. Should be "Aliasing isn't meant to be used for a SINGLE object
> query."

That's not really the point, an alias is allowed in SQL, also for a single
object query.

It's IBO thats at fault here, adding the DB_KEY thing while it shouldn't.

> 2) a multi-object query is one that has joins and/or subquery expressions
> (including derived tables); also unions, if the set is unioned over
> multiple instances of the same table.
>
>
>>> IBO's parser adds RDB$DB_KEY to the output list automatically
>>So I assume I should test this using isql (which is what will run the
>>command in production anyway) instead of continuing with DBW.
>
> That doesn't seem justified unless you're determined to continue using the
> wrong syntax for a single-object query

How is this "wrong" exactly? It's valid SQL.

(or indeed, any other wrong syntaxes that older Firebird versions would
tolerate). However, ISQL *is* version specific, so Fb 1.5's isql should
permit that wrong syntax, if you got away with it before. Reverting to an
older version of DBW (preceding the upgrade to IBO 4.8) should also do the
trick.

>
>>> It [change to the API] is not supposed to matter
>>Should I file something with the tracker? If so, what would I report?
>
> IMO, there's no point, as it isn't due to a Firebird bug, and you won't be
> reporting anything that is not known and documented. OTOH, it would be
> worth drawing Martijn's attention to it (via firebird-tools or, better,
> Upscene's own newsgroups). I don't use DBW but I'd be surprised if it
> didn't have an option to pass raw SQL and also to avoid KeyLinks.
>

I have noticed it :-) ...


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com