System.Data.OleDb.OleDbCommand SaveGroupCommand = new OleDbCommand _ ("UPDATE GROUPDETAILS SET GROUPNAME = ? WHERE GROUPDETAILS.GROUPID = " + this.GroupId.ToString(), dbConnection); SaveGroupCommand.Parameters.Add("@x",DBType.String).Value="Did it save"or even:
System.Data.OleDb.OleDbCommand SaveGroupCommand = new OleDbCommand( "UPDATE GROUPDETAILS SET GROUPNAME = ? WHERE GROUPDETAILS.GROUPID = ?, dbConnection); SaveGroupCommand.Parameters.Add("@x",DBType.String).Value="Did it save" SaveGroupCommand.Parameters.Add("@y,DBType.Int32).Value = this.GroupId '(assuming VFP Int)Just make sure the order in which the parameter statements are added matches the order of the '?'s in the UPDATE command...