SQL无效参数错误 [英] SQL Invalid Argument Error

问题描述

尝试保存查询时收到错误消息.

I am receiving an error when I try to save my query.

SELECT tbl_2_trip_details_2012.Arrival_ID, Count(tbl_2_trip_details_2012.Arrival_ID) AS        CountOfArrival_ID
FROM tbl_2_trip_details_2012
GROUP BY tbl_2_trip_details_2012.Arrival_ID
HAVING (((tbl_2_trip_details_2012.Arrival_ID)=84252114));

查询很好，但是当我尝试以任何名称保存时，都会出错并显示"Invalid Argument". 请帮忙！！！

The query pulls fine, but when I try to save under any name it errors out and states "Invalid Argument". Please help!!!

推荐答案

尝试如下操作:-

  SELECT tbl_2_trip_details_2012.Arrival_ID, Count(tbl_2_trip_details_2012.Arrival_ID) AS          CountOfArrival_ID
  FROM tbl_2_trip_details_2012
  where tbl_2_trip_details_2012.Arrival_ID=84252114
  GROUP BY tbl_2_trip_details_2012.Arrival_ID

这篇关于SQL无效参数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！