with qry1 do
begin
Close;
sql.Clear;
sql.Text:='select case when '''+strTofloat(edt3.Text)+'''>10 then MuchLevel10 else 0 end as MuchLevelD from ClientPriceKT where Client='''+Edit2.Text+''' and (ContactCity like ''%''+'''+Edit3.Text+'''+''%'')';
Open;
edt1.Text:=fieldbyname('MuchLevelD').AsString;
end;
SQL语句出错,请大家帮我看看,谢谢!
begin
Close;
sql.Clear;
sql.Text:='select case when '''+strTofloat(edt3.Text)+'''>10 then MuchLevel10 else 0 end as MuchLevelD from ClientPriceKT where Client='''+Edit2.Text+''' and (ContactCity like ''%''+'''+Edit3.Text+'''+''%'')';
Open;
edt1.Text:=fieldbyname('MuchLevelD').AsString;
end;
SQL语句出错,请大家帮我看看,谢谢!
begin
Close;
sql.Clear;
sql.Text:='select case when '+edit3.Text+'>10 then MuchLevel10 else 0 end as MuchLevelD from ClientPriceKT where Client='''+Edit2.Text+''' and (ContactCity like ''%'+Edit3.Text+'%'')';
Open;
edt1.Text:=fieldbyname('MuchLevelD').AsString;
end;拿分来。全分。
语句不乱,不信你COPY到ULTRAEDIT中去看
其实就是'''+strTofloat(edt3.Text)+'''这里的原因
后面的''%''+'''+Edit3.Text+'''+''%''也是错的。
呵呵。