Error in SQL Update on SQL Mobile .SDF
I can do SELECT's querys ok.
I use the following code;
--
Dim cnnAsNew System.Data.SqlServerCe.SqlCeConnection(CONNECTIONSTRING)
cnn.Open()
Dim TransAs System.Data.SqlServerCe.SqlCeTransaction
Trans = cnn.BeginTransaction()
Dim updateAsString ="UPDATE Driver SET Language = tLanguage WHERE Driver = tDriver"
Dim cmdAsNew System.Data.SqlServerCe.SqlCeCommand(update, cnn, Trans)Trycmd.ExecuteNonQuery()
Trans.Commit()
Catch exAs SqlCeExceptionCursor.Current = Cursors.Default
Dim errSQLAs SqlCeErrorForEach errSQLIn ex.ErrorsMessageBox.Show(errSQL.Message, _
"Error updating local database", _MessageBoxButtons.OK, _
MessageBoxIcon.Exclamation, _
MessageBoxDefaultButton.Button1)
tPassword =
FalseNextFinallycnn.Close()
EndTryThe error I get in return is;
The column name is not valid. [Node name(if any)=,Column name = tdriver]
If I can get a solution or suggested code to update a table with VS 2005 Visual Basic using SQL Mobile 2005.
Thank you,
Carlos

