with query2 do
begin
close;
sql.clear;
sql.Add('select ywqdm,ywqmc from xxsjk.custom.JT_XT_YWQDMB');
open;
if recordcount<>0 then
begin
while not eof do
begin
ywqdm_ComboBox.Items.Add(fields[0].asstring);
ywqmc_ComboBox.Items.Add(fields[1].asstring);
next;
end;
end
else
begin
application.MessageBox('数据库中暂无业务区记录,请找静态数据管理人员联系!','警告',0);
exit;
end;
end;
begin
close;
sql.clear;
sql.Add('select ywqdm,ywqmc from xxsjk.custom.JT_XT_YWQDMB');
open;
if recordcount<>0 then
begin
while not eof do
begin
ywqdm_ComboBox.Items.Add(fields[0].asstring);
ywqmc_ComboBox.Items.Add(fields[1].asstring);
next;
end;
end
else
begin
application.MessageBox('数据库中暂无业务区记录,请找静态数据管理人员联系!','警告',0);
exit;
end;
end;
sql.add('and FieldName='+#39+S+#39);
sql.add('and FieldName='+S+'');
看来大家还是倾向于写参数的.
sql.add(' and FieldName='+floattostr(s)');
sql.add(' and FieldName='+floattostr(s));
sql.add('and FieldName='''+S+'''');
或者
sql.add('and FieldName='#39+S+#39);
sql.add('and FieldName='''+FloatToStr(s)+'''');
或者
sql.add('and FieldName='#39+FloatToStr(s)+#39);
http://www.csdn.net/expert/topic/597/597651.xml?temp=.2367365