Hi Jonathan,

I have lots of different clients as well. You are welcome to email me
directly, as discussing development of backup/restore systems within
applications doesn't really fall within the scope of this list. Suffice to
say that I found it very useful to write an automated backup / restore unit
which I include in all my applications, which is transaparent to the user
and runs without thier knowledge or intervention.

Regards

Tim

At 08:57 AM 14/10/2003 +0200, you wrote:

>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]
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003

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