<div>
<div class="content wysiwyg-content">
Whats wrong with this?<br />
<br />
OleDbCommand cmd = mycon.CreateCommand();<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sMatchID = &quot;test&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sTime = &quot;0001&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sEvent = &quot;TB&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sPlayerNo = &quot;11&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sPlayerName = &quot;Harry&quot;;<br />
&nbsp;cmd.CommandText = &quot;insert into MatchStats values(&quot; + sMatchID + &quot;,'&quot; + sTime + &quot;,'&quot; + sEvent + &quot;,'&quot; + sPlayerNo + &quot;,'&quot; + sPlayerName + &quot;');&quot;;<br />
<br />
I have an access database with a table called MatchStats with the above columns.<br />
<br />
WHen the debugger comes to this line:<br />
int temp = cmd.ExecuteNonQuery();<br />
&nbsp;I get an exception saying:<br />
OleDBException was unhandled <br />
Syntax error (missing operator) in query expression '0001',TB'.<br />
<br />
Whats wrong?<br />

</div>
</div>


Whats wrong with this?

OleDbCommand cmd = mycon.CreateCommand();
            sMatchID = "test";
            sTime = "0001";
            sEvent = "TB";
            sPlayerNo = "11";
            sPlayerName = "Harry";
 cmd.CommandText = "insert into MatchStats values(" + sMatchID + ",'" + sTime + ",'" + sEvent + ",'" + sPlayerNo + ",'" + sPlayerName + "');";

I have an access database with a table called MatchStats with the above columns.

WHen the debugger comes to this line:
int temp = cmd.ExecuteNonQuery();
 I get an exception saying:
OleDBException was unhandled 
Syntax error (missing operator) in query expression '0001',TB'.

Whats wrong?


Problem with oleDB Command Text

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.