docs: public void close()
      {
          super.close();  // Write the current record, etc.
  
          try {
              if (this.lockOnDBTrxType(null, DBConstants.AFTER_REFRESH_TYPE, false))  // AFTER_REFRESH_TYPE = Close since there is no close
                  this.unlockIfLocked(this.getRecord(), null);    // Release any locks
          } catch (DBException ex)    {
              ex.printStackTrace();
          }
  
          try   {
              if (m_seekResultSet != null)
                  m_seekResultSet.close();
              m_seekResultSet = null;
              if (m_selectResultSet != null)
                  m_selectResultSet.close();
              m_selectResultSet = null;
              if (m_autoSequenceResultSet != null)
                  m_autoSequenceResultSet.close();
              m_autoSequenceResultSet = null;
              if (m_queryStatement != null)
                  m_queryStatement.close();
              m_queryStatement = null;
              if (m_updateStatement != null)
                  m_updateStatement.close();
              m_updateStatement = null;
              if (m_seekStatement != null)
                  m_seekStatement.close();
              m_seekStatement = null;
          } catch (SQLException e)    {
              e.printStackTrace();    // No error on close
          }
          m_iRow = -1;
          m_iEOFRow = Integer.MAX_VALUE;  // Last valid row.
          m_strStmtLastSQL = null;    // Last SQL string.
          m_strLastSQL = null;    // Last SQL string.
          m_strStmtLastSeekSQL = null;    // Last SQL string.
      }