One or more errors occurred during processing of command.ORA-00936: missing expression

[EDN Admin]

<span style="color:#0000ff; font-size:small <span style="font-size:small <span style="font-size:small


<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; color:blue; font-size:9.5pt Public<span style="font-family:Consolas; font-size:9.5pt
<span style="color:blue Sub Add()
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> GetConnection()
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue Dim ole
<span style="color:blue As <span style="color:blue String = <span style="color:#a31515
"INSERT INTO Memb VALUES( MemberID,@FirstName,@LastName,@Gender,@DOB,@UserAccountID)"
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue Dim cmd
<span style="color:blue As <span style="color:blue New <span style="color:#2b91af
OleDbCommand(ole, conn)
<p style="line-height:normal; margin-bottom:0pt
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@MemberID",
<span style="color:#2b91af OleDbType.Integer).Value = _MemberID
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@FirstName",
<span style="color:#2b91af OleDbType.VarChar).Value = _FirstName
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@LastName",
<span style="color:#2b91af OleDbType.VarChar).Value = _LastName
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@Gender",
<span style="color:#2b91af OleDbType.Integer).Value = _Gender
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@DOB",
<span style="color:#2b91af OleDbType.Date).Value = _DateofBirth
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.Parameters.Add(<span style="color:#a31515 "@UserAccountID",
<span style="color:#2b91af OleDbType.Integer).Value = _UserAccountID
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue Try
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> cmd.ExecuteNonQuery()
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> MsgBox(<span style="color:#a31515 "Added Succesfully")
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue Catch ex
<span style="color:blue As <span style="color:#2b91af Exception
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span> _msg =
<span style="color:#a31515 "Error Saving"
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue Finally
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span>
<span style="color:blue Try
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span>
conn.Close()
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span>
<span style="color:blue Catch ex <span style="color:blue As
<span style="color:#2b91af Exception
<p style="line-height:normal; margin-bottom:0pt
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span>
<span style="color:blue End <span style="color:blue Try
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span>
<span style="color:blue End <span style="color:blue Try
<p style="line-height:normal; margin-bottom:0pt <span style="font-family:Consolas; font-size:9.5pt <span> <span style="color:blue End
<span style="color:blue Sub


View the full article