sql语句如下:
SELECT
COUNT(A.InfoID) AS InfoCount,
B.InfoTypeName
FROM T_Inforec A
LEFT JOIN T_InfoType B ON a.InfoTypeID=b.InfoTypeID
GROUP BY a.InfoTypeID,b.InfoTypeName语句在access里查询可以通过,没有问题,在写在AdoQuery里时报以下错误:Access violation at address 1B0418EE in module 'msjet40.dll'
Delphi6+Office2000谢谢!
SELECT
COUNT(A.InfoID) AS InfoCount,
B.InfoTypeName
FROM T_Inforec A
LEFT JOIN T_InfoType B ON a.InfoTypeID=b.InfoTypeID
GROUP BY a.InfoTypeID,b.InfoTypeName语句在access里查询可以通过,没有问题,在写在AdoQuery里时报以下错误:Access violation at address 1B0418EE in module 'msjet40.dll'
Delphi6+Office2000谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货