Problem with Syntax Error in SQL statement

Question

I am trying to get a specific single value from an Access Database using C#.

For some reason what I am asking for is giving me an exception of

Syntax error in FROM clause

and I cant work out why.

I have tried running the SQL directly in Access itself and it works fine and gives me back the results I want, but I have no idea why its not working in my program.

ProbID is a number field as far as Access describes it and CorrDetails is a memo field.

For simplicity i have set the SQL to look for a specific value (137) but once i have the code working i will make it paramiterised.

Any ideas?

string corrAct;
            OleDbConnection dbConnection;
            dbConnection = new OleDbConnection(vDbString);
            string sqlString = "SELECT CorrDetails FROM Action WHERE ProbID=137";
            OleDbCommand command = new OleDbCommand(sqlString, dbConnection);

            using (dbConnection)
            {

            MessageBox.Show(sqlString);
            dbConnection.Open();
            corrAct = (String)command.ExecuteScalar();
            rtfCorrectiveAction.Text = Convert.ToString(corrAct);
            dbConnection.Close();
            }

In the future, you could try to put your SQL query into a Query in Access itself. There you'll find about such errors easily. — Christian.K
– Christian.K, Commented Oct 30, 2019 at 10:34
Does this answer your question? How to deal with SQL column names that look like SQL keywords? — BugFinder
– BugFinder, Commented Oct 30, 2019 at 10:34
Whenever you have a question about SQL, add the relevant rdbms in the tags. — Zohar Peled
– Zohar Peled, Commented Oct 30, 2019 at 10:34

Zohar Peled · Accepted Answer · 2019-10-30 10:32:23Z

3

Action is a reserved word in MS Access. Wrap it with []:

 string sqlString = "SELECT CorrDetails FROM [Action] WHERE ProbID=137";

answered Oct 30, 2019 at 10:32

Zohar Peled

82.9k11 gold badges79 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Peter Over a year ago

This worked perfectly! Thank you, i didnt know about the Access reserved words and this is a database that i did not have any involvement in creating. Thanks for all your help.

Zohar Peled Over a year ago

Glad to help :-)

BugFinder · Accepted Answer · 2019-10-30 10:34:15Z

1

The problem is you havent taken into account keywords in SQL. https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/reserved-keywords?view=sql-server-ver15

Action is a keyword so should not be used really in another context, to use them put [] round them some it becomes

select stuff from [Action] where stuff=true

answered Oct 30, 2019 at 10:34

BugFinder

17.9k4 gold badges42 silver badges58 bronze badges

Collectives™ on Stack Overflow

Problem with Syntax Error in SQL statement

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related