Tim Ledgerwood wrote:

>>What are ambigous queries? Could you give me an example please?
>>
>>
>
>
>Hi Jonathan,
>
>Ambiguous queries : Where you don't explicitly state the join, or where the
>join is on two fields that have the same name. (Well, partially, anyway).
>IB allows you to write :
>
>Select * from Table1, Table2 where
>RecordNumber = RecordNumber
>
>In FB, you are encouraged to use the JOIN keyword, which is more standard,
>and FB will not allow ambiguous queries at all. So in the above example,
>you would write the following :
>
>Select * from Table1, Table2 where
>Table1.RecordNumber = Table2.Recordnumber
>
>or
>
>Select * from Table1
>JOIN Table2
>ON Table1.RecordNumber = Table2.RecordNumber
>
>Which is the "right" way to do it and the way that other RDBMSs that I have
>used (Sybase, Oracle, DB2) require you to do it.
>
>

Thanks a lot for the explanation. This shouldn't be much of a problem as
I avoid such queries anyway, and even in Interbase, even though there's
no error message, this leads to bugs, so...

>As far as converting goes : The company I work for has a production system
>which has been developed and maintained using IB 6.01 I have "converted" it
>to FB 1.0 and 1.5 without any problems. Although doing a backup and restore
>is obviously a wise thing to do, in my experience FB has read the DB
>without having done this. (Furthermore, developing an automated backup /
>restore and adding it to your app is pretty easy anyway)
>
>

The main reason this is a problem for me is that I have a lot of
databases from a lot of different customers, and it's a hassle to have
to backup restore them all (on my development machine), just because I
changed one of my customers to FB 1.0.

>The biggest hassle I found (I develop in Delphi 5) was that the IBX
>components with Delphi had hassles with FB - although I must admit that I
>didn't do very much playing around with this aspect of the changeover.
>Changing my components to IB Objects solved these problems, and allowed me
>to write code that was "backwards compatible" - it didn't matter if the DB
>server was IB or FB. But I warn you, I found that part of the changeover
>(changing my data access classes and methods) to be quite a lot of work.
>
>

That part doesn't worry me at all, as I'm already using FIBPlus.

>Hope this helps,
>
>Tim
>

Thanks!

Jonathan Neve.


[Non-text portions of this message have been removed]