[DUG] SQL error

[Robert martin]

Umm...

One the line with POSTCODE and LOCATION your starting ( is actually {.


Rob Martin
Software Engineer

phone +64 03 377 0495
fax   +64 03 377 0496
web www.chreos.com

Wild Software Ltd



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
>
>