就是怎样把下面的两段合成一段: with ADOQuery1 do begin Close; SQL.Clear; SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+''''); Open; first; end; with ADOQuery1 do begin Close; SQL.Clear; SQL.Add('select PARTNO from MPART where PARTNO='''+B.Text+''''); Open; first; end;
(1)你定义一个全局变量 i_flag:integer; 然后button1的事件里先执行 i_flag = 1 再执行你的函数,button2则 i_flag = 2(2) ... SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+''' or PARTNO='''+B.Text+''''); ...或者 ... SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+''''); SQL.ADD(' union '); SQL.Add('select PARTNO from MPART where PARTNO='''+B.Text+'''');
或者你用句柄来判断啊
怎样判断一个字段里是否有A和B.
这个SQL语句怎样写
第二个问题没读明白.
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+'''');
Open;
first;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select PARTNO from MPART where PARTNO='''+B.Text+'''');
Open;
first;
end;
然后button1的事件里先执行 i_flag = 1
再执行你的函数,button2则 i_flag = 2(2)
...
SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+''' or PARTNO='''+B.Text+'''');
...或者
...
SQL.Add('select PARTNO from MPART where PARTNO='''+A.Text+'''');
SQL.ADD(' union ');
SQL.Add('select PARTNO from MPART where PARTNO='''+B.Text+'''');
大体是这么个思路,具体问题具体分析
我想要知道在一个字段里有没有要查找的两条纪录(是两条同时存在),如果就返回true,否则为false