[DUG] SQL error

[Willie Juson]

That's good enough thanks ;-)

-----Original Message-----
From: delphi-bounces at listserver.123.net.nz
[mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of Peter Ingham
Sent: Friday, 15 February 2008 1:04 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] SQL error

Could be the Curly Brace instead of a left-parenthesis??

johnkbird at paradise.net.nz wrote:
> 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
> 

_______________________________________________
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