Delphi SQL Parameters

Delphi SQL Parameters

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.

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.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist