Using of Jdbc.getConnection() statement in google apps script

can we use this Jdbc.getConnection() statement once in a script r we have to use it for every execution of the statement. I was repeatedly written this statement in my coding as show below,

I have used the Jdbc.getConnection() once in a function, Now my doubt is "Is it possible to use the Jdbc.getConnection() statement once in a script?"

Please someone clarify this doubt to reduce some part of code from the entire code.

Tnx,

CL.

var dburl="jdbc:google:rdbms://<instance>/<database>";

var user='';

var pwd='';

var TimeZone= Session.getTimeZone();

function doGet() 

{

  var app=UiApp.createApplication();

  var CHES_mainpanel=app.createVerticalPanel().setId('CHES_mainpanel');

  var CHES_headerpanel=app.createVerticalPanel().setId('CHES_headerpanel');

  var CHES_scrollpanel = app.createScrollPanel().setHeight('200px').setId('CHES_scrollpanel').setWidth('2016px');

  var CHES_buttonpanel=app.createVerticalPanel().setId('CHES_buttonpanel');

  var CHES_subformpanel=app.createVerticalPanel().setId('CHES_subformpanel');

  var CHES_subformgrid=app.createGrid(11, 4).setId('CHES_subformgrid');

  var CHES_maingrid=app.createGrid(5, 3).setId('CHES_maingrid');

  var CHES_formgrid=app.createGrid(5, 3).setId('CHES_formgrid');

  var CHES_buttongrid=app.createGrid(3, 4).setId('CHES_buttongrid');

  app.add(eilib.createMaskPanel());

  var CHES_searchoptionlabel=app.createLabel("CHEQUE SEARCH BY").setStyleAttribute('color', 'blue');

  var CHES_searchoptionHandler=app.createServerHandler("CHEQUESEARCH.CHES_searchoption").addCallbackElement(CHES_mainpanel);

  var CHES_searchoptionlb=app.createListBox().setId('CHES_searchoptionlb').setName('CHES_searchoptionlb').addChangeHandler(CHES_searchoptionHandler)

  CHES_searchoptionlb.addItem("SELECT"); 

  CHES_searchoptionlb.addItem("AMOUNT RANGE");  

  CHES_searchoptionlb.addItem("CHEQUE NO");

  CHES_searchoptionlb.addItem("DATE RANGE");

  CHES_searchoptionlb.addItem("UNIT"); 

  var CHESU_errormessage=app.createLabel("CHEQUE DETAILS UPDATED SUCCESSFULLY").setId("CHESU_errormessage").setVisible(false).setStyleAttribute('color', 'blue');

  var CHESU_deletemessage=app.createLabel("CHEQUE DETAILS DELETED SUCCESSFULLY").setId("CHESU_deletemessage").setVisible(false).setStyleAttribute('color', 'blue');

  CHES_maingrid.setWidget(3, 2, CHESU_errormessage).setWidget(4, 2, CHESU_deletemessage);

  CHES_maingrid.setWidget(1, 0, CHES_searchoptionlabel).setWidget(1, 1, CHES_searchoptionlb);

  CHES_mainpanel.add(CHES_maingrid).add(CHES_formgrid);

  app.add(CHES_mainpanel);

  return app;

}

