1 Reply Latest reply: Nov 23, 2006 2:02 PM by jwenting RSS

    Primary keys and <resultSet>.insertRow()

    807607
                  artistsResults.moveToInsertRow();
                  artistsResults.updateString(1,newName);
                  artistsResults.updateString(2,newGroup);
                  
                //  artistsResults.updateString(3,newCV); // THINK ABOUT USING BLOB.
                  artistsResults.insertRow();
                  artistsResults.moveToCurrentRow();
      gives me error :
      java.sql.SQLException: Out of range value adjusted for column 'Number' at row 1
      I am thinking this is an issue with the Primary Key column "Number". How can I over come this problem?

      Thanks a million times in advance.