At 10:42 AM 2/04/2008, you wrote:

>I dont see the difference between.. Amount and Ord_Head.Amount
>
>Isnt it the same thing?

It's not automatically valid in a single-table statement if you are passing it to the old version of the IBO parser. As a reality check you can put a monitor on your outgoing statements. The Fb 2 API passes a changed structure and a lot of work has been done in the IBO parser to accommodate it. If you are still using an old IBO version, it is possible to pass wrong SQL across the interface. If you are using 4.8, then the parser might pass wrong SQL if you give it wrong SQL.

Something you should bear in mind is that the forewarnings about tightened syntax have been around since Fb 1.5. In Fb 1.5 the engine would issue warnings, which are ignored by IBO. The Fb 2.0 engine issues exceptions when it receives requests with this loose syntax...

All that said, the new IBO parser tries to fix loose syntax where it can.

So if you're using Fb 2 you'll need the new IBO parsing AND you'll need to monitor your statements to verify your old SQL.

Helen