VB.NET

syntax error in update statement

Please support our VB.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2009

Posts: 143

Reputation: babbu has a little shameless behaviour in the past

Solved Threads: 14

babbu

Offline

Junior Poster

syntax error in update statement

-2

Sep 20th, 2009

this is my code

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
If Me.txtOldPassword.Text = pwd Then
                Dim oledbcom1 As New OleDb.OleDbCommand
                oledbcom1.CommandText = "Update login Set password = ?"
 
                oledbcom1.Connection = oledbcon
 
                oledbcom1.Parameters.Add("?", OleDb.OleDbType.VarChar)
                oledbcom1.Parameters(0).Value = Me.txtNewPassword.Text.Trim
 
                oledbcom1.ExecuteNonQuery()
 
                oledbcon.Close()
end if
If Me.txtOldPassword.Text = pwd Then
                Dim oledbcom1 As New OleDb.OleDbCommand
                oledbcom1.CommandText = "Update login Set password = ?"

                oledbcom1.Connection = oledbcon

                oledbcom1.Parameters.Add("?", OleDb.OleDbType.VarChar)
                oledbcom1.Parameters(0).Value = Me.txtNewPassword.Text.Trim

                oledbcom1.ExecuteNonQuery()

                oledbcon.Close()
end if

•

Join Date: Feb 2009

Posts: 3,428

Reputation: sknake has much to be proud of

Solved Threads: 619

sknake

Online

.NET Enthusiast

Re: syntax error in update statement

Sep 20th, 2009

It might help if you posted the exact error message and indicated what database you were using

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Sep 2009

Posts: 321

Reputation: TomW is on a distinguished road

Solved Threads: 45

TomW

Offline

Posting Whiz

Re: syntax error in update statement

-1

Sep 20th, 2009

Sknake is right, you need to provide the error message for anyone to provide detailed help other then guessing at whatelse might be going on in your code. For instance, I do not see where you are opening the database connection although you may be doing that elsewhere in the program.

Also is this a single user program, meaning there can be only one person with an account and login? I dont see a where clause in your update query string meaning if there is more then one account, it will update every record in that table.

•

Join Date: Sep 2009

Posts: 25

Reputation: CodeDoctor is an unknown quantity at this point

Solved Threads: 6

CodeDoctor CodeDoctor is offline

Offline

Light Poster

Re: syntax error in update statement

Sep 22nd, 2009

•

Originally Posted by babbu

this is my code
Help with Code Tags

VB.NET Syntax (Toggle Plain Text)
If Me.txtOldPassword.Text = pwd Then
                Dim oledbcom1 As New OleDb.OleDbCommand
                oledbcom1.CommandText = "Update login Set password = ?"
 
                oledbcom1.Connection = oledbcon
 
                oledbcom1.Parameters.Add("?", OleDb.OleDbType.VarChar)
                oledbcom1.Parameters(0).Value = Me.txtNewPassword.Text.Trim
 
                oledbcom1.ExecuteNonQuery()
 
                oledbcon.Close()
end if
If Me.txtOldPassword.Text = pwd Then Dim oledbcom1 As New OleDb.OleDbCommand oledbcom1.CommandText = "Update login Set password = ?" oledbcom1.Connection = oledbcon oledbcom1.Parameters.Add("?", OleDb.OleDbType.VarChar) oledbcom1.Parameters(0).Value = Me.txtNewPassword.Text.Trim oledbcom1.ExecuteNonQuery() oledbcon.Close() end if

I am going to suggest you name the params.

Ex:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
                oledbcom1.CommandText = "Update login Set password = @Password"
 
                oledbcom1.Parameters.Add("@Password", OleDb.OleDbType.VarChar).Value = Me.txtNewPassword.Text.Trim
                oledbcom1.CommandText = "Update login Set password = @Password"

                oledbcom1.Parameters.Add("@Password", OleDb.OleDbType.VarChar).Value = Me.txtNewPassword.Text.Trim

Hope this Helps...

•

Join Date: Jun 2009

Posts: 143

Reputation: babbu has a little shameless behaviour in the past

Solved Threads: 14

babbu

Offline

Junior Poster

Re: syntax error in update statement

-1

Sep 24th, 2009

the error that i get is
"syntax error in update statement"
with the title..."oledb exception was unhandled"
i am using access 2007 and visual studio 2005
sorry for late reply...

•

Join Date: Oct 2008

Posts: 2,721

Reputation: adatapost has much to be proud of

Solved Threads: 501

adatapost

Offline

Posting Maven

Re: syntax error in update statement

Sep 24th, 2009

Field name password is a access's reserved word.
Use,

Help with Code Tags

VB.NET Syntax (Toggle Plain Text)

 str="update login set [password]=?"

Last edited by adatapost; Sep 24th, 2009 at 3:09 am.

•

Join Date: Sep 2009

Posts: 321

Reputation: TomW is on a distinguished road

Solved Threads: 45

TomW

Offline

Posting Whiz

Re: syntax error in update statement

-1

Sep 24th, 2009

I could not get it to work using the '?' as the parameter name. I had to give it an actual name; like CodeDoctor suggested above.

To comment about the above post, "Password" is not a reserved keyword in ms access.

•

Join Date: Jun 2009

Posts: 143

Reputation: babbu has a little shameless behaviour in the past

Solved Threads: 14

babbu

Offline

Junior Poster

Re: syntax error in update statement

Sep 24th, 2009

•

Originally Posted by adatapost

Field name password is a access's reserved word.
Use,
Help with Code Tags

VB.NET Syntax (Toggle Plain Text)
 str="update login set [password]=?"
str="update login set [password]=?"

thnx a ton tht worked fine.....

•

Join Date: Feb 2009

Posts: 3,428

Reputation: sknake has much to be proud of

Solved Threads: 619

sknake

Online

.NET Enthusiast

Re: syntax error in update statement

Sep 24th, 2009

Please mark this thread as solved (since adatapost answered your question

) and good luck!

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Oct 2008

Posts: 2,721

Reputation: adatapost has much to be proud of

Solved Threads: 501

adatapost

Offline

Posting Maven

Re: syntax error in update statement

#10

Oct 2nd, 2009

Welcome TomW,

Read this - SQL Reserved Words

•

SUMMARY:
The following list includes all words reserved by the Microsoft Jet database engine for use in SQL statements . The words in the list that are not in all uppercase letters are also reserved by other applications. Consequently, the individual Help topics for these words provide general descriptions that do not focus on SQL usage.

http://sqlserver2000.databases.aspfa...-keywords.html