Re: [Firebird-devel] Firebird vs Interbase

[<Ste...@ho...>]

Ded,

I was referring to this issue mentioned in the FAQ for RC2...

I have a query which used to work fine. Now I get this error:
SQL error code = -204
Ambiguous field name between table/view TOKEN and table/view

Firebird RC1 rejects queries that reference column names that are duplicated
across table joins. The old behaviour could (and often would) generate a
different result if the table order was inverted.

To simplify migration RC2 now allows ambiguous field names in queries if the
database client is using Dialect 1.

Status - Enhanced in RC2
-Steve

"Ded" <de...@hq...> wrote in message
news:3C3...@hq......
> Ste...@ho... wrote:
> > I have been testing applications using Delphi 5/IBX and Firebird RC2 and
> > have found only 2 minor issues.  They are:
> >
> > 1.  The IBBackupService property for IngoreLimbo must be set to false.
> > 2.  The SQL error code -204 which can be corrected by proper coding.
> >
> > Are there any other known issues that we should be aware of?
> >
>
>   Steve, what do you mean by point 2? I have 3 applications based on IBX
> 4.42 with total amount of units about 2000 and all 3 were tested with
> many versions of Firebird and works now in real life on a rather large
> and complex database over RC2. Since January 2001 this database was
> served by FB 0-9.4p1. Just now I can't see any problems with general IBX
> components (I don't use IBAdmin palette because I always work on classic
> IB/FB). More, over FB RC2 I recommend to bring TIBSQL.ExecQuery part
> which implement TIBStoredProc.ExecProc to normal state
>
>     SQLExecProcedure: begin
>       fetch_res := Call(isc_dsql_execute2(StatusVector,
>                             TRHandle,
>                             @FHandle,
>                             Database.SQLDialect,
>                             FSQLParams.AsXSQLDA,
>                             FSQLRecord.AsXSQLDA), True);
>      end;                                      // ^^^^
>
>    Originally presented there repeated call in case of the error (which
> always made more harm than benefit) is absolutly unneeded for Firebird
> now, thanks Ann. Just to be shure you use proper Firebird gds32.dll, not
> IB 6 or old FB one.
>    So, I think most of existing now IBX applications are fully
> compatible with Firebird, maybe some problems with IBAdmin palette (just
> don't know) and with IB6.5 features like XML support.
>
> Best regards, Alexander V.Nevsky.
>
> _______________________________________________
> Firebird-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>