SQL.Add('select factorycode,batchno,model,outquality from outplate'#20);
SQL.Add('where factorycode = '+ str +' and batchno Like ' + ''''+ '%' + form_incoming.Edit_batchno.Text + '' + '%'+ ''' order by factorycode' );
为什么我的代码只能执行相当于
SQL.Add('where factorycode = '+ str +' order by factorycode' );的功能,而 "and"后面的模糊查询语句好象没执行到似的,怎么回事啊
SQL.Add('where factorycode = '+ str +' and batchno Like ' + ''''+ '%' + form_incoming.Edit_batchno.Text + '' + '%'+ ''' order by factorycode' );
为什么我的代码只能执行相当于
SQL.Add('where factorycode = '+ str +' order by factorycode' );的功能,而 "and"后面的模糊查询语句好象没执行到似的,怎么回事啊
试试,
最后到DELPHI里试,我总是这样。