function CHES_searchoption(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_mainpanel=app.getElementById('CHES_mainpanel');

  var CHES_formgrid=app.getElementById('CHES_formgrid');

  CHES_formgrid.clear();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  app.getElementById('CHESU_errormessage').setVisible(false);

  var CHES_option=e.parameter.CHES_searchoptionlb;

  var conn=Jdbc.getCloudSqlConnection(dburl, user, pwd);

  var selectcc_errormessage="SELECT EMC_DATA FROM ERROR_MESSAGE_CONFIGURATION WHERE CNP_ID=1 AND EMC_SNO BETWEEN 1 AND 4";

  var errormessage_array =[];

  var errormessage_stmt=conn.createStatement();

  var errormessage_result=errormessage_stmt.executeQuery(selectcc_errormessage);

  while(errormessage_result.next())

  {

    errormessage_array.push(errormessage_result.getString("EMC_DATA")); 

  }

  errormessage_result.close();

  errormessage_stmt.close();

  var alpha=errormessage_array[0];

  var num=errormessage_array[1];

  UserProperties.setProperty('number',num);

  UserProperties.setProperty('alphabets',alpha);

  var CHES_CHEQUEsearchhandler=app.createServerHandler("CHEQUESEARCH.CHES_chequesearch").addCallbackElement(CHES_mainpanel);

  var CHES_CHEQUE_searchHandler=app.createServerHandler("CHEQUESEARCH.CHES_chequesearching").addCallbackElement(CHES_mainpanel)

  if(CHES_option=='DATE RANGE')

  {

    var CHES_daterange_head=app.createLabel("DARE RANGE SEARCH").setStyleAttribute('color', 'blue');

    var CHES_datesHandler=app.createServerHandler("CHEQUESEARCH.CHES_datevalidate").addCallbackElement(CHES_mainpanel);

    var CHES_startdatelabel=app.createLabel("START DATE");

    var CHES_stratdatedatebox=app.createDateBox().setId('CHES_stratdatedatebox').setWidth('75px').setName('CHES_stratdatedatebox').addValueChangeHandler(CHES_datesHandler);

    var CHES_enddatelabel=app.createLabel("END DATE");

    var CHES_enddatedatebox=app.createDateBox().setId('CHES_enddatedatebox').setWidth('75px').setName('CHES_enddatedatebox').addValueChangeHandler(CHES_datesHandler);

    var CHES_dateerror = app.createLabel('FROM DATE SHOULD BE LESSER THAN TO DATE').setStyleAttribute("color","red").setId('CHES_dateerror').setVisible(false);

    var CHES_datesearch_btn=app.createButton("SEARCH").setId('CHES_datesearch_btn').setEnabled(false).addClickHandler(CHES_CHEQUE_searchHandler).addClickHandler(eilib.enableMaskPanel(app));

  CHES_formgrid.setWidget(1,0,CHES_daterange_head)

  .setWidget(2,0,CHES_startdatelabel).setWidget(2,1,CHES_stratdatedatebox)

  .setWidget(3,0,CHES_enddatelabel).setWidget(3,1,CHES_enddatedatebox).setWidget(3,2,CHES_dateerror)

  .setWidget(4,0,CHES_datesearch_btn);

  }

  if(CHES_option=="AMOUNT RANGE")

  {

    var CHES_amountvalidate=app.createServerHandler('CHEQUESEARCH.CHES_rentvalidate').addCallbackElement(CHES_mainpanel);

    var CHES_amount_head=app.createLabel("AMOUNT RANGE SEARCH").setStyleAttribute('color', 'blue');

    var CHES_amount_fromLabel=app.createLabel("FROM AMOUNT");

    var CHES_amount_toLabel=app.createLabel("TO AMOUNT");

    var CHES_fromamountascii=app.createServerHandler('CHEQUESEARCH.CHES_fromamountascii').addCallbackElement(CHES_mainpanel);

    var CHES_toamountascii=app.createServerHandler('CHEQUESEARCH.CHES_toamountascii').addCallbackElement(CHES_mainpanel);

    var CHES_amounterrrormessage=app.createLabel("FROM AMOUNT SHOULD BE LESSER THAN TO AMOUNT").setId('CHES_renterrrormessage').setStyleAttribute('color', 'red').setVisible(false);

    var CHES_amount_fromtb=app.createTextBox().setId('CHES_rent_fromtb').setTitle(num).setName('CHES_rent_fromtb').setWidth('50px').addKeyPressHandler(CHES_fromamountascii).setMaxLength(5).addChangeHandler(CHES_amountvalidate);

    var CHES_amount_totb=app.createTextBox().setId('CHES_rent_totb').setTitle(num).setName('CHES_rent_totb').setWidth('50px').setMaxLength(5).addKeyPressHandler(CHES_toamountascii).addChangeHandler(CHES_amountvalidate);

    var CHES_amountsearch_btn=app.createButton('SEARCH').setId('CHES_rentsearch_btn').addClickHandler(CHES_CHEQUE_searchHandler).addClickHandler(eilib.enableMaskPanel(app)).setEnabled(false);

   CHES_formgrid.setWidget(1, 0, CHES_amount_head).setWidget(2, 0, CHES_amount_fromLabel).setWidget(2, 1, CHES_amount_fromtb)

   .setWidget(3, 0, CHES_amount_toLabel).setWidget(3, 1, CHES_amount_totb).setWidget(3, 2, CHES_amounterrrormessage)

   .setWidget(4, 0, CHES_amountsearch_btn);

  }

  if(CHES_option=="UNIT")

  {

    var CHES_unit_head=app.createLabel("UNIT SEARCH").setStyleAttribute('color', 'blue');

    var CHES_unitvalidate=app.createServerHandler("CHEQUESEARCH.CHES_unitvalidate").addCallbackElement(CHES_mainpanel);

    var CHES_unit_label=app.createLabel("UNIT");

    var CHES_unitlistbox=app.createListBox().setId('CHES_unitlistbox').setName('CHES_unitlistbox').addChangeHandler(CHES_unitvalidate);

    var CHES_unitsearch_btn=app.createButton("SEARCH").setId('CHES_unitsearch_btn').setEnabled(false).addClickHandler(CHES_CHEQUE_searchHandler).addClickHandler(eilib.enableMaskPanel(app));

    var unitstmt=conn.createStatement();

    var unitselectquery="SELECT DISTINCT CHEQUE_UNIT_NO FROM CHEQUE_ENTRY_DETAILS ORDER BY CHEQUE_UNIT_NO";

    var unirresult=unitstmt.executeQuery(unitselectquery);

    CHES_unitlistbox.addItem("SELECT");

    while(unirresult.next())

    {

      if((unirresult.getString("CHEQUE_UNIT_NO")==null)||(unirresult.getString("CHEQUE_UNIT_NO")==""))continue;

    CHES_unitlistbox.addItem(unirresult.getString("CHEQUE_UNIT_NO"));

    }

    unirresult.close();

    unitstmt.close();

    CHES_formgrid.setWidget(1,0, CHES_unit_head).setWidget(2, 0, CHES_unit_label).setWidget(2, 1, CHES_unitlistbox).setWidget(3, 0, CHES_unitsearch_btn);

  }

  if(CHES_option=="CHEQUE NO")

  {

    var CHES_chequeno_head=app.createLabel("CHEQUE NO SEARCH").setStyleAttribute('color', 'blue');

    var CHES_chequenolabel=app.createLabel("CHEQUE NO");

    var CHES_chequenoascii=app.createServerHandler("CHEQUESEARCH.CHES_chequenoascii").addCallbackElement(CHES_mainpanel);

    var CHES_chequenovalidate=app.createServerHandler("CHEQUESEARCH.CHES_chequenovalidate").addCallbackElement(CHES_mainpanel);

    var CHES_chequenotxt=app.createTextBox().setWidth('50px').setMaxLength(6).setId('CHES_chequenotxt').setName('CHES_chequenotxt').setTitle(num).addKeyPressHandler(CHES_chequenoascii).addChangeHandler(CHES_chequenovalidate);

    var CHES_chequenosearch_btn=app.createButton("SEARCH").setId('CHES_chequenosearch_btn').setEnabled(false).addClickHandler(CHES_CHEQUE_searchHandler).addClickHandler(eilib.enableMaskPanel(app));

    CHES_formgrid.setWidget(1,0, CHES_chequeno_head).setWidget(2, 0, CHES_chequenolabel).setWidget(2, 1, CHES_chequenotxt).setWidget(3, 0, CHES_chequenosearch_btn);

  }

  conn.close();

  return app;

}

function CHES_datevalidate(e)

