private void readReference(){
  String sql;
  if (Env.isBaseLanguage(Env.getCtx(),"AD_Ref_List"))   sql="SELECT Value, Name, Description FROM AD_Ref_List " + "WHERE AD_Reference_ID=135 ORDER BY Name";
 else   sql="SELECT l.Value, t.Name, t.Description " + "FROM AD_Ref_List l, AD_Ref_List_Trl t " + "WHERE l.AD_Ref_List_ID=t.AD_Ref_List_ID"+ " AND t.AD_Language='" + Env.getAD_Language(Env.getCtx()) + "'"+ " AND l.AD_Reference_ID=135 ORDER BY t.Name";
  ArrayList<String> v_value=new ArrayList<String>();
  ArrayList<String> v_name=new ArrayList<String>();
  ArrayList<String> v_description=new ArrayList<String>();
  try {
    PreparedStatement pstmt=DB.prepareStatement(sql,null);
    ResultSet rs=pstmt.executeQuery();
    while (rs.next()) {
      String value=rs.getString(1);
      String name=rs.getString(2);
      String description=rs.getString(3);
      if (description == null)       description="";
      v_value.add(value);
      v_name.add(name);
      v_description.add(description);
    }
    rs.close();
    pstmt.close();
  }
 catch (  SQLException e) {
    log.log(Level.SEVERE,sql,e);
  }
  int size=v_value.size();
  s_value=new String[size];
  s_name=new String[size];
  s_description=new String[size];
  for (int i=0; i < size; i++) {
    s_value[i]=(String)v_value.get(i);
    s_name[i]=(String)v_name.get(i);
    s_description[i]=(String)v_description.get(i);
  }
}

private void readReference ( ) { String sql ; if ( Env . isBaseLanguage ( Env . getCtx ( ) , "AD_Ref_List" ) ) sql = "SELECT Value, Name, Description FROM AD_Ref_List " + "WHERE AD_Reference_ID=135 ORDER BY Name" ; else sql = "SELECT l.Value, t.Name, t.Description " + "FROM AD_Ref_List l, AD_Ref_List_Trl t " + "WHERE l.AD_Ref_List_ID=t.AD_Ref_List_ID" + " AND t.AD_Language='" + Env . getAD_Language ( Env . getCtx ( ) ) + "'" + " AND l.AD_Reference_ID=135 ORDER BY t.Name" ; ArrayList < String > v_value = new ArrayList < String > ( ) ; ArrayList < String > v_name = new ArrayList < String > ( ) ; ArrayList < String > v_description = new ArrayList < String > ( ) ; try { PreparedStatement pstmt = DB . prepareStatement ( sql , null ) ; ResultSet rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) { String value = rs . getString ( 1 ) ; String name = rs . getString ( 2 ) ; String description = rs . getString ( 3 ) ; if ( description == null ) description = "" ; v_value . add ( value ) ; v_name . add ( name ) ; v_description . add ( description ) ; } rs . close ( ) ; pstmt . close ( ) ; } catch ( SQLException e ) { log . log ( Level . SEVERE , sql , e ) ; } int size = v_value . size ( ) ; s_value = new String [ size ] ; s_name = new String [ size ] ; s_description = new String [ size ] ; for ( int i = 0 ; i < size ; i ++ ) { s_value [ i ] = ( String ) v_value . get ( i ) ; s_name [ i ] = ( String ) v_name . get ( i ) ; s_description [ i ] = ( String ) v_description . get ( i ) ; } }
fill vector with docaction ref_list ( 135 ) values
