Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\ob\uncompressed\ob_table

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\ob\uncompressed\ob_table_functions.js

var g_conCount = 1;
var g_fkCount = 1;
var g_ukCount = 1;

/*Shows hides values*/
function ob_TableToggleType(pThis){
  var l_HolderTR = html_CascadeUpTill(pThis,'TR');
  var l_Inputs = l_HolderTR.getElementsByTagName('input');
  var l_Size = l_Inputs[1];
  var l_Scale = l_Inputs[2];
  var l_Comments = l_Inputs[3];
        html_VisibleElement(l_Comments); 
        switch(pThis.value){ 
                case "NUMBER": 
                    html_VisibleElement(l_Scale); 
                    if(l_Scale.value>38){l_Scale.value=''}
                    html_VisibleElement(l_Size); 
                    if((l_Size.value.length>0)&&(l_Scale.value.length==0)){l_Size.value=''}
                    break; 
                case "CLOB": case "BLOB": case "DATE": case "TIMESTAMP": 
                    html_HiddenElement(l_Scale); 
                    html_HiddenElement(l_Size); 
                    break;  
                case "VARCHAR2": 
                    html_VisibleElement(l_Scale); 
                    if((l_Scale.value>4000)||(l_Scale.value.length == 0)) {l_Scale.value='4000'}
                    html_HiddenElement(l_Size); 
                    break;
                case "NVARCHAR2": 
                    html_VisibleElement(l_Scale); 
                    if((l_Scale.value>2000)||(l_Scale.value.length == 0)) {l_Scale.value='2000'}
                    html_HiddenElement(l_Size); 
                    break; 
                case "CHAR": 
                    html_VisibleElement(l_Scale); 
                    html_HiddenElement(l_Size); 
                    if((l_Scale.value>100)||(l_Scale.value.length == 0)) {l_Scale.value='100'}
                    break; 
                case "BINARY_FLOAT": 
                    html_HiddenElement(l_Scale); 
                    html_HiddenElement(l_Size); 
                    break; 
                case "BINARY_DOUBLE": 
                    html_HiddenElement(l_Scale); 
                    html_HiddenElement(l_Size); 
                    break; 
                default:  
                   html_HiddenElement(l_Scale); 
                   html_HiddenElement(l_Size);
                   html_HiddenElement(l_Comments);
                   break; 
            } 
  return;
}

/*Add table row for add column*/
function ob_TableAddColumn(pThis,pThat,pNum){
//  html_GetElement("P602_COLUMNS").value =  html_GetElement("P602_COLUMNS").value +1;
      
  var newRows = addTableRow2(pThis,pThat,pNum);
  for (var i = 0;i<newRows.length;i++){
    var l_Inputs = newRows[i].getElementsByTagName('input');
    html_HiddenElement(l_Inputs[1]);
    html_HiddenElement(l_Inputs[2]);
  }
}

function ob_TablePrevInit(){
    var lTable = html_GetElement('htmldbNewTable');
    var lRows = html_GetElement('htmldbNewTable').rows;
    for(var i=1;i<lRows.length;i++){
      var lTemp = lRows[i].getElementsByTagName('SELECT')[0];
      ob_TableToggleType(lTemp)
    }

}

function ob_createTableGetFK() {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=1504518033640244',0);
    get.add('P145_FK_TABLE', html_GetElement("P145_FK_TABLE").value );
    var ret = get.get();
    get = null;
}

function ob_addFk() {
    // to table
    var toTable = html_GetElement('P145_FK_REF_TABLE').value;
    // to columns
    var toCols = ob_getOpts('P145_FK_REF_COLUMN_SEL');
    // from columns
    var fromCols = ob_getOpts('P145_FK_THIS_COLUMN_SEL');
    // fk name
    var fkName = html_GetElement('P145_FK_NAME').value;
    // fk action
    var fkAction = html_RadioValue('P145_FK_ACTION');
    // holders
    var fkHolder = html_GetElement('htmldbNewTable');
    
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=172369000165936003',0);
        get.add('P145_FK_REF_TABLE', toTable );
        get.add('P145_TO_COLS', toCols );
        get.add('P145_FROM_COLS', fromCols );
        get.add('P145_FK_NAME', fkName );
        get.add('P145_FK_ACTION', fkAction );
    var ret = get.get();
    if (ret.indexOf('HTMLDB:ERROR') > 0) { 
      html_GetElement('htmldbMessageHolder').innerHTML = ret;
    } else {

html_GetElement('htmldbNewTable').parentNode.innerHTML = ret;
      html_GetElement('P145_FK_REF_TABLE').value = '';
      html_GetElement('P145_FK_REF_COLUMN_SEL').options.length = 0;
      // html_GetElement('P145_FK_THIS_COLUMN_SEL').options.length = 0;
      g_fkCount += 1;
      html_GetElement('P145_FK_NAME').value = html_GetElement('P145_TABLE_NAME').value+'_fk'+g_fkCount;
      html_HideItemRow('P145_FK_REF_COLUMN');
      html_HideItemRow('P145_FK_REF_COLUMN_SEL');
      //html_GetElement('htmldbMessageHolder').innerHTML = '';
	  html_RemoveAllChildren('htmldbMessageHolder');
	  Shuttle.reset();
    }
      var foo = '';
}

function ob_rmFkRow(rowId) {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=172867829404455433',0);
        get.add('P145_FK_SEQ', rowId );
    var ret = get.get();        
    x = html_GetElement('fkTab_'+rowId);
	x.parentNode.removeChild(x);
}

/*fix for ie unchecking checkbox on row move*/
function ob_IeRowFixFinish(pThis,pChecked){
  if(document.all){
		var l_Items = html_Return_Form_Items(pThis);
		for (var i=0;i<l_Items.length;i++){
				if(l_Items[i].type == 'checkbox'){l_Items[i].checked = pChecked}
		}
 }
}

function ob_RowUp(pThis){
	var lCheck = ob_IeRowFixStart(pThis);
	var lRow = html_RowUp(pThis);
	ob_delayOrder();
	ob_IeRowFixFinish(lRow,lCheck);
}

function ob_RowDown(pThis){
	var lCheck = ob_IeRowFixStart(pThis);
	var lRow = html_RowDown(pThis);
	ob_delayOrder();
	ob_IeRowFixFinish(lRow,lCheck);
}

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de