SQLString :=
'SELECT * FROM XXX_XX_XXXX_STATUS_CHANGE_HIST '+
'WHERE RESISTNAME LIKE '''+ComboBox1.Text+'''||''%'' '+
'AND BATCHNO LIKE '''+ComboBox4.Text+'''||''%'' '+
'AND BOTTLENO LIKE '''+ComboBox2.Text+'''||''%'' '+
'AND EQPID LIKE '''+ComboBox3.Text+'''||''%'' '+
'AND STATUS LIKE '''+ComboBox5.Text+'''||''%'' '+
'AND MODIFYTIME > '''+(FormatDateTime('yyyy-mm-dd',DateTimePicker1.date))+''' '+
'AND MODIFYTIME < '''+(FormatDateTime('yyyy-mm-dd',DateTimePicker2.date+1))+''' '+
'ORDER BY MODIFYTIME DESC';
在SQL的模糊查询符%的两边,用的两个单引号,为什么是两个不是一个呢。新手求解