System.Data.OleDb.OleDbCommand SaveGroupCommand = new OleDbCommand( "UPDATE GROUPDETAILS SET GROUPNAME = ? WHERE GROUPDETAILS.GROUPID = ? ", dbConnection); SaveGroupCommand.Parameters.Add("?groupName", "Did it save"); SaveGroupCommand.Parameters.Add("?groupId", this.GroupId); SaveGroupCommand.ExecuteNonQuery();>Is it possible to use parameters in INSERT and UPDATE commands with the VFP OLEDB Provider in .net (or any environment really?)
>System.Data.OleDb.OleDbCommand SaveGroupCommand = new OleDbCommand( > "UPDATE GROUPDETAILS SET GROUPNAME = @groupName WHERE GROUPDETAILS.GROUPID = " + this.GroupId.ToString(), dbConnection); > >SaveGroupCommand.Parameters.Add("@groupName", "Did it save"); > >SaveGroupCommand.ExecuteNonQuery(); >>