| Subject | RE: [IBO] Firebird 2.0 and . notation |
|---|---|
| Author | Jason Wharton |
| Post date | 2006-01-07T19:00:26Z |
Yes, I am aware of this and it is proving to be a rather difficult issue to
resolve. I am working on this still. I am going to have to do some parsing
to the SQL that is sent to the server to substitute the alias for the full
table name. I'd like people's code to work as it is. I really wish the
people doing Firebird 2.0 didn't put such a hard edge on some of their
changes. Is all I can say is I hope there are sufficiently compelling
reasons to move to it over 1.5 that people are willing to pay the price to
make the move. I'm going to do my best to make it as painless as possible
for IBO users but I don't think I'll be able to alleviate all the pain.
The hardest part here is I'm going to have to have special behaviors that
depend upon what server you are connected to. I'd rather not have to do
that...
Jason
resolve. I am working on this still. I am going to have to do some parsing
to the SQL that is sent to the server to substitute the alias for the full
table name. I'd like people's code to work as it is. I really wish the
people doing Firebird 2.0 didn't put such a hard edge on some of their
changes. Is all I can say is I hope there are sufficiently compelling
reasons to move to it over 1.5 that people are willing to pay the price to
make the move. I'm going to do my best to make it as painless as possible
for IBO users but I don't think I'll be able to alleviate all the pain.
The hardest part here is I'm going to have to have special behaviors that
depend upon what server you are connected to. I'd rather not have to do
that...
Jason
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Thomas Steinmaurer
> Sent: Friday, January 06, 2006 5:53 AM
> To: IBObjects
> Subject: [IBO] Firebird 2.0 and <table>.<field> notation
>
>
> Hello Jason,
>
> fixing IB_Schema.pas regarding table name/alias usage is only half of
> the story for Firebird 2.0 support. I've encountered another issue,
> namely full qualified table names in properties like MasterLinks, ...
>
> Have a look in IBF_Browse.pas, for instance the query
> "qrConstraintInf".
>
> This query has the following MasterLinks property:
>
> RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME=RDB$RELATIONS.RDB$R
> ELATION_NAME
>
> Opening the query (double-click a TIB_Connection component and select
> Browse Database) will fail. The following MasterLinks entry will fix
> that problem:
>
> RC.RDB$RELATION_NAME=RDB$RELATIONS.RDB$RELATION_NAME
>
>
> With Firebird 2.0, one needs to be extremely careful using
> full qualifed
> table/field pair values, when there is a table alias used in the SQL
> statement.
>
>
> --
> HTH,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com