SELECT * FROM tablename where datafilename1 like ''%'+edit1.text+'%'' and datafilename2 like ''%'+combobox1.text+'%''
Edit和ComboBox中是可以自己填入和选择的变量,和楼上的写法有点类似,谁能给出正解呢
还有那个datafilename就是个变量,要自己输入的
var str: string; begin tbname:=edit1.Text; query1.SQL.Add('select * from '); query1.SQL.Add(edit1.Text); query1.SQL.Add('where aab001 = :str'); query1.ParamByName('str').Value:='10000001'; query1.Prepare; query1.Open; end;
不知道是不是这个意思:select * from 表名 where '+Edit1.Text+' like ''%'+ComboBox1.Text+'%''' Edit1.Text:字段名 ComboBox1.Text:该字段对应的值
Edit1.Text:该字段对应的值 ComboBox1.Text:字段名
ComboBox1.Text//查询字段 Edit1.Text//查询内容 我写的是sql.add('select * from tablename where '+Trim(ComboBox1.Text)+'='+''''+Edit1.Text+'''') 哪里有问题啊?错误提示列名无效
ADOQuery1.Close; ADOQuery1.SQL.Clear; case ComboBox1.ItemIndex of 0:ADOQuery1.SQL.Add('select * from #temp_c where zdrq='''+trim(edit1.Text)+''''); 1:ADOQuery1.SQL.Add('select * from #temp_c where zddh='''+trim(edit1.Text)+''''); else end; ADOQuery1.Open;
datafilename2 like ''%'+combobox1.text+'%''
str: string;
begin
tbname:=edit1.Text;
query1.SQL.Add('select * from ');
query1.SQL.Add(edit1.Text);
query1.SQL.Add('where aab001 = :str');
query1.ParamByName('str').Value:='10000001';
query1.Prepare;
query1.Open;
end;
Edit1.Text:字段名
ComboBox1.Text:该字段对应的值
ComboBox1.Text:字段名
Edit1.Text//查询内容
我写的是sql.add('select * from tablename
where '+Trim(ComboBox1.Text)+'='+''''+Edit1.Text+'''')
哪里有问题啊?错误提示列名无效
ADOQuery1.SQL.Clear;
case ComboBox1.ItemIndex of
0:ADOQuery1.SQL.Add('select * from #temp_c where zdrq='''+trim(edit1.Text)+'''');
1:ADOQuery1.SQL.Add('select * from #temp_c where zddh='''+trim(edit1.Text)+''''); else end;
ADOQuery1.Open;