/** Descripción de Método */
private void cmd_find() {
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
int AD_Table_ID = m_reportEngine.getPrintFormat().getAD_Table_ID();
String title = null;
String tableName = null;
// Get Find Tab Info
String sql =
"SELECT t.AD_Tab_ID "
// ,w.Name, t.Name, w.IsDefault, t.SeqNo, ABS (tt.AD_Window_ID-t.AD_Window_ID)
+ "FROM AD_Tab t"
+ " INNER JOIN AD_Window w ON (t.AD_Window_ID=w.AD_Window_ID)"
+ " INNER JOIN AD_Table tt ON (t.AD_Table_ID=tt.AD_Table_ID) "
+ "WHERE t.AD_Table_ID=? "
+ "ORDER BY w.IsDefault DESC, t.SeqNo, ABS (tt.AD_Window_ID-t.AD_Window_ID)";
int AD_Tab_ID = DB.getSQLValue(null, sql, AD_Table_ID);
//
sql = "SELECT Name, TableName FROM AD_Tab_v WHERE AD_Tab_ID=?";
if (!Env.isBaseLanguage(Env.getCtx(), "AD_Tab")) {
sql =
"SELECT Name, TableName FROM AD_Tab_vt WHERE AD_Tab_ID=?"
+ " AND AD_Language='"
+ Env.getAD_Language(Env.getCtx())
+ "'";
}
try {
PreparedStatement pstmt = DB.prepareStatement(sql);
pstmt.setInt(1, AD_Tab_ID);
ResultSet rs = pstmt.executeQuery();
//
if (rs.next()) {
title = rs.getString(1);
tableName = rs.getString(2);
}
//
rs.close();
pstmt.close();
} catch (SQLException e) {
log.log(Level.SEVERE, "MTabVO.create(1)", e);
}
MField[] findFields = null;
if (tableName != null) {
findFields = MField.createFields(m_ctx, m_WindowNo, 0, AD_Tab_ID);
}
if (findFields == null) { // No Tab for Table exists
bFind.setEnabled(false);
} else {
Find find = new Find(this, m_WindowNo, title, AD_Table_ID, tableName, "", findFields, 1);
m_reportEngine.setQuery(find.getQuery());
revalidate();
}
cmd_drill(); // setCursor
} // cmd_find
