UPDATE Statements

To update a table, use the standard UPDATE SQL syntax. The RSSBus JDBC Driver for MSCRM supports updating only one row at a time. Hence the primary key Id is always required.

  
  String cmd = "UPDATE Lead SET (FullName='John Smith') WHERE Id = ?";
  PreparedStatement pstmt = conn.prepareStatement(cmd);
  pstmt.setString(1, "1045625d-99ee-e011-a272-00155d01ad6b");
  int count=pstmt.getUpdateCount();
  pstmt.execute();
  if (count!=-1)
  {
    System.out.println(count+" rows are affected");
  }

To update a table, use the standard UPDATE SQL syntax. The RSSBus JDBC Driver for MSCRM supports updating only one row at a time. Hence the primary key Id is always required.

  
  String cmd = "UPDATE Lead SET (FullName='John Smith') WHERE Id = ?";
  PreparedStatement pstmt = conn.prepareStatement(cmd);
  pstmt.setString(1, "1045625d-99ee-e011-a272-00155d01ad6b");
  int count=pstmt.getUpdateCount();
  pstmt.execute();
  if (count!=-1)
  {
    System.out.println(count+" rows are affected");
  }