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.