adoquery1.sql.text:='SELECT A.DT, B.CC, B.AC,' + 'A.BT FROM A ' + 'INNER JOIN B ON A.ID = B.ID ' + 'AND A.CC <> '''+'0'+'''';
+ 'AND A.CC <> '''+'0'+''''; //Operator not applicable to this operand typea.cc的数据类型为:nvarchar
adoquery1.sql.text:='SELECT A.DT, B.CC, B.AC,' + 'A.BT FROM A ' + 'INNER JOIN B ON A.ID = B.ID ' + 'AND A.CC <> ''0''';
adoquery1.sql.text:='SELECT A.DT, B.CC, B.AC,' + 'A.BT FROM A ' + 'INNER JOIN B ON A.ID = B.ID ' + 'AND A.CC <> ''0''';
adoquery1.sql.text:='SELECT A.DT, B.CC, B.AC,' + 'A.BT FROM A ' + 'INNER JOIN B ON A.ID = B.ID ' + 'AND A.CC <>'+quotedstr('0');
+ 'AND A.CC <> ''0''';//Operator not applicable to this operand type + 'AND A.CC <>'+quotedstr('0');//Operator not applicable to this operand type //Statement expected, but expression of type 'String' found
+ 'A.BT FROM A '
+ 'INNER JOIN B ON A.ID = B.ID '
+ 'AND A.CC <> '''+'0'+'''';
+ 'A.BT FROM A '
+ 'INNER JOIN B ON A.ID = B.ID '
+ 'AND A.CC <> ''0''';
+ 'A.BT FROM A '
+ 'INNER JOIN B ON A.ID = B.ID '
+ 'AND A.CC <> ''0''';
+ 'A.BT FROM A '
+ 'INNER JOIN B ON A.ID = B.ID '
+ 'AND A.CC <>'+quotedstr('0');
+ 'AND A.CC <>'+quotedstr('0');//Operator not applicable to this operand type
//Statement expected, but expression of type 'String' found
+ 'A.BT FROM A,b where '
+ 'A.ID = B.ID '
+ 'AND A.CC <> ''0'' ';
adoquery1.sql.text:='SELECT A.DT, B.CC, B.AC,'+ 'A.BT FROM A '+ 'INNER JOIN B ON A.ID = B.ID '+ 'AND A.CC<>''0''';
showmessage(adoquery1.sql.text);
请将消息框中的内容贴出来看看