Submitted by: Oscar Zelada (oszeladap)

Assigned to: Roman Rokytskyy (rrokytskyy)

Depends on JDBC119

Because updated records of the table that are not in the resulset seems to be updating the records that are consistent only with the first field in the primary key

example:
TABLA=DEMO1
sistema codigo campo valor
002 1 UNO 100
002 2 DOS 200
002 3 TRES 5000
002 5 UNO 300
002 10 DOS 100
002 20 UNO 200

PRIMARY KEY = CAMPO+CODIGO+SISTEMA

create resultset con sentencia = " SELECT * FROM DEMO1 WHERE SISTEMA='002' AND CODIGO=20"

GET AFTER THE RESULTSET WITH THESE RECORDS

sistema codigo campo valor
002 20 UNO 200

To upgrade the field "valor" of 200 to 10 with:

rs.updateInt("VALOR",10);
rs.updaterow();
rs.close

In the BD records were updated so
sistema codigo campo valor
002 1 UNO 10 (*)
002 2 DOS 200
002 3 TRES 5000
002 5 UNO 10 (*)
002 10 DOS 100
002 20 UNO 10 (*)

Because these results ?