Form1.qry2.SQL.Add('select * from Card where CardNo='''+CardNo+''' and cardstatus NOT IN (''正常'')' );试试
'select * from Card where CardNo='''+CardNo+''' and cardstatus NOT IN (''''正常'''')'你这SQL语句应该是没问题,会不会是CardNo你这个值是空值啊?所以就会造成语句在执行的时候变成 select * from Card where CardNo= and cardstatus NOT IN ('正常') 这样当然语句就有问题了。你跟踪看下这个语句是什么
select * from Card where CardNo= and cardstatus NOT IN ('正常')
这样当然语句就有问题了。你跟踪看下这个语句是什么