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?

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

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

Answers

Error reporting The SELECT statement includes a reserved word?

Dong Lam Trien

1.6k

1 Learn iOS Programming

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?

Error reporting The SELECT statement includes a reserved word?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)