'select * from basicdata where cncarnum='''+'粤Z.'+trim(edit4.text)+'港'+'''';
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='''+'粤Z.'+trim(edit4.text)+'港'+''''你少了4处引号
用QuotedStr()方便点,多加点很容易晕啊
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='''+'粤Z.'+trim(edit4.text)+'港'+''''或ADOQuery1.SQL.Text:='select * from basicdata where cncarnum=QuotedStr('粤Z.'+trim(edit4.text)+'港')' 你再试试看。
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+QuotedStr('粤Z.'+trim(edit4.text)+'港')
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='''+'粤Z.'+trim(edit4.text)+'港'+'''' 暈倒~~不麻煩嘛
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+#39+'粤Z.'+trim(edit4.text)+'港'+#39;
你再试试看。
暈倒~~不麻煩嘛