<div>
Take the the comma out <br />
<br />
SQL = &quot;UPDATE SECURITYABS SET &quot;&nbsp;_ <br />
&nbsp; &nbsp; &amp;&nbsp;&quot;PASSWORD = '&quot; &amp;&nbsp;UCase(txtNewPW.Text) &amp;&nbsp;&quot;'&quot; &amp;&nbsp;_<br />
&nbsp; &nbsp; &amp;&nbsp;&quot; WHERE USERNAME = '&quot; &amp;&nbsp;UCase(txtUserName.Text) &amp;&nbsp;&quot;'&quot; <br />
<br />

</div>


Take the the comma out

SQL = "UPDATE SECURITYABS SET " _
    & "PASSWORD = '" & UCase(txtNewPW.Text) & "'" & _
    & " WHERE USERNAME = '" & UCase(txtUserName.Text) & "'"



<div>
You may also want to look at using the replace function anytime you are inserting text into your db. &nbsp;If there is a single quote in this string it will mess everything up.<br />
<br />
pseudocode<br />
<br />
Replace(textusername.text,<wbr /> &quot;&nbsp;' &quot;&nbsp;, &quot;&nbsp;'' &quot;)<br />
<br />
Of course you would have to take the spaces out, I just put them in to try to illustrate it more clearly.<br />
<br />

</div>


You may also want to look at using the replace function anytime you are inserting text into your db.  If there is a single quote in this string it will mess everything up.

pseudocode

Replace(textusername.text, " ' " , " '' ")

Of course you would have to take the spaces out, I just put them in to try to illustrate it more clearly.



<div>
<div class="content wysiwyg-content">
I'm trying to update a table using the following code and keep getting an error 3144 syntax error in the update statement. &nbsp;If I take the where clause out it updates all the passwords in the table.<br />
<br />
<br />
&nbsp;<br />
SQL = &quot;UPDATE SECURITYABS SET &quot;&nbsp;_<br />
&nbsp; &nbsp; &amp;&nbsp;&quot;PASSWORD = '&quot; &amp;&nbsp;UCase(txtNewPW.Text) &amp;&nbsp;&quot;', &quot;&nbsp;_<br />
&nbsp; &nbsp; &amp;&nbsp;&quot;WHERE USERNAME = '&quot; &amp;&nbsp;UCase(txtUserName.Text) &amp;&nbsp;&quot;'&quot;<br />
<br />
Any help would be appreciated.<br />
<br />
Thanks.<br />
<br />
<br />
<br />
<br />

</div>
</div>


I'm trying to update a table using the following code and keep getting an error 3144 syntax error in the update statement.  If I take the where clause out it updates all the passwords in the table.


 
SQL = "UPDATE SECURITYABS SET " _
    & "PASSWORD = '" & UCase(txtNewPW.Text) & "', " _
    & "WHERE USERNAME = '" & UCase(txtUserName.Text) & "'"

Any help would be appreciated.

Thanks.






Updating a table using SQL

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.