Chapter 10, Try it out Page 365, C#, line 7

SQL statement that is recommended to use:
SELECT PlayerID, FirstName, LastName, Position, PictureURL, DateJoined, DateLeft
FROM Players
WERE PlayerID = @PlayerID

When adding “WERE PlayerID = @PlayerID” to the SQL statement and clicking next the check box for “Create methods to send update directly to the database” is disabled “grayed out”. If you remove the “WERE PlayerID = @PlayerID” from the SQL statement the check box for “Create methods to send update directly to the database” is enabled.

If you click on the “Query Builder..” button in the “Enter SQL statement” dialog you will get this message “Unable to parse query text.”

WERE should be WHERE.

I didn't have a problem getting this example to work.

Ditto.
The error message turns up because WERE is not a SQL keyword. VWD is expecting WHERE.

Dan

I have been trying to execute the following query in table adapter in the Microsoft Visual Studio. I am accessing a Microsoft Access Database.

But I keep getting the SQL Syntax Error: Unable to Parse Query Text

SELECT COUNT(*)
FROM
(SELECT DISTINCT[P A].[Last Name]
FROM [P A]
WHERE ([P A].[Month] = @Month) AND ([P A].[Code] = @code));

I am not sure how to handle this error. Please advice

Thanks