At 05:45 PM 7/05/2004 +1000, you wrote:

> > As far as I understand it, Dialect governs the SQL you can use,
> > as well as
> > the data types - bigint, for example, is only available under
> > Dialect 3. I
> > haven't played with cache size at all.
> >
> > Regards
> >
> > Tim
>
>Dialect has nothing to do with what SQL you can use - it's all standard SQL
>no matter what dialect the db is set at.

Umm....dialect has rather a lot to do with the SQL you can use. Both
dialect 1 and dialect 3 are "standard" (more or less) but in dialect 1 you
are limited to InterBase 5's SQL language set (less, actually). Alan, if
you haven't been using d1 databases, you'll be quite astonished by what you
can't do in d1. :-> If you write apps that use language features that
only d3 has, and try to run them against a d1 database, you will get some
unpleasant surprises.

/heLen