The wrong type of bracket perhaps
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, 15 February 2008 12:13 p.m.
To: [EMAIL PROTECTED]
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: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with
Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
