[DUG] SQL error

[Willie Juson]

The wrong type of bracket perhaps

-----Original Message-----
From: delphi-bounces at listserver.123.net.nz
[mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of
johnkbird at paradise.net.nz
Sent: Friday, 15 February 2008 12:13 p.m.
To: delphi at delphi.org.nz
Subject: [DUG] SQL error

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

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with
Subject: unsubscribe