我想把两句模糊查询的语句放在一起 两个语句都满足时显示数据.
语句1:SQL.Add('select * from sell where name like '+ '''' + '%' +trim(edit1.text) + '%'+'''');
语句2: SQL.Add('select * from sell where date like '+ '''' + '%' + Trim(time_time) + '%' +'''');
我用and 总查询不到报错,我是这样写的
例:
SQL.Add('select * from sell where name like '+ '''' + '%' +trim(edit1.text) + '%'+'''' and 'date like '+ '''' + '%' + Trim(time_time) + '%' +'''');
请指点下,语句1,2单独可查询.Delphi行业数据
语句1:SQL.Add('select * from sell where name like '+ '''' + '%' +trim(edit1.text) + '%'+'''');
语句2: SQL.Add('select * from sell where date like '+ '''' + '%' + Trim(time_time) + '%' +'''');
我用and 总查询不到报错,我是这样写的
例:
SQL.Add('select * from sell where name like '+ '''' + '%' +trim(edit1.text) + '%'+'''' and 'date like '+ '''' + '%' + Trim(time_time) + '%' +'''');
请指点下,语句1,2单独可查询.Delphi行业数据
SQL.Clear;
SQL.Add(Format('select * from sell where (name like %s) and (date like %s)',
[QuotedStr('%' +trim(edit1.text)+'%'),QuotedStr('%'+ Trim(time_time)+'%')]));
Open;