Banner 9 List show At last record fix for "you can not create record here"

Banner 9 List show At last record fix for "you can not create record here"


@ActionTrigger(action="KEY-NXTREC", function=KeyFunction.NEXT_RECORD)
public void glbslct_NextRecord()
{
     


GAdapter gElement = (GAdapter)this.getFormModel().getGT().getRowAdapter(true);

if (gElement !=null){



nextRecord();
getTask().getGoqrpls().gCheckFailure();
if ( gElement .getCode().isNull() )
{



previousRecord();
getTask().getGoqrpls().gCheckFailure();
infoMessage(GNls.Fget(toStr("G-0008"), toStr("FORM"), toStr("At last record.")));
}
}
}




/* @ActionTrigger(action="WHEN-NEW-RECORD-INSTANCE", function=KeyFunction.RECORD_CHANGE)
@After
public void xx_recordChange()
{


   
 Adapter element = (FtvacctAdapter)this.getFormModel().getxxx().getRowAdapter(true);
if (element == null) return;



if (BlockServices.isInLastRecord())
{

/

if ( getBlockCurrentRecord(getCursorBlock()).notEquals(1) )
{



infoMessage(GNls.Fget(toStr("-0010"), toStr("FORM"), toStr("At last record.")));
previousRecord();
BlockServices.lastRecord();
}
}

            //errorMessage(GNls.Fget(toStr("-0011"), toStr("FORM"), toStr("Unable to retrieve Commit Type.")));

}
*/

Banner 9 Insert data to table and Select multiple row

Banner 9 Insert data to table and Select multiple row


String sqlc1 = "SELECT * " +
   " FROM FFRMASF " +
   " WHERE FFRMASF_OTAG_CODE = :FFBMAST_OTAG_CODE ";
DataCursor c1 = new DataCursor(sqlc1);
TableRow recType3= null;
try{
//Setting query parameters
c1.addParameter("FFBMAST_OTAG_CODE", ffbmastElement.getFfbmastOtagCode());
c1.open();
while (true) {
recType3 = c1.fetchRow();


//recType3.getNumber("FFRMASF_AMT") = 0;

if ( c1.notFound() )
break;
parCoasCode=recType3.getStr("ffrmasf_coas_code");
FFRMASF_FUND_CODE=recType3.getStr("ffrmasf_fund_Code");


try{
//Setting query parameters
findEquity.addParameter("P_PAR_COAS_CODE", parCoasCode);

findEquity.open();
ResultSet findEquityResults = findEquity.fetchInto();
if ( findEquityResults != null ) {
holdPlant = findEquityResults.getStr(0);
}
if ( findEquity.notFound() || holdPlant.isNull() ){
try{
parCoasCode=recType3.getStr("ffrmasf_coas_Code");
//Setting query parameters
findEquityTwo.addParameter("P_PAR_COAS_CODE", parCoasCode);

findEquityTwo.open();
ResultSet findEquityTwoResults = findEquityTwo.fetchInto();
if ( findEquityTwoResults != null ) {
holdPlant = findEquityTwoResults.getStr(0);
}
}finally{
findEquityTwo.close();
}
}
}finally{
findEquity.close();
}

parCoasCode=recType3.getStr("ffrmasf_coas_Code");


try{
//Setting query parameters
fundFund.addParameter("P_PAR_FUND_CODE", parFundCode);

fundFund.open();
ResultSet fundFundResults = fundFund.fetchInto();
if ( fundFundResults != null ) {
holdFundFtyp = fundFundResults.getStr(0);

}
}finally{
fundFund.close();
}


parCoasCode=recType3.getStr("ffrmasf_coas_Code");
parFtypCode=holdFundFtyp;

try{
//Setting query parameters
fundInternal.addParameter("EFFDATE_EFF_DATE_TIME", getFormModel().getFormHeader().getEffdateEffDateTime());

fundInternal.open();
ResultSet fundInternalResults = fundInternal.fetchInto();
if ( fundInternalResults != null ) {
holdInternal = fundInternalResults.getStr(0);
}

}else {
if ( holdPlantFund.isNull() ){
parCoasCode=recType3.getStr("ffrmasf_coas_Code");
try{
//Setting query parameters
fundInternalTwo.addParameter("P_PAR_COAS_CODE", parCoasCode);

fundInternalTwo.open();
ResultSet fundInternalTwoResults = fundInternalTwo.fetchInto();
if ( fundInternalTwoResults != null ) {
holdPlantFund = fundInternalTwoResults.getStr(0);
}
FFRMASF_FUND_CODE = holdPlantFund;
}finally{
fundInternalTwo.close();
}

}
FFRMASF_FUND_CODE = holdPlantFund;
}
}finally{
fundInternal.close();
}


parCoasCode=recType3.getStr("ffrmasf_coas_code");
FFRMASF_ACCT_CODE = recType3.getStr("ffrmasf_Acct_Code");
parAcctCode= FFRMASF_ACCT_CODE;

try{
//Setting query parameters
fundAcct.addParameter("EFFDATE_EFF_DATE_TIME", getFormModel().getFormHeader().getEffdateEffDateTime());

fundAcct.open();
ResultSet fundAcctResults = fundAcct.fetchInto();
if ( fundAcctResults != null ) {
holdAcct = fundAcctResults.getStr(0);
}
}finally{
fundAcct.close();
}


}

String sql1 = "INSERT INTO FFRMASA " +
  "(FFRMASA_OTAG_CODE, FFRMASA_CHANGE_SEQ_NUM, FFRMASA_SEQ_NUM, FFRMASA_ACTIVITY_DATE, FFRMASA_USER_ID, FFRMASA_COAS_CODE, FFRMASA_BANK_CODE, FFRMASA_AMT, FFRMASA_ADJ_AMT, FFRMASA_AMT_PCT, FFRMASA_FUND_CODE_CAP, FFRMASA_ACCT_CODE_ASSET, )" +
  "VALUES (:P_REC_TYPE3_FFRMASF_OTAG_CODE, 0, :P_REC_TYPE3_FFRMASF_SEQ_NUM, :P_REC_TYPE3_FFRMASF_ACTIVITY_DATE, :P_REC_TYPE3_FFRMASF_USER_ID, :P_REC_TYPE3_FFRMASF_COAS_CODE, '', )";
DataCommand command1 = new DataCommand(sql1);
//Setting query parameters
command1.addParameter("P_REC_TYPE3_FFRMASF_OTAG_CODE", recType3.getStr("FFRMASF_OTAG_CODE"));
command1.addParameter("P_REC_TYPE3_FFRMASF_SEQ_NUM", recType3.getNumber("FFRMASF_SEQ_NUM"));
command1.addParameter("P_REC_TYPE3_FFRMASF_ACTIVITY_DATE", recType3.getDate("FFRMASF_ACTIVITY_DATE"));
command1.addParameter("P_REC_TYPE3_FFRMASF_USER_ID", recType3.getStr("FFRMASF_USER_ID"));
command1.addParameter("P_REC_TYPE3_FFRMASF_COAS_CODE", recType3.getStr("FFRMASF_COAS_CODE"));

rowCount = command1.execute();
}
}finally{
c1.close();
}

try{
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("5"));
commitTask();
}finally{
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("0"));
}

Banner : Select query using DataCusor example

Banner : Select query using DataCusor example


String sqlAcctTitle = "SELECT FTVACCT_TITLE " +
" FROM FTVACCT " +
" WHERE FTVACCT_COAS_CODE = :KEYBLOC_COAS_CODE1 ";


DataCursor acctCursor = new DataCursor(sqlAcctTitle);

try {
// Setting query parameters and passing the values into query above
//---------------------------------------------------------------------------
ptiCursor.addParameter("KEYBLOC_COAS_CODE", getFormModel().getKeyBlock().getKeyblocCoasCode());


// Open cursor and fetch result into Resultset
//--------------------------------------------------
ptiCursor.open();
ResultSet ptiCursorResults = ptiCursor.fetchInto();

if ( ptiCursorResults != null )
{
// Set the value from ResultSet into each column in each row

ftvacctElement.setDisplayAvailBud(ptiCursorResults.getNumber(0));

}

} catch (Exception e) {
throw new ApplicationException(e);
} finally{
ptiCursor.close();

}
}

Banner 9: able run form in local but not in server. On server error is Not not authorized access Form

Banner 9: able run form in local but not in server. On server error is Not not authorized access Form


Check all security and GUAPAGE too

*ERROR* User HRBATUSR not authorized access form in Banner 9

Banner error not authorized access GOAIMMU

Banner error not authorized to access GUAINIT

Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment

Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment

Testing Banner 9.x admin pages in an Eclipse development with Tomcat 8.x can result in problems with page data being cached.  Due to known Eclipse bugs, the "Serve modules without publishing" flag must be unchecked or Tomcat 8.x will not start up.  With that flag unchecked, users have reported annoying cache issues with changes not being picked up when testing.  Sometimes clearing the web browser cache manually or doing Tomcat -> Clean and Tomcat -> Clean Tomcat Work Directory will fix the issue, but not always.  The suggested work around is to switch to Tomcat 7.x for all testing done via Eclipse.  Once development work has been finished, the extensions and custom pages can later be deployed on a Tomcat 8.x server (outside of Eclipse) if desired.

Banner: Eclipse caching old code

Banner 9: Eclipse caching old code

solution:

- close  eclipse
- open eclipse
- refresh project
- refresh Webservice. HR
- maven update clean project

sometime need to to twice

Banner 9: Add Where clause into SQL query runtime

Banner 9: Add Where clause into SQL query runtime


@BeforeQuery
public void fzvacct_BeforeQuery(QueryEvent args) {
 
 
 
  NString acctCode =  this.getFormModel().getKeyBlock().getAcctCode();
  if (acctCode != null && !acctCode.isEmpty()){
  ((IDBBusinessObject)args.getSource()).setWhereClause("ACCT_CODE = '"+acctCode+"' ");
  }
 


}