Reserved word?

[Everton1Blue]

Hello

I know that 'password' is a reserved word and needs to go in square brackets, as in [password], but where do those square brackets go in something like this, please:

 Dim Sql As String = "UPDATE university SET uniqueCode='',[b]password=@password[/b] WHERE......

........

 cmd.Parameters.AddWithValue[b]("@password"[/b], txtNewPwd.Text....

Thank you for any advice.

 

[jbenson001]

Password" is NOT a keyword in SQL:

https://msdn.microsoft.com/en-us/library/ms189822.aspx

 

[Everton1Blue]

Thanks jbenson001

I was thinking of password here, sorry:

Link

It is an Access DB that I have, so I would need to replace that SQL, wouldn't I?

I am getting an error on that line:

Dim Sql As String = "UPDATE university SET uniqueCode='',password=@password WHERE uniqueCode=@uniqueCode and (strEmail=@strEmail)", conn)

and have tried every combination of ) and " and thought the error may really lay elsewhere such as 'password'.

Thanks for the link!

 

[jbenson001]

Not too familiar with Access syntax... but I would try putting square brackets around password

[password]=@password

Are you getting an error?

 

[Everton1Blue]

Yes

Dim Sql As String = "UPDATE university SET uniqueCode='',password=@password WHERE uniqueCode=@uniqueCode and (strEmail=@strEmail)", conn)

BC30205: End of statement expected after that final bracket.

I will put password between []

Thanks

 

[Everton1Blue]

Hello jbenson001

The error goes if the ,conn) at the end is removed.

Thanks for your help.

 

[jbenson001]

Glad you figured it out!