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

2025-04-04 11:15:47
推荐回答(2个)
回答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

回答2:

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