Error reporting The SELECT statement includes a reserved word?

Dong Lam Trien

In C # .net when running an SQL query to get access data with an error The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect, the problem is incorrect:

SELECT COUNT (MAPB) AS Count
FROM TABNHANVIEN
WHERE (HIENAN = 'True') AND (MAPB = 3)
GROUP BY MAPB;

But I copy this query directly to the access sql query to run normally, with no error, I run another query in C # .Net running normally, no error like this message, you know what is wrong is not?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dong Lam Trien6y ago
In C#.NET cannot run COUNT (MAPB) AS Count

error this statement in C # .NET
[CODE]
SELECT COUNT (MAPB) AS Count, NAME, ADD, etc FROM TABLE
[/CODE]

but this command does not get an error in C # .NET
[CODE]
SELECT NAME, ADD, etc FROM TABLE
[/CODE]

Both of the above commands work in sql access very well
+1
Rajesh Gami6y ago
Hello Dong Lam Trien

You have to return all fields from table like below
SELECT COUNT(MAPB) AS Count, NAME, ADD, etc FROM TABLE
Try like this and let me know if any query
-1

Error reporting The SELECT statement includes a reserved word?

Hello Dong Lam Trien