> 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
>

Ok you've got me Helen - apart from new datatypes (Int64 and Date) and
delimited identifiers. What are these other differences?
I don't mean the difference between SQL89 and SQL92 - that's not what
dialect means here.
I'd love to know what you are referring to
Alan