Subject Re: [ib-support] Re: Re2: IB upgrade/switch to FB
Author Artur Anjos
KK,

> > > Is FB enough stable ?
> > Are you suggesting that we are using a non-stable database in our
> products?
> > :-)
>
> I do not. But I can get informations from FB, before I take a big step
> to switch.

Yes, I understood that. I was just telling you that lots of people is using
Firebird on commercial products.

> I do that too, when I must updagrade from IB5.5 to IB 6.0.
That's the way to go.

> Many steps, because many databases created in IB6.0, and IB/FB is
> exclusive programs. If I want to develop the older applications:
> a./ Must duplicate gds32.dll-s, make a switching tool
> b./ Upgrade all of the applications.

You "must" upgrade them. You should always use the client version that was
made for the respective server version. Mixing it can bring you errors
difficult to debug.

> > > (I want to re-switch to IB, when the FB crashed, or I found a big
> bug.)
> > Is this a joke? :-)
> This is the b. option.
Yes. My sentence was just to tell you that I don't know about anyone that
went back to IB from Firebird. Just a small joke to make you feel more
confident. :-)

> > The only problem that you could have is related with Ambigous Querys
> (IB
> > allows them, Fb will give you an error message).
> Please say to me: what is ambiguous query ?
> I read about it, but I'm not sure.

Ambigous queries are queries that use field names that could bellong to
different tables, but you don't implicit define the field you need. An
example:

SELECT A,B FROM TABLE_A TA
JOIN TABLE_B TB ON TA.A=TB.B

If TABLE_A have also a field named 'B', this query is ambigous. Wich Field
should the query return? TABLE_A.B or TABLE_B.B ? IB choose this for you,
Firebird will give you an error.

Artur