{

  var app = UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

   var from_date = e.parameter.CHES_stratdatedatebox;

  var to_date = e.parameter.CHES_enddatedatebox;

  app.getElementById('CHES_dateerror').setVisible(false); 

  if((from_date > new Date(1/1/1970)) && (to_date > new Date(1/1/1970)))

  {

    app.getElementById('CHES_enddatedatebox').setStyleAttribute("color","black");

    app.getElementById('CHES_dateerror').setVisible(false); 

    app.getElementById('CHES_datesearch_btn').setEnabled(true);

    if(from_date > to_date)

    {

      app.getElementById('CHES_dateerror').setVisible(true); 

      app.getElementById('CHES_enddatedatebox').setStyleAttribute("color","red");

      app.getElementById('CHES_datesearch_btn').setEnabled(false);

    }

  }

  else

  {

    app.getElementById('CHES_datesearch_btn').setEnabled(false);

  }

  

  return app;

}

function CHES_fromamountascii(e)

{

  var app = UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var charCode = e.parameter.keyCode;

  if (charCode > 31 && (charCode < 48 || charCode > 57))

  {

    app.getElementById("CHES_rent_fromtb").setValue("");

    app.getElementById('CHES_rentsearch_btn').setEnabled(false);

  }

  return app; 

} 

function CHES_toamountascii(e)

{

  var app = UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var charCode = e.parameter.keyCode;

  if (charCode > 31 && (charCode < 48 || charCode > 57))

  {

    app.getElementById("CHES_rent_totb").setValue("");

    app.getElementById('CHES_rentsearch_btn').setEnabled(false);

  }

  return app; 

} 

function CHES_rentvalidate(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var from=e.parameter.CHES_rent_fromtb;

  var to=e.parameter.CHES_rent_totb;

  if((from!="")&&(to!=""))

  {

    if(from>to)

    {

      app.getElementById('CHES_rentsearch_btn').setEnabled(false);

      app.getElementById('CHES_renterrrormessage').setVisible(true)

    }

    else

    {

      app.getElementById('CHES_renterrrormessage').setVisible(false);

      app.getElementById('CHES_rentsearch_btn').setEnabled(true);

    }

  }

    else

    {

      app.getElementById('CHES_renterrrormessage').setVisible(false)

      app.getElementById('CHES_rentsearch_btn').setEnabled(false);

    }

    return app;

}

function CHES_unitvalidate(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var unit=e.parameter.CHES_unitlistbox;

  if(unit!="SELECT")

  {

    app.getElementById('CHES_unitsearch_btn').setEnabled(true);

  }

  else

  {

    app.getElementById('CHES_unitsearch_btn').setEnabled(false); 

  }

  return app;

}

function CHES_chequenoascii(e)

{

  var app = UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var charCode = e.parameter.keyCode;

  if (charCode > 31 && (charCode < 48 || charCode > 57))

  {

    app.getElementById("CHES_chequenotxt").setValue("");

    app.getElementById('CHES_chequenosearch_btn').setEnabled(false);

  }

  return app; 

}

function CHES_chequenovalidate(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var chequeno=e.parameter.CHES_chequenotxt;

  if(chequeno!="")

  {

    app.getElementById('CHES_chequenosearch_btn').setEnabled(true);

  }

  else

  {

    app.getElementById('CHES_chequenosearch_btn').setEnabled(false);

  }

  return app;

}

