dBase field called "Value" cannot be edited
-
I can't update the content of the field called "VALUE". Is there any work around to get "1" into that field? Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\;Extended Properties=dBASE IV;") Dim adapter As New OleDb.OleDbDataAdapter("SELECT * FROM Test.dbf", conn) Dim recordsAffected As Integer = 0 conn.Open() Dim sql As String = "UPDATE Test.dbf SET Value = '1' WHERE Keyword = 'Over_here'" Dim da As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn) recordsAffected = da.ExecuteNonQuery() conn.Close()
-
I can't update the content of the field called "VALUE". Is there any work around to get "1" into that field? Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\;Extended Properties=dBASE IV;") Dim adapter As New OleDb.OleDbDataAdapter("SELECT * FROM Test.dbf", conn) Dim recordsAffected As Integer = 0 conn.Open() Dim sql As String = "UPDATE Test.dbf SET Value = '1' WHERE Keyword = 'Over_here'" Dim da As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn) recordsAffected = da.ExecuteNonQuery() conn.Close()
'value' is a keyword in t-sql which is what the problem probably is. You could wrap the word in square brackets '[value]' which might solve the problem - I haven't got time to try it right at the moment though...
It definitely isn't definatley
-
'value' is a keyword in t-sql which is what the problem probably is. You could wrap the word in square brackets '[value]' which might solve the problem - I haven't got time to try it right at the moment though...
It definitely isn't definatley
Thank you.