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

> > 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
>
>I use both and I've never struck a situation where an SQL command works in
>one and not the other - maybe I'm boring
>Alan

Yep, the wonders of dialect 3 are wasted on people like you, :-)
/heLen