PROBLEM WITH INSERT STATMENT
Dim SQL_INSERT = ("Insert INTO PHONE (Customer,Phone_Type,Phone) " & _
"Values ('" & IFTMemberId & "','EMAIL','" & EmailUpdate & "'")
OConn.Open()
Dim cmd As OracleCommand = New OracleCommand(SQL_INSERT)
cmd.Connection = OConn
cmd.CommandType = CommandType.Text
If cmd.ExecuteNonQuery() Then
'Completed Ok
Else
Dim Ex As Exception
---------------------ERROR MESSAGE SAYS I AM MISSING A COMMA----------------------
I tesed this in TOAD and it works fine. DOn't knoww what the problem is.
Sanjeet
__________________
Sanjeet
|