devxlogo

Delphi SQL Parameters

Delphi SQL Parameters

Question:
Is it possible to use a parameter on the left side of an equality in a WHERE clause? For example:

SELECT * FROM TblName WHERE:parm1 = :parm2

When I do this, the results I get suggest that every record passes the equality test, which shouldn’t be the case. Thank you.

Answer:
This problem is one of the reasons I try to stay away from dynamic SQL, and instead construct the query strings myself using the TQuery.SQL.Add statement. I found that I have much more control over my query statements that way.

devx-admin

Share the Post: