with query1 do
begin
close;
sql.clear;
sql.add('select distinct gcmc from ttml.dbf where dydj="+edit1.text+"');
open;如果直接dydj="10KV"有结果,但edit1中动态给10KV却无结果!?
begin
close;
sql.clear;
sql.add('select distinct gcmc from ttml.dbf where dydj="+edit1.text+"');
open;如果直接dydj="10KV"有结果,但edit1中动态给10KV却无结果!?
sql.add('select distinct gcmc from ttml.dbf where dydj='+quotedstr(edit1.text));
query1.sql.clear
query1.sql.add('select distinct gcmc from ttml.dbf where dydj='+#39+
edit1.text+#39);
query1.open;