Dim connString As String
connString = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString3").ToString
Using connection As New OracleConnection(connString)
Dim command As New OracleCommand
command.Connection = connection
command.CommandText = "Update REMITTANCE Set " & _
"Currency_Code = '" & CCurrencyTextBox.Text & "'," & _
"Remittance_Amount = '" & CAmmountTextBox.Text & "'," & _
"paid_cmp_main = '" & Company_CodeTextBox.Text & "'," & _
"paid_cmp_sub = '" & BranCH_CODETEXTBOX.Text & "'," & _
"Pay_Currency = '" & Receipt_CurrencyTextBox.Text & "'," & _
"transfer_PRICE = '" & Exchange_PriceTextBox.Text & "'," & _
"Agent_Commission = '" & CommissionTextBox.Text & "'," & _
"Paid_Amount = '" & Received_AmmountTextBox.Text & "'," & _
"Where Remittance_key ='" & Session("REMITTANCE_KEY") & "'"
connection.Open()
command.ExecuteNonQuery()
End Usingعند تنفيذ هذا الكود يعطي ال error التالي فما الحل
مع العلم انني اتعامل م قاعدة بيانات اوراكل
ORA-01747: invalid user.table.column, table.column, or column specification


