把下面delphi的sql语句修改正确

2025-05-21 09:09:31

推荐回答（1个）

回答1：

_ssql := 'select interId from resource where ' +
'cardID='''+dxdbdtcardID.Text +''''+
' and pinName=''' +dxdbdtpinName.Text +''''+
' and rspec=''' +dxdbdtrspec.Text +''''+
' and material=''' +dxdbdtmaterial.Text +''''+
' and receiveWeight=''' +dxdbdtreceiveWeight.Text +''''+
' and receivePieces=''' +dxdbdtreceivePieces.Text+'''';
这样试试 ,或
_ssql :='select interId from resource where ' +
'cardID='+dxdbdtcardID.Text+
' and pinName=' +dxdbdtpinName.Text+
' and rspec=' +dxdbdtrspec.Text +
' and material=' +dxdbdtmaterial.Text +
' and receiveWeight=' +dxdbdtreceiveWeight.Text +'
' and receivePieces=' +dxdbdtreceivePieces.Text;