function CHES_chequesearching(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_mainpanel=app.getElementById('CHES_mainpanel');

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var CHES_buttonpanel=app.getElementById('CHES_buttonpanel');

  CHES_buttonpanel.clear();

  var CHES_buttongrid=app.getElementById('CHES_buttongrid');

  CHES_buttongrid.clear();

  var headerflexTable = app.createFlexTable().setStyleAttribute('border', '1px solid black')

  .setStyleAttribute('borderCollapse','collapse')

  .setBorderWidth(1).setTag('flx').setId('headerflexTable').setWidth('2000px');

  var dataflexTable = app.createFlexTable().setStyleAttribute('border', '1px solid black')

  .setStyleAttribute('borderCollapse','collapse')

  .setBorderWidth(1).setTag('flx').setId('flx').setWidth('2000px');

  headerflexTable.setText(0, 0, '').setStyleAttributes(0,0,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 0, 'width', '20px');;

  headerflexTable.setText(0, 1, 'DATE').setStyleAttributes(0,1,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 1, 'width', '100px');;

  headerflexTable.setText(0, 2, 'CHEQUE NO').setStyleAttributes(0,2,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 2, 'width', '100px');;

  headerflexTable.setText(0, 3, 'CHEQUE TO').setStyleAttributes(0,3,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 3, 'width', '200px');;

  headerflexTable.setText(0, 4, 'CHEQUE FOR').setStyleAttributes(0,4,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 4, 'width', '200px');;

  headerflexTable.setText(0, 5, 'AMOUNT').setStyleAttributes(0,5,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 5, 'width', '100px');;

  headerflexTable.setText(0, 6, 'UNIT').setStyleAttributes(0,6,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 6, 'width', '150px');;

  headerflexTable.setText(0, 7, 'CHEQUE STATUS').setStyleAttributes(0,7,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 7, 'width', '150px');;

  headerflexTable.setText(0, 8, 'DEBITED/RETURNED DATE').setStyleAttributes(0,8,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 8, 'width', '150px');;

  headerflexTable.setText(0, 9, 'COMMENTS').setStyleAttributes(0,9,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 9, 'width', '200px');;

  headerflexTable.setText(0, 10, 'USERSTAMP').setStyleAttributes(0,10,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 10, 'width', '200px');;

  headerflexTable.setText(0, 11,'TIMESTAMP').setStyleAttributes(0,11,{background: "#498af3", color: "white"}).setCellPadding(5).setCellSpacing(5).setStyleAttribute(0, 11, 'width', '200px');;

 var conn=Jdbc.getCloudSqlConnection(dburl, user, pwd);

  var chequestmt=conn.createStatement();

  var option=e.parameter.CHES_searchoptionlb;

  if(option=="UNIT")

  {

  var unit=e.parameter.CHES_unitlistbox;

  app.getElementById('CHES_unitsearch_btn').setEnabled(false);

  var tablename=app.createLabel("DETAILS OF SELECTED UNIT(S): "+unit).setStyleAttribute('color', '#0A0AFF').setId('tablename');

  var chequeresult=chequestmt.executeQuery("SELECT CED.CHEQUE_SNO,CED.CHEQUE_DATE,CED.CHEQUE_TO,CED.CHEQUE_NO,CED.CHEQUE_FOR,CED.CHEQUE_AMOUNT,CED.CHEQUE_UNIT_NO,CSD.CS_DATA,CED.CHEQUE_DEBITED_RETURNED_DATE,CED.CHEQUE_COMMENTS,CED.CHEQUE_TIMESTAMP,CED.CHEQUE_USERSTAMP  FROM CHEQUE_ENTRY_DETAILS CED,CHEQUE_STATUS_DETAILS CSD WHERE CED.CS_ID=CSD.CS_ID AND CHEQUE_UNIT_NO='"+unit+"'");

  }

  if(option=="DATE RANGE")

  {

    var fromdate=Utilities.formatDate(new Date(e.parameter.CHES_stratdatedatebox),TimeZone, 'yyyy-MM-dd');

    var enddate=Utilities.formatDate(new Date(e.parameter.CHES_enddatedatebox),TimeZone, 'yyyy-MM-dd');

    app.getElementById('CHES_datesearch_btn').setEnabled(false);

    var tablename=app.createLabel("DETAILS OF SELECTED DATE RANGE: "+fromdate+" TO "+enddate).setStyleAttribute('color', '#0A0AFF').setId('tablename');

    var chequeresult=chequestmt.executeQuery("SELECT CED.CHEQUE_SNO,CED.CHEQUE_DATE,CED.CHEQUE_TO,CED.CHEQUE_NO,CED.CHEQUE_FOR,CED.CHEQUE_AMOUNT,CED.CHEQUE_UNIT_NO,CSD.CS_DATA,CED.CHEQUE_DEBITED_RETURNED_DATE,CED.CHEQUE_COMMENTS,CED.CHEQUE_TIMESTAMP,CED.CHEQUE_USERSTAMP  FROM CHEQUE_ENTRY_DETAILS CED,CHEQUE_STATUS_DETAILS CSD WHERE CED.CS_ID=CSD.CS_ID AND CHEQUE_DATE BETWEEN'"+fromdate+"' and '"+enddate+"' ORDER BY CHEQUE_DATE ASC");

  }

  if(option=="AMOUNT RANGE")

  {

    var fromamount=e.parameter.CHES_rent_fromtb;

    var toamount=e.parameter.CHES_rent_totb;

     app.getElementById('CHES_rentsearch_btn').setEnabled(false);

    var tablename=app.createLabel("DETAILS OF SELECTED AMOUNT RANGE: "+fromamount+" TO "+toamount).setStyleAttribute('color', '#0A0AFF').setId('tablename');

    var chequeresult=chequestmt.executeQuery("SELECT CED.CHEQUE_SNO,CED.CHEQUE_DATE,CED.CHEQUE_TO,CED.CHEQUE_NO,CED.CHEQUE_FOR,CED.CHEQUE_AMOUNT,CED.CHEQUE_UNIT_NO,CSD.CS_DATA,CED.CHEQUE_DEBITED_RETURNED_DATE,CED.CHEQUE_COMMENTS,CED.CHEQUE_TIMESTAMP,CED.CHEQUE_USERSTAMP  FROM CHEQUE_ENTRY_DETAILS CED,CHEQUE_STATUS_DETAILS CSD WHERE CED.CS_ID=CSD.CS_ID AND CHEQUE_AMOUNT BETWEEN'"+fromamount+"' and '"+toamount+"' ORDER BY CHEQUE_DATE ASC");

  }

  if(option=="CHEQUE NO")

  {

    var chequeno=e.parameter.CHES_chequenotxt;

    app.getElementById('CHES_chequenosearch_btn').setEnabled(false);

    var tablename=app.createLabel("DETAILS OF SELECTED CHEQUE NO:"+chequeno).setStyleAttribute('color', '#0A0AFF').setId('tablename');

    var chequeresult=chequestmt.executeQuery("SELECT CED.CHEQUE_SNO,CED.CHEQUE_DATE,CED.CHEQUE_TO,CED.CHEQUE_NO,CED.CHEQUE_FOR,CED.CHEQUE_AMOUNT,CED.CHEQUE_UNIT_NO,CSD.CS_DATA,CED.CHEQUE_DEBITED_RETURNED_DATE,CED.CHEQUE_COMMENTS,CED.CHEQUE_TIMESTAMP,CED.CHEQUE_USERSTAMP  FROM CHEQUE_ENTRY_DETAILS CED,CHEQUE_STATUS_DETAILS CSD WHERE CED.CS_ID=CSD.CS_ID AND CHEQUE_NO='"+chequeno+"' ORDER BY CHEQUE_NO ASC");

  }

  var checkvalue=[];

  var row=1;

  while(chequeresult.next())

  {

    var flag=1;

    var sno=chequeresult.getString("CHEQUE_SNO");

    var chk_handler=app.createServerHandler('CHEQUESEARCH.CHES_checkbox').addCallbackElement(CHES_mainpanel);  

    var j = 0;

    var setname=sno+'/'+row;

    checkvalue.push(setname);

    dataflexTable.setWidget(row, j++,app.createRadioButton('radio').setId(setname+'/1').setName(setname+'/1').addValueChangeHandler(chk_handler)).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '20px');

    dataflexTable.setText(row, j++,chequeresult.getString("CHEQUE_DATE")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '100px');

    dataflexTable.setText(row, j++,chequeresult.getString("CHEQUE_NO")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '100px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_TO")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '200px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_FOR")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '200px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_AMOUNT")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '100px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_UNIT_NO")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '150px');

    dataflexTable.setText(row, j++, chequeresult.getString("CS_DATA")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '150px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_DEBITED_RETURNED_DATE")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '150px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_COMMENTS")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '200px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_USERSTAMP")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '200px');

    dataflexTable.setText(row, j++, chequeresult.getString("CHEQUE_TIMESTAMP")).setCellPadding(5).setCellSpacing(5).setStyleAttribute(row, j-1, 'width', '200px');

    row++;

  }

  chequeresult.close();

  chequestmt.close();

  conn.close();

  var CHES_updatehandler=app.createServerHandler("CHEQUESEARCH.CHES_searchupdate").addCallbackElement(CHES_mainpanel);

  var CHES_update_btn=app.createButton("SEARCH").setId('CHES_update_btn').setEnabled(false).addClickHandler(CHES_updatehandler).addClickHandler(eilib.enableMaskPanel(app));

  var CHES_deletehandler=app.createServerHandler("CHEQUESEARCH.CHES_delete").addCallbackElement(CHES_mainpanel);

  var CHES_delete_btn=app.createButton("DELETE").setId('CHES_delete_btn').setEnabled(false).addClickHandler(CHES_deletehandler).addClickHandler(eilib.enableMaskPanel(app));

  UserProperties.setProperty('config', checkvalue.join(','));

  if(flag==1)

  {

    CHES_buttongrid.setWidget(0,0,CHES_update_btn);

    CHES_buttonpanel.add(CHES_buttongrid);

    CHES_scrollpanel.add(dataflexTable);

    CHES_headerpanel.add(tablename).add(headerflexTable);

    CHES_headerpanel.add(CHES_scrollpanel).add(CHES_buttonpanel);

    CHES_mainpanel.add(CHES_headerpanel);

    if(option=="CHEQUE NO")

    {

     chequenoreset(); 

    }

    if(option=="AMOUNT RANGE")

    {

      amountrangereset();

    }

    if(option=="DATE RANGE")

    {

      daterangereset();

    }

    if(option=="UNIT")

    {

      unitreset();

    }

  }

  else

  {

    if(option=="CHEQUE NO")

   {

      var tablename12=app.createLabel("NO DETAILS OF SELECTED CHEQUE NO: "+chequeno).setStyleAttribute('color', 'red').setId('tablename12');

  chequenoreset()

   }

    if(option=="AMOUNT RANGE")

    {

      var tablename12=app.createLabel("NO DETAILS OF SELECTED AMOUNT RANGE:"+fromamount+" TO "+toamount).setStyleAttribute('color', 'red').setId('tablename12');

   amountrangereset();

    }

     if(option=="DATE RANGE")

    {

      var tablename12=app.createLabel("NO DETAILS OF SELECTED DATE RANGE:"+fromdate+" TO "+enddate).setStyleAttribute('color', 'red').setId('tablename12');

    daterangereset();

    }

   CHES_headerpanel.add(tablename12);

  CHES_mainpanel.add(CHES_headerpanel);

  }

  eilib.disableMaskPanel(app);

  return app;

}

function daterangereset()

{

  var app=UiApp.getActiveApplication();

  var CHES_mainpanel=app.getElementById('CHES_mainpanel');

  var CHES_formgrid=app.getElementById('CHES_formgrid');

   var CHES_datesHandler=app.createServerHandler("CHEQUESEARCH.CHES_datevalidate").addCallbackElement(CHES_mainpanel);

    var CHES_startdatelabel=app.createLabel("START DATE");

    var CHES_stratdatedatebox=app.createDateBox().setId('CHES_stratdatedatebox').setWidth('75px').setName('CHES_stratdatedatebox').addValueChangeHandler(CHES_datesHandler);

    var CHES_enddatelabel=app.createLabel("END DATE");

    var CHES_enddatedatebox=app.createDateBox().setId('CHES_enddatedatebox').setWidth('75px').setName('CHES_enddatedatebox').addValueChangeHandler(CHES_datesHandler);

CHES_formgrid.setWidget(2,1,CHES_stratdatedatebox).setWidget(3,1,CHES_enddatedatebox);

  return app;

}

function amountrangereset()

{

 var app=UiApp.getActiveApplication();

  app.getElementById('CHES_rent_fromtb').setValue('');

  app.getElementById('CHES_rent_totb').setValue('');

  return app;

}

function unitreset()

{

  var app=UiApp.getActiveApplication();

  app.getElementById('CHES_unitlistbox').setValue('');

  return app;

}

function chequenoreset()

{

  var app=UiApp.getActiveApplication();

  app.getElementById('CHES_chequenotxt').setValue('');

  return app;

}

function CHES_checkbox(e)

{

  var app=UiApp.getActiveApplication();

  var array_value= UserProperties.getProperty('config').split(',');

  var conn=Jdbc.getCloudSqlConnection(dburl, user, pwd)

  var flex=app.getElementById('flx');

  var chk=e.parameter.source;

  var chkval=e.parameter[chk];

  if(chkval=='true'){

    var array=chk.split('/');

    flex.setRowStyleAttribute(parseInt(array[1]), 'background', 'white');

    app.getElementById('CHES_update_btn').setEnabled(true);

    app.getElementById('CHES_delete_btn').setEnabled(true);

  }

  for(var i=0;i<array_value.length;i++)

  {

    if((array_value[i]+'/1')!=chk)

    {

      app.getElementById(array_value[i]+'/1').setValue(false);

      var array=array_value[i].split('/');

      flex.setRowStyleAttribute(parseInt(array[1]), 'background', 'white');

    }

  }

  return app;

}

function CHES_searchupdate(s)

{

  var app=UiApp.createApplication();

  var CHES_mainpanel=app.getElementById('CHES_mainpanel');

  var CHES_subformgrid=app.getElementById('CHES_subformgrid');

  var CHES_subformpanel=app.getElementById('CHES_subformpanel');

  app.getElementById('CHES_update_btn').setEnabled(false);

  app.getElementById('CHESU_errormessage').setVisible(false);

//  app.getElementById('CHES_deletemessage').setVisible(false);

  var conn=Jdbc.getCloudSqlConnection(dburl, user, pwd);

  var array = UserProperties.getProperty('config').split(',');

  for(var i=0;i<array.length;i++)

  {

    var a=array[i];

    var chk=s.parameter[array[i]+'/1'];

    if(chk=='true')

    {

      var id=array[i].split('/');

           }

    else if(chk=='false')

    {

      continue;

    }   

  }

  var num=UserProperties.getProperty('numbers');

  var alpha=UserProperties.getProperty('alphabets');

  var selectedrowdetails ="SELECT *FROM CHEQUE_ENTRY_DETAILS WHERE CHEQUE_SNO="+id[0]+"";

  var selectstmt=conn.createStatement();

  var selectresult=selectstmt.executeQuery(selectedrowdetails);

  if(selectresult.next())

  {

    var CHEQUE_updation_head=app.createLabel("CHEQUE UPDATION").setStyleAttribute('color', 'blue');

    var CHEQUE_ID=app.createTextBox().setId('CHEQUE_ID').setName('CHEQUE_ID').setVisible(false).setValue(id[0]);

    var CHEU_submitcheckhandler=app.createServerHandler("CHEQUESEARCH.CHEU_submitcheck").addCallbackElement(CHES_mainpanel)

  var CHEU_chequedatelabel=app.createHTML("CHEQUE DATE<b><body> <span style='color:red;'>*</span></body> </b>");

  var chequedate=selectresult.getString("CHEQUE_DATE");

  var cheque_date=chequedate.split('-');

  var c_year=cheque_date[0];

    var c_month=cheque_date[1];

    var c_date=cheque_date[2];

  var CHEU_chequedatebox=app.createDateBox().setValue(new Date(c_year,c_month-1,c_date)).setId('CHEU_chequedatebox').setWidth('75px').setName('CHEU_chequedatebox').addValueChangeHandler(CHEU_submitcheckhandler)

  var CHEU_chequenolabel=app.createHTML("CHEQUE NO<b><body> <span style='color:red;'>*</span></body> </b>");

  var CHEU_chequenovalidate=app.createServerHandler('CHEQUESEARCH.CHEU_chequenovalidate').addCallbackElement(CHES_mainpanel);

  var CHEU_chequenotext=app.createTextBox().setValue(selectresult.getString("CHEQUE_NO")).setId('CHEU_chequenotext').setTitle(num).setWidth('50px').addKeyPressHandler(CHEU_chequenovalidate).setMaxLength(6).setName('CHEU_chequenotb').addChangeHandler(CHEU_submitcheckhandler);

  var CHEU_chequetolabel=app.createHTML("CHEQUE TO<b><body> <span style='color:red;'>*</span></body> </b>").setId('CHEU_chequetolabel');

  var CHEU_chequetotext=app.createTextBox().setValue(selectresult.getString("CHEQUE_TO")).setId('CHEU_chequetotext').setMaxLength(100).setName('CHEU_chequetotext').addChangeHandler(CHEU_submitcheckhandler)

  var CHEU_chequeforlabel=app.createHTML("CHEQUE FOR<b><body> <span style='color:red;'>*</span></body> </b>");

  var CHEU_chequefortext=app.createTextBox().setValue(selectresult.getString("CHEQUE_FOR")).setId('CHEU_chequefortext').setMaxLength(100).setName('CHEU_chequefortext').addChangeHandler(CHEU_submitcheckhandler);

  var CHEU_chequeamountlabel=app.createHTML("CHEQUE AMOUNT<b><body> <span style='color:red;'>*</span></body> </b>").setId('CHEU_chequeamountlabel');

  var CHEU_chequeamountvalidate=app.createServerHandler("CHEQUESEARCH.CHEU_chequeamountvalidate").addCallbackElement(CHES_mainpanel)

  var amount=selectresult.getString("CHEQUE_AMOUNT");

    var amt=amount.split('.');

       var CHEU_chequeamounttext=app.createTextBox().setValue(amt[0]).setId('CHEU_chequeamounttext').setWidth('50px').setTitle(num).setMaxLength(5).addKeyPressHandler(CHEU_chequeamountvalidate).setName('CHEU_chequeamounttext').addChangeHandler(CHEU_submitcheckhandler);

  

     var CHES_statuslabel=app.createHTML("CHEQUE STATUS<b><body> <span style='color:red;'>*</span></body> </b>").setId('CHES_statuslabel');

    var statushandler=app.createServerHandler('CHEQUESEARCH.chequesearchdebited').addCallbackElement(CHES_mainpanel)

      var CHES_chequestatuslistbox=app.createListBox().setId('CHES_chequestatuslistbox').addChangeHandler(statushandler).setName('CHES_chequestatuslistbox').addChangeHandler(CHEU_submitcheckhandler);

      CHES_chequestatuslistbox.addItem("SELECT");

    var status=selectresult.getString("CS_ID");

      var status_array=[];

      var statusdetails="SELECT CS_ID,CS_DATA FROM CHEQUE_STATUS_DETAILS ORDER BY CS_DATA ASC";

      var stmt1 = conn.createStatement();

      var chequestatusresult= stmt1.executeQuery(statusdetails);

      while(chequestatusresult.next()) 

      {

        status_array.push(chequestatusresult.getString(2));

        if(status==chequestatusresult.getString(1))

        {

          var status_value=chequestatusresult.getString(2);

        }

      }

      chequestatusresult.close();

      stmt1.close();

    for(var J=0;J<status_array.length;J++)  

      {  

        CHES_chequestatuslistbox.addItem(status_array[J]);  

        if(status_value==status_array[J])

        {

          CHES_chequestatuslistbox.setSelectedIndex(J+1);

        }

      }  

    

     var debitdate=selectresult.getString("CHEQUE_DEBITED_RETURNED_DATE");

    if(debitdate!=null)

    {

      var debitdates=debitdate.split('-');

      var day1=debitdates[2];

      var month1=debitdates[1];

      var year1=debitdates[0];

      var CHES_debitlabel=app.createHTML("DEBITED/REJECTED DATE<b><body> <span style='color:red;'>*</span></body> </b>").setVisible(true).setId('CHES_debitlabel');

      var CHES_debittext=app.createDateBox().setVisible(true).setValue(new Date(year1,month1-1,day1)).setWidth('75px').setId('CHES_debiteddatebox').setName('CHES_debiteddatebox').addValueChangeHandler(CHEU_submitcheckhandler); 

    }

    else

    {

      var CHES_debitlabel=app.createHTML("DEBITED/REJECTED DATE <b><body> <span style='color:red;'>*</span></body> </b>").setVisible(false).setId('CHES_debitlabel');

      var CHES_debittext=app.createDateBox().setVisible(false).setWidth('75px').setId('CHES_debiteddatebox').setName('CHES_debiteddatebox').addValueChangeHandler(CHEU_submitcheckhandler);

    }

    var CHEU_chequeunitlabel=app.createLabel("UNIT");

    var CHEU_chequeunittext=app.createTextBox().setValue(selectresult.getString("CHEQUE_UNIT_NO")).setId('CHEU_chequeunittext').setName('CHEU_chequeunittext').addChangeHandler(CHEU_submitcheckhandler)

  var CHEU_chequecommentslabel=app.createLabel("COMMENTS");

  var CHEU_chequecommentstext=app.createTextArea().setValue(selectresult.getString("CHEQUE_COMMENTS")).setId('CHEU_chequecommentstext').setName('CHEU_chequecommentstext').addChangeHandler(CHEU_submitcheckhandler)

  var Chequesubmithandler=app.createServerHandler("CHEQUESEARCH.CHEU_chequeupdate").addCallbackElement(CHES_mainpanel);

  var Chequeresethandler=app.createServerHandler("CHEQUESEARCH.CHEU_chequereset").addCallbackElement(CHES_mainpanel)

  var CHEU_cheque_submit_btn=app.createButton("UPDATE").setId('CHEU_cheque_update_btn').setEnabled(false).addClickHandler(Chequesubmithandler).addClickHandler(eilib.enableMaskPanel(app));

  CHES_subformgrid.setWidget(0,0,CHEQUE_updation_head).setWidget(1, 0, CHEU_chequedatelabel).setWidget(1, 1, CHEU_chequedatebox).setWidget(1,2,CHEQUE_ID)

  .setWidget(2, 0, CHEU_chequenolabel).setWidget(2, 1, CHEU_chequenotext)

  .setWidget(3, 0, CHEU_chequetolabel).setWidget(3, 1, CHEU_chequetotext)

  .setWidget(4, 0, CHEU_chequeforlabel).setWidget(4, 1, CHEU_chequefortext)

  .setWidget(5, 0, CHEU_chequeamountlabel).setWidget(5, 1, CHEU_chequeamounttext)

  .setWidget(6, 0, CHES_statuslabel).setWidget(6, 1, CHES_chequestatuslistbox)

  .setWidget(7, 0, CHES_debitlabel).setWidget(7, 1, CHES_debittext)

  .setWidget(8, 0, CHEU_chequeunitlabel).setWidget(8, 1, CHEU_chequeunittext)

  .setWidget(9, 0, CHEU_chequecommentslabel).setWidget(9, 1, CHEU_chequecommentstext)

  .setWidget(10, 0, CHEU_cheque_submit_btn);

  }

  CHES_subformpanel.add(CHES_subformgrid);

  CHES_mainpanel.add(CHES_subformpanel)

  selectresult.close();

  selectstmt.close();

  conn.close();

  eilib.disableMaskPanel(app);

  return app;

}

function CHEU_chequenovalidate(e)

{

  var app = UiApp.getActiveApplication();

  var charCode = e.parameter.keyCode;

  if (charCode > 31 && (charCode < 48 || charCode > 57))

  {

    app.getElementById("CHEU_chequenotext").setValue("");

    app.getElementById('CHEU_cheque_update_btn').setEnabled(false);

  }

  return app; 

} 

function CHEU_chequeamountvalidate(e)

{

  var app = UiApp.getActiveApplication();

  var charCode = e.parameter.keyCode;

  if (charCode > 31 && (charCode < 48 || charCode > 57))

  {

    app.getElementById("CHEU_chequeamounttext").setValue("");

    app.getElementById('CHEU_cheque_update_btn').setEnabled(false);

  }

  return app; 

} 

function chequesearchdebited(e)

{

  var app=UiApp.getActiveApplication();

  var CHES_mainpanel=app.getElementById('CHES_mainpanel');

  var CHES_subformgrid=app.getElementById('CHES_subformgrid');

  var submitcheckhandler=app.createServerHandler('CHEQUESEARCH.CHEU_submitcheck').addCallbackElement(CHES_mainpanel);

  var status=e.parameter.CHES_chequestatuslistbox;

   if((status=="CREATED")||(status=="SELECT"))

  {

     var CHES_debittext=app.createDateBox().setVisible(false).setWidth('75px').setId('CHES_debiteddatebox').setName('CHES_debiteddatebox').addValueChangeHandler(submitcheckhandler);

    app.getElementById('CHES_debiteddatebox').setVisible(false);

    app.getElementById('CHES_debitlabel').setVisible(false);

  }

  else

  {

     var CHES_debittext=app.createDateBox().setVisible(true).setWidth('75px').setId('CHES_debiteddatebox').setName('CHES_debiteddatebox').addValueChangeHandler(submitcheckhandler);

    app.getElementById('CHES_debiteddatebox').setVisible(true);

    app.getElementById('CHES_debitlabel').setVisible(true);

  }

  CHES_subformgrid.setWidget(7,1,CHES_debittext)

  return app;

}

function CHEU_submitcheck(e)

