Subject | Re: [ib-support] Re: Re2: IB upgrade/switch to FB |
---|---|
Author | Artur Anjos |
Post date | 2003-05-30T08:26:46Z |
KK,
Firebird on commercial products.
made for the respective server version. Mixing it can bring you errors
difficult to debug.
went back to IB from Firebird. Just a small joke to make you feel more
confident. :-)
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
> > > Is FB enough stable ?Yes, I understood that. I was just telling you that lots of people is using
> > 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.
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 isYou "must" upgrade them. You should always use the client version that was
> 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.
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 bigYes. My sentence was just to tell you that I don't know about anyone that
> bug.)
> > Is this a joke? :-)
> This is the b. option.
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 QuerysAmbigous queries are queries that use field names that could bellong to
> (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.
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