E: Own form with checkbox

In the following example you can create your own form with a check box field

example_ownform

Note: define fields in SQL statements with '' and not space(1) because not running in HANA.

Wrong : space(1) as field
Correct: '' as field

You do not need to define the length of the field.

 

jbscript-logo-small

#jbs
// create new form and open it
let clform=application.openwindow({dwname:"ownWindow",
   sql:`select '' as cbx,'' as StringField,as NumberField,'' as itemcode from "BEAS_DUMMY" `,
   form:{title:"Own Window", height:2200} ,
   function:new function form_loaded(){
      // with function you define all events/functions for the new window
      // in event "loaded" define all additional Properties
      // change CheckBoxField to Checkbox
      dw_1.modify("cbx.checkbox.on='1' cbx.checkbox.off='0' cbx.checkbox.3d='yes' cbx.width=58");
      // doestry border around th efield
      dw_1.modify("destroy r__cbx");
      // define title
      dw_1.item.cbx.title="CheckBox";
      // ItemCode with dropdown
      dw_1.item.itemcode.dropdown.sql='select "ItemCode" from "OITM" where "PrcrmntMtd"=\'M\' ';
      }
   }
   ,{modal:true}
);
// Check, if form closed with OK
if(clform.returnOk==false) return -1;
 
// Check, if ItemCode is defined
if(clform.itemcode=="") {
   messagebox("error","Item Code not defined");
   return -1;}

 
 

help-hinweis Example Notes