private void loadCurrencies(){
  s_Currencies=new Hashtable<Integer,KeyNamePair>(12);
  String SQL="SELECT C_Currency_ID, ISO_Code FROM C_Currency " + "WHERE (IsEMUMember='Y' AND EMUEntryDate<SysDate) OR IsEuro='Y' " + "ORDER BY 2";
  try {
    PreparedStatement pstmt=DB.prepareStatement(SQL,null);
    ResultSet rs=pstmt.executeQuery();
    while (rs.next()) {
      int id=rs.getInt(1);
      String name=rs.getString(2);
      s_Currencies.put(new Integer(id),new KeyNamePair(id,name));
    }
    rs.close();
    pstmt.close();
  }
 catch (  SQLException e) {
    log.log(Level.SEVERE,SQL,e);
  }
}

private void loadCurrencies ( ) { s_Currencies = new Hashtable < Integer , KeyNamePair > ( 12 ) ; String SQL = "SELECT C_Currency_ID, ISO_Code FROM C_Currency " + "WHERE (IsEMUMember='Y' AND EMUEntryDate<SysDate) OR IsEuro='Y' " + "ORDER BY 2" ; try { PreparedStatement pstmt = DB . prepareStatement ( SQL , null ) ; ResultSet rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) { int id = rs . getInt ( 1 ) ; String name = rs . getString ( 2 ) ; s_Currencies . put ( new Integer ( id ) , new KeyNamePair ( id , name ) ) ; } rs . close ( ) ; pstmt . close ( ) ; } catch ( SQLException e ) { log . log ( Level . SEVERE , SQL , e ) ; } }
fill s_currencies with emu currencies
