> At 11:41 PM 16/02/2007, George wrote:
>
> >I am concerned about the wider implications - regardless of the
> >'correctness' of syntax used in earlier versions.
> >
> >It seems each new release, instead of building on previous ones,
> >creates new problems in existing, tested and released code.
>
> Helen wrote . . .
> A major new release like v.4.7 is responding to new syntax or
> new restrictions imposed by new versions of the database
> engine. "Dirty"
> syntax that people have inadvisedly used in the past will be
> a chicken looking for a place to roost.
>
> The tightened join syntax has been presaged for a long time.
> It first showed its face during the v.1.5 beta cycle (which
> was nearly 2 years long), when bad old habits became subject
> to warnings. Now, at 2.0, they throw frank exceptions.
> That's one example; there are others.
>

I've got a bit stuck in the middle here. I had to upgrade to v4.7 because
4.6Bc was 'seriously broken'. As a result it seems I am tripping over
restrictions introduced in FB2 - it will be quite a while before I can look
at FB2 - Im still trying to get customers off IB5.6!

I know about the need to alias accurately because I'v seen many references
to it in the FirebirdSQL list.

I'm now learning the hard way about brackets in joins - what else is going
to bite me and where should I read about it?

Is 4.7 not intended to be compatible with old apps? Just in case I cant
catch up quickly enough what is the last stable version that is?

Regards
Paul