[DUG] SQL error

[David Moorhouse]

Are you sure you want to use the braces "{" ?

Cheers

D

On Fri, 15 Feb 2008 12:12:48 +1300 (NZDT), you 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