Question

怎么执行拼接的sql语句，并把查询结果赋值给变量

Answer 1

var
sql1，str：string；
count：float
begin
adoquery1.close;
adoquery1.sql.text := 'select count(*) from a';
adoquery1.open;
count := adoquery1.fields[0].asinteger; ///////这里
end;
c

Answer 2

let select_sql = select_sql||" from table_name"
execute immediate select_sql;