Hi Helen

> >Version 4.6Bc
> >
> >Odd thing has occured
> >
> >Have a TIB_Query with nothing set or connected except the
> IB_Connection
> >and this SQL
> >
> >select h.invoice_number,h.customer_ac_no,h.status,
> >l.quantity_delivered,l.catalogue_code,l.description
> >from ((icc_header h join iccline l on h.icc_no=l.icc_no)join
> product p
> >on p.product_number=l.product_id)join
> >customer c on h.customer_ac_no=c.account_no and
> c.co=h.company order
> >by h.Invoice_number
> >
> >In the Designer prepare gives the error 'field
> >ICCLINE.QUANTITY_DELIVERED not found'


> well, those brackets don't belong in that syntax, that's for
> sure. I think the dsql parser on the server side will just
> ignore them but they'll sure be a challenge to the IBO parser.

That's a surprise I've been using brackets in explicit joins for years!
Also never had a problem with 4.3 which I was using since 2003. I'll
accept your statement that it's not correct syntax and try and find and
remove them all. I don't recal any messages about it - was the syntax
declared illegal in IBO?

>
> The parser in IBO 4.6Bc is seriously broken anyway,
> particularly for joins. You really shouldn't be trying to do
> anything serious with that version.
>

That's very worrying... In upgrading from 4.3Aa recently I plotted the
dates of all the releases, looking for a recent one which had been around
for the longest time. 4.6Bc has been around for the last 7 months!

I will update now to 4.7 and hope for the best ;-)

Regards
Paul