I wonder if you could help?
I've just replicated my database into master and replica databases. Now I'm retesting my vb
.net application (it uses some of the framework of Beginning VB
I'm running some code that uses an 'insert' query and now I get the following error message:
Number of query values and destination fields are not the same
Here's the query code:
objData.SQL = "INSERT INTO [FitnessTestHistory] " & _
"VALUES(@ID, @DATEOFTEST, @VESSELID)"
objData.AddParameter("@ID", OleDb.OleDbType.Guid, 16, guidCrewMemberID)
objData.AddParameter("@DATEOFTEST", OleDb.OleDbType.DBDate, 8, DateTime.Parse(txtDateOfTest.Text))
objData.AddParameter("@VESSELID", OleDb.OleDbType.VarChar, 5, txtVessel.Text)
intRowsAffected = objData.Command.ExecuteNonQuery()
MS Access automatically added the following fields to each table when I did the reputation:
Are these the problem? Can anyone tell me what is going on? Thanks in advance.