Paul,

> Following on from previous discussion about needing to
> tighten up SQL syntax
> for this release I was wondering if it would be possible to
> improve the
> error reporting on this.
>
> My latest problem is an access violation when preparing the
> following SQL in a TIB_Query (code or designer)
>
> SELECT d.ICC_NO,d.invoice_number,d.customer_ac_no,
> d.company,d.order_number
> FROM ICC_HEADER D,CUSTOMER C,vatcodes v
> WHERE d.vat_class=v.vat_code
> AND D.company=c.co
> AND D.CUSTOMER_AC_NO = C.ACCOUNT_NO
> AND d.company='A'
> AND d.invoice_number<=16000
> AND d.invoice_number>=16000
> AND bin_and(STATUS,3670016) in (0,2621440)
> ORDER BY d.icc_no ASC
>
> The problem is fixed by putting the d. alias in front of
> STATUS. Even a
> catch-all like 'Incorrect Syntax' would do?

Please send me a simple sample app with a DDL script to make the database.
Test it once to make sure the error is still there.

With this I should be able to quickly find out what is going on and fix it.

Jason Wharton