With Adoquery1 Do Begin Close; SQL.Clear; SQL.Add('SELECT * FROM Table1 WHERE '+ComboBox1.Text+ComboBox2.Text+:Param_Value); Parameters.ParamByName('Param_Value').Value:=Edit1.Text; Open; End; 没有试验的 就是这个思路吧!
With Adoquery1 Do Begin Close; SQL.Clear; SQL.Add('SELECT * FROM Table1 WHERE storageNo'+ComboBox1.Text+':Param_Value); ParamByName('Param_Value').AsString:=Edit1.Text; Open; End;
to:laihua(背着石头过河) 这样可以,可为什么筛选后,结果无记录啊? With Adoquery1 Do Begin Close; SQL.Clear; SQL.Add('SELECT * FROM Table1 WHERE storageNo'+ComboBox1.Text+':Param_Value'); ParamByName('Param_Value').AsString:=Edit1.Text; Open; End;
sqlstr:='select * from storage where storageNo'+COMBOBOX1.TEXT+'edit.TEXT'; SQL.ADD(SQLSTR);
Begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM Table1 WHERE '+ComboBox1.Text+ComboBox2.Text+:Param_Value);
Parameters.ParamByName('Param_Value').Value:=Edit1.Text;
Open;
End;
没有试验的 就是这个思路吧!
Begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM Table1 WHERE storageNo'+ComboBox1.Text+':Param_Value);
ParamByName('Param_Value').AsString:=Edit1.Text;
Open;
End;
这样可以,可为什么筛选后,结果无记录啊? With Adoquery1 Do
Begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM Table1 WHERE storageNo'+ComboBox1.Text+':Param_Value');
ParamByName('Param_Value').AsString:=Edit1.Text;
Open;
End;
SQL.ADD(SQLSTR);