Click here to Skip to main content
15,892,072 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
strb.Append(" INSERT INTO  PR_JOB_APP_STATUS_DET " & _
                                   " (ID,PR_JOB_APP_STATUS_ID,PR_EMPLOYEE_MASTER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,EMAIL_ID, " & _
                                  " Mobile_No,FILE_PATH,JOB_APP_STATUS,STATUS_DATE,REMARKS) " & _
                                   " VALUES ( " & _
                                   Trim(t_Id) & "," & _
                                   (hdnJobStatID.Value) & "," & _
                                   Trim(t_EmpMasterID) & ",'" & _
                                   Trim(t_First_Name) & "','" & _
                                   Trim(t_Middle_Name) & "','" & _
                                   Trim(t_Last_Name) & "','" & _
                                   Trim(t_Email) & "','" & _
                                   Trim(t_Mobile_No) & "','" & _
                                   Trim(t_File_Path) & "','" & _
                                   Trim(RadISR.SelectedValue) & "'," & _
                                   RsmartUtl.UDSysDate() & ",'" & _
                                   Trim(txtRemarks.Text) & "'" & "); ")
                 

                    If strb.ToString <> "BEGIN" Then
                        'strb.Append(" END; ")
                        MyCmd.Transaction = MyTrans
                        MyCmd.CommandText = strb.ToString
                        MyConn = New OleDbConnection("User Id=erponnet;Password=erponnet;Data Source=RSMARTDEVDB;Provider=OraOLEDB.Oracle")
                        MyConn.Open()
                        MyCmd.Connection = MyConn
                        MyCmd.ExecuteNonQuery()
                        MyConn.Close()

                        'MyCmd = New OleDbCommand(strb.ToString(), MyConn)
                        'MyCmd.Transaction = MyTrans
                        'MyCmd.ExecuteNonQuery()
                        'MyTrans.Commit()
                    End If
Posted
Updated 12-Dec-13 22:23pm
v2

Remove the ; at the end of the SQL statement
 
Share this answer
 
v2
Comments
Member 9410081 14-Dec-13 3:07am    
Thanks. It worked.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900