devxlogo

Data Access

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

Using variable in SQL WHERE clause

Question: How can I use the contents of a text box as the WHERE clause in a SQL query? “SELECT * FROM Table WHERE Field = Text1.Text” doesn’t work. Answer: