public static void readReferenceList(ArrayList<String> v_value,ArrayList<String> v_name,ArrayList<String> v_description){
  if (v_value == null)   throw new IllegalArgumentException("v_value parameter is null");
  if (v_name == null)   throw new IllegalArgumentException("v_name parameter is null");
  if (v_description == null)   throw new IllegalArgumentException("v_description parameter is null");
  String sql;
  if (Env.isBaseLanguage(Env.getCtx(),"AD_Ref_List"))   sql="SELECT Value, Name, Description FROM AD_Ref_List " + "WHERE AD_Reference_ID=? 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=? ORDER BY t.Name";
  try {
    PreparedStatement pstmt=DB.prepareStatement(sql,null);
    pstmt.setInt(1,DocAction.AD_REFERENCE_ID);
    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);
  }
}

public static void readReferenceList ( ArrayList < String > v_value , ArrayList < String > v_name , ArrayList < String > v_description ) { if ( v_value == null ) throw new IllegalArgumentException ( "v_value parameter is null" ) ; if ( v_name == null ) throw new IllegalArgumentException ( "v_name parameter is null" ) ; if ( v_description == null ) throw new IllegalArgumentException ( "v_description parameter is null" ) ; String sql ; if ( Env . isBaseLanguage ( Env . getCtx ( ) , "AD_Ref_List" ) ) sql = "SELECT Value, Name, Description FROM AD_Ref_List " + "WHERE AD_Reference_ID=? 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=? ORDER BY t.Name" ; try { PreparedStatement pstmt = DB . prepareStatement ( sql , null ) ; pstmt . setInt ( 1 , DocAction . AD_REFERENCE_ID ) ; 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 ) ; } }
fill vector with docaction ref_list ( 135 ) values