{

  var app=UiApp.getActiveApplication();

  var cheque_date=e.parameter.CHEU_chequedatebox;

  var chequedate=Utilities.formatDate(new Date(cheque_date), TimeZone, "yyyy-MM-dd")

  var chequeno=e.parameter.CHEU_chequenotb;

  var chequeto=e.parameter.CHEU_chequetotext;

  var chequefor=e.parameter.CHEU_chequefortext;

  var chequeamount=e.parameter.CHEU_chequeamounttext;

  var status=e.parameter.CHES_chequestatuslistbox;

  var debiteddate=e.parameter.CHES_debiteddatebox;

  var chequeunit=e.parameter.CHEU_chequeunittext;

  var chequecomments=e.parameter.CHEU_chequecommentstext;

  if (!creation_check_Numbers(chequeno))

  {

    chequeno="";

    app.getElementById('CHEU_chequenotb').setValue(chequeno);

  }

  if (!creation_check_Numbers(chequeamount))

  {

    chequeamount="";

    app.getElementById('CHEU_chequeamounttext').setValue(chequeamount);

  }

  if((status=="CREATED")||(status=="SELECT"))

  {

    if((cheque_date!="")&&(chequeno!="")&&(chequeto!="")&&(chequefor!="")&&(chequeamount!="")&&(status!="SELECT"))

    {

      app.getElementById('CHEU_cheque_update_btn').setEnabled(true);

    }

    else

    {

      app.getElementById('CHEU_cheque_update_btn').setEnabled(false);  

    }

  }

  else

  {

    if((cheque_date!="")&&(chequeno!="")&&(chequeto!="")&&(chequefor!="")&&(chequeamount!="")&&(debiteddate >new Date(1969/01/01))&&(status!="SELECT"))

    {

      app.getElementById('CHEU_cheque_update_btn').setEnabled(true);

    }

    else

    {

      app.getElementById('CHEU_cheque_update_btn').setEnabled(false);  

    }

  }

  return app;

}

function CHEU_chequeupdate(e)

{

  var app=UiApp.getActiveApplication();

  var conn=Jdbc.getCloudSqlConnection(dburl, user, pwd);

  var id=e.parameter.CHEQUE_ID;

  var cheque_date=e.parameter.CHEU_chequedatebox;

  var chequedate=Utilities.formatDate(new Date(cheque_date), TimeZone, "yyyy-MM-dd")

  var chequeno=e.parameter.CHEU_chequenotb;

  var chequeto=e.parameter.CHEU_chequetotext;

  var chequefor=e.parameter.CHEU_chequefortext;

  var chequeamount=e.parameter.CHEU_chequeamounttext;

  var chequestatus=e.parameter.CHES_chequestatuslistbox;

  var statusdetails="SELECT CS_ID FROM CHEQUE_STATUS_DETAILS WHERE CS_DATA='"+chequestatus+"'";

  var S_stmt = conn.createStatement();

  var Statusrs = S_stmt.executeQuery(statusdetails);

  if(Statusrs.next()) {

    var status=Statusrs.getString(1);

  }

  Statusrs.close();

  S_stmt.close();

  var debited_date=e.parameter.CHES_debiteddatebox;

  if(debited_date!='CREATED')

  {

    var debiteddate=Utilities.formatDate(new Date(debited_date), TimeZone, "yyyy-MM-dd");

  }

  else

  {

    debiteddate="";

  }

  var chequeunit=e.parameter.CHEU_chequeunittext;

  var chequecomments=e.parameter.CHEU_chequecommentstext;

  var userstamp=Session.getActiveUser().getEmail();

  var timestamp=Utilities.formatDate(new Date(), TimeZone, "yyyy-MM-dd hh:mm:sss");

  try

  {

    var chequeupdatestmt=conn.createStatement();

    var chequeupdatewithoutdebitdatequery="UPDATE CHEQUE_ENTRY_DETAILS SET CHEQUE_NO="+chequeno+",CHEQUE_DATE='"+chequedate+"',CHEQUE_TO='"+chequeto+"',CHEQUE_FOR='"+chequefor+"',CHEQUE_AMOUNT='"+chequeamount+"',CHEQUE_UNIT_NO='"+chequeunit+"',CS_ID="+status+",CHEQUE_COMMENTS='"+chequecomments+"',CHEQUE_USERSTAMP='"+userstamp+"',CHEQUE_TIMESTAMP='"+timestamp+"' WHERE CHEQUE_SNO='"+id+"'";

    var chequeupdatewithdebitdatequery="UPDATE CHEQUE_ENTRY_DETAILS SET CHEQUE_NO="+chequeno+",CHEQUE_DATE='"+chequedate+"',CHEQUE_TO='"+chequeto+"',CHEQUE_FOR='"+chequefor+"',CHEQUE_AMOUNT='"+chequeamount+"',CHEQUE_UNIT_NO='"+chequeunit+"',CS_ID="+status+",CHEQUE_DEBITED_RETURNED_DATE='"+debiteddate+"',CHEQUE_COMMENTS='"+chequecomments+"',CHEQUE_USERSTAMP='"+userstamp+"',CHEQUE_TIMESTAMP='"+timestamp+"' WHERE CHEQUE_SNO='"+id+"'";

   if(debiteddate=="")

   {

    chequeupdatestmt.execute(chequeupdatewithoutdebitdatequery);

   }

    else

    {

      chequeupdatestmt.execute(chequeupdatewithdebitdatequery);

    }

    chequeupdatestmt.close();

    conn.close();

  }

  catch(err)

  {

    app.add(app.createLabel(err))

  }

  app.getElementById('CHESU_errormessage').setVisible(true);

  var CHES_headerpanel=app.getElementById('CHES_headerpanel');

  CHES_headerpanel.clear();

  var CHES_scrollpanel=app.getElementById('CHES_scrollpanel');

  CHES_scrollpanel.clear();

  var CHES_subformpanel=app.getElementById('CHES_subformpanel');

  CHES_subformpanel.clear();

  var CHES_formgrid=app.getElementById('CHES_formgrid')

  CHES_formgrid.clear();

  app.getElementById('CHES_searchoptionlb').setSelectedIndex(0);

  eilib.disableMaskPanel(app);

  return app;

}

function creation_check_Numbers(input)

{

  if(input==""||input==undefined)

  {

    return true;

  }

  else

  {

    var num=/^[0-9 ]+$/.test(input);

    return num;

  }

}

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.