[DUG] SQL error

johnkbird at paradise.net.nz johnkbird at paradise.net.nz
Fri Feb 15 12:12:48 NZDT 2008


The following SQL

select * from ADDRESS
where

(  (  COMPANY = :COMPANY)
and   ( ADDR1 = :ADDR1 )
and   ( ADDR2 = :ADDR2 )
and   ( SUBURB = :SUBURB )
and   ( CITY = :CITY )
and   ( STATE = :STATE )
and   ( COUNTRY = :COUNTRY )
and   { POSTCODE = :POSTCODE ) 
and   { LOCATION_ID = :LOCATION_ID )
and   ( ID  <> :ID )  )
 
order by ID

produces an error I cannot figure...
"Class EDBEngine Error with message 'General SQL error, token unknown, Line 11
char 9 POSTCODE'..."  (this line is the Postcode line)

All the fields listed are in the Address table

(Firebird 1.5 and Delphi 5 Enterprise)  BDE v5.01

Anyone have any ideas???

John



More information about the Delphi mailing list