procedure TFormroughexist.Button3Click(Sender: TObject);
var
str1,str2:string;
begin
with adod1 do
begin
active:=false;
commandtext:='select * from roughexist where material='+''''+trim(edit4.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)>='+''''+trim(edit5.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)<= '+''''+trim(edit6.text)+'''';
active:=true;
end;
end;请问这段代码是什么意思,请帮忙看一下,谢谢。
var
str1,str2:string;
begin
with adod1 do
begin
active:=false;
commandtext:='select * from roughexist where material='+''''+trim(edit4.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)>='+''''+trim(edit5.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)<= '+''''+trim(edit6.text)+'''';
active:=true;
end;
end;请问这段代码是什么意思,请帮忙看一下,谢谢。
procedure TFormroughexist.Button3Click(Sender: TObject);
var
str1,str2:string;
begin
with adod1 do
begin
active:=false; //设置adod1adod1为不活动状态//下面是sql语句
commandtext:='select * from roughexist where material='+''''+trim(edit4.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)>='+''''+trim(edit5.text)+''''+' and cast(RIGHT(spec, 10-CHARINDEX('+''''+'x'+''''+',lower(spec))) as float)<= '+''''+trim(edit6.text)+'''';
active:=true;//启动,执行sql
end;
end;
请问需要如何修改数据类型呀,