Hi

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?

Regards
Paul


[Non-text portions of this message have been removed]