That's good enough thanks ;-)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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??
[EMAIL PROTECTED] 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: [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
_______________________________________________
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
