perhaps its the 2 {{ curly brackets instead of ( round ones on postcode and location ;)<br><br><div class="gmail_quote">On Fri, Feb 15, 2008 at 12:12 PM, <<a href="mailto:johnkbird@paradise.net.nz">johnkbird@paradise.net.nz</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The following SQL<br>
<br>
select * from ADDRESS<br>
where<br>
<br>
( ( COMPANY = :COMPANY)<br>
and ( ADDR1 = :ADDR1 )<br>
and ( ADDR2 = :ADDR2 )<br>
and ( SUBURB = :SUBURB )<br>
and ( CITY = :CITY )<br>
and ( STATE = :STATE )<br>
and ( COUNTRY = :COUNTRY )<br>
and { POSTCODE = :POSTCODE )<br>
and { LOCATION_ID = :LOCATION_ID )<br>
and ( ID <> :ID ) )<br>
<br>
order by ID<br>
<br>
produces an error I cannot figure...<br>
"Class EDBEngine Error with message 'General SQL error, token unknown, Line 11<br>
char 9 POSTCODE'..." (this line is the Postcode line)<br>
<br>
All the fields listed are in the Address table<br>
<br>
(Firebird 1.5 and Delphi 5 Enterprise) BDE v5.01<br>
<br>
Anyone have any ideas???<br>
<br>
John<br>
<br>
_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@listserver.123.net.nz">delphi@listserver.123.net.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@listserver.123.net.nz">delphi-request@listserver.123.net.nz</a> with Subject: unsubscribe<br>
</blockquote></div><br><br clear="all"><br>-- <br>Kyley Harris<br>Harris Software<br>+64-21-671-821