public void addMissingColumns(String trxName){
  int total=0;
  String sql="SELECT * FROM AD_PrintFormat pf " + "ORDER BY Name";
  PreparedStatement pstmt=null;
  ResultSet rs=null;
  try {
    pstmt=DB.prepareStatement(sql,trxName);
    rs=pstmt.executeQuery();
    while (rs.next())     total+=addMissingColumns(new MPrintFormat(m_ctx,rs,trxName));
  }
 catch (  Exception e) {
    log.log(Level.SEVERE,sql,e);
  }
 finally {
    DB.close(rs,pstmt);
    rs=null;
    pstmt=null;
  }
  log.info("Total = " + total);
}

public void addMissingColumns ( String trxName ) { int total = 0 ; String sql = "SELECT * FROM AD_PrintFormat pf " + "ORDER BY Name" ; PreparedStatement pstmt = null ; ResultSet rs = null ; try { pstmt = DB . prepareStatement ( sql , trxName ) ; rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) total += addMissingColumns ( new MPrintFormat ( m_ctx , rs , trxName ) ) ; } catch ( Exception e ) { log . log ( Level . SEVERE , sql , e ) ; } finally { DB . close ( rs , pstmt ) ; rs = null ; pstmt = null ; } log . info ( "Total = " + total ) ; }
add missing columns for all print format
