I'm having a problem updating the following table, and I'm sure I'm missing something.
CROSSTABLE COL1_FK NUMBER REFERENCES TABLEA(COL1), COL2_FK NUMBER REFERENCES TABLEB(COL2), ID NUMBER UNIQUE, PRIMARY KEY (COL1_FK, COL2_FK) The following is the code I use: —---------------------------- String newCol2Fk = data.getParameters().get( "somenumber" ); Criteria crit = new Criteria(); crit.add( CrosstablePeer.ID, 10 ); List rst = CrosstablePeer.doSelect( crit ); Crosstable crt = (Crosstable)rst.get( 0 ); crt.setCol2Fk( newCol2Fk ); //I've also tried converting newCol2Fk to NumberKey //I've also tried CrosstablePeer.doUpdate() crt.save(); —----------------------------- This won't throw an exception. But Crosstable.ID does not get updated, it keeps the same values it had before the save() function called. I'm missing something here, any help would be appreciated. -John John A. Harris, Manager of Information Systems College of Nursing, University of Utah Voice: 801.585-9524 Fax: 801.585-7805 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
