Question:
How can I put a variable in a SQL string? For example:
input:=edit1.text;query1.sql.add('select * from address where name like <%variable input%>');
Answer:
Since SQL.Add takes a string, all you need to do is simple string concatenation:
var qryVar : String;begin ... SQL.Add('select * from address ' + ' where name like ''' + qryVar + '''');
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
