Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: MCR ; Microsoft Dynamics AX Macro: SysSqlSetup unloaded ; -------------------------------------------------------------------------------- JOBVERSION 1 SOURCE #SysSqlSetup # // Object types for Sql storage and other... ##DEFINE.table(0) ##DEFINE.index(1) ##DEFINE.tableRoot(2) ##DEFINE.indexRoot(3) ##DEFINE.SystemTableRoot(4) ##DEFINE.OracleTablespace(5) # ##DEFINE.OracleStatistics(10) # ##DEFINE.idComponentAtoms(0) ##DEFINE.idComponentPart1(1) ##DEFINE.idComponentPart2(2) # ##DEFINE.singleTable(0) ##DEFINE.singleIndexForSingleTable(1) ##DEFINE.allIndexesForSingleTable(2) ##DEFINE.allTables(3) ##DEFINE.allIndexes(4) ##DEFINE.multiSelect(5) ##DEFINE.tablespace(6) # # //sql2008 Compression Types ##DEFINE.noCompression(0) ##DEFINE.pageCompression(1) ##DEFINE.rowCompression(2) # # // Action defines ##DEFINE.aReindex(0) ##DEFINE.aSynchronize(1) ##DEFINE.aTruncate(2) ##DEFINE.aCreateDDL(3) ##DEFINE.aDropDDL(4) ##DEFINE.aCheckTable(5) ##DEFINE.aRebuildIndex(6) # # // Parm defines for the sqlstorage table ##DEFINE.parmTableSpaceLoc('TABLESPACELOC') ##DEFINE.parmPartitioningEnabled('PARTITION') ##DEFINE.parmAutoExtend('AUTOEXTEND') ##DEFINE.parmInitialSize('INITIALSIZE') ##DEFINE.parmExtensionSize('EXTENSIONSIZE') ##DEFINE.parmUnlimitedSize('UNLIMITEDSIZE') ##DEFINE.parmMaxSize('MAXSIZE') ##DEFINE.parmTablespace('TABLESPACE') ##DEFINE.parmInitial('INITIAL') ##DEFINE.parmNext('NEXT') ##DEFINE.parmMinExtents('MINEXTENTS') ##DEFINE.parmMaxExtents('MAXEXTENTS') ##DEFINE.parmPctIncrease('PCTINCREASE') ##DEFINE.parmIniTrans('INITRANS') ##DEFINE.parmMaxTrans('MAXTRANS') ##DEFINE.parmPctFree('PCTFREE') ##DEFINE.parmPctUsed('PCTUSED') ##DEFINE.parmFreeLists('FREELISTS') ##DEFINE.parmFreeListGroups('FREELIST GROUPS') ##DEFINE.parmCompression('COMPRESSION') ##DEFINE.parmSortInTempDb('SORT_IN_TEMPDB') ##DEFINE.parmPadIndex('PAD_INDEX') ##DEFINE.parmFillFactor('FILLFACTOR') #// Add MAXDOP - start ##DEFINE.parmMaxDop('MAXDOP') #// Add MAXDOP - end # # // Tablespace types ##DEFINE.oraExtentManagementDictionary('DICTIONARY') ##DEFINE.oraExtentManagementLocal('LOCAL') ##DEFINE.oraSegSpaceManagementManual('MANUAL') ##DEFINE.oraSegSpaceManagementAuto('AUTO') # # ENDSOURCE PROPERTIES Origin #{040B0000-0000-1000-8F88-3481826C5365} ENDPROPERTIES ***Element: FRM ; Microsoft Dynamics AX Forms unloaded ; -------------------------------------------------------------------------------- FRMVERSION 12 FORM #SysSqlSetup PROPERTIES Name #SysSqlSetup Origin #{8055A842-DA53-4A83-84A1-F2E77AE1C0DE} ENDPROPERTIES METHODS SOURCE #classDeclaration #class FormRun extends ObjectRun #{ # #SysSqlSetup # # Dictionary dictionary; # # str exampleComponent; # str compoundComponent; # str componentPart1; # str componentPart2; # boolean isDataCompressionSupported; # boolean isTempTable; # # boolean modified; # boolean tablesInMultiSelect; # boolean indexesInMultiSelect; # # int nSelectedItems; // Numbers of selected items # FormTreeControl ftcSelectedTablesAndIndexes; // Might be transfered from SysSqlAdmin # SysOperationProgress operationProgress; // Progress meter # SysSqlSetupHelper setupHelper; // helper class for Oracle setup #} ENDSOURCE SOURCE #close #void close() #{ # element.save(); # super(); #} ENDSOURCE SOURCE #enableIndexControls #private void enableIndexControls(boolean val) #{ # sqlFillFactor.enabled(val); # sqlEnableFillFactor.enabled(val); # sqlEnablePadIndex.enabled(val); # sqlEnableSortInTempDB.enabled(val); # if (!val) # { # sqlFillFactor.value(0); # } # // Add MAXDOP - start # sqlMaxDop.enabled(val); # sqlEnableMaxDop.enabled(val); # // Add MAXDOP - end #} ENDSOURCE SOURCE #evaluate #void evaluate(boolean _modified = false) #{ # # if (_modified) # modified = true; # # element.lock(); # element.refreshSql(); # # saveValues.enabled( modified ); # # element.unLock(); #} ENDSOURCE SOURCE #fillIndexes #void fillIndexes(tableId tableId) #{ # DictTable dictTable = new DictTable(tableId); # int counter; # ; # # indexList.lock(); # indexList.clear(); # for(counter = dictTable.indexNext(0); counter > 0; counter = dictTable.indexNext(counter)) # indexList.add(dictTable.indexName(counter)); # indexList.unLock(true); # indexList.selection(0); #} ENDSOURCE SOURCE #fillTables #void fillTables(int cnt=9999999) #{ # int tableCounter; # DictTable dictTable; # # tableList.lock(); # for(tableCounter = dictionary.tableNext(0); tableCounter > 0; tableCounter = dictionary.tableNext(tableCounter)) # { # dictTable = new DictTable(tableCounter); # if(!dictTable.isTmp() && # !dictTable.isTempDb() && # !dictTable.isMap()) # tableList.add(dictTable.name()); # if (tableList.count() == cnt) # break; # } # # setupHelper.oldTableId(tableName2id(tableList.getText(tableList.selection()))); # element.fillIndexes(setupHelper.oldTableId()); # # tableList.unLock(true); #} ENDSOURCE SOURCE #generateComponents #/// #/// This method is to generate SQL statement for the table and index settings. #/// #void generateComponents() #{ # str helpS; # # componentPart1 = ''; # componentPart2 = ''; # compoundComponent = ''; # exampleComponent = ''; # helpS = ''; # # # if (sqlEnableFillFactor.value()) # { # componentPart1 = componentPart1 +'FILLFACTOR ='+int2str(sqlFillFactor.value())+' '; # } # # if (sqlEnablePadIndex.value()) # { # if (strLen(componentPart1)>0) # componentPart1 = componentPart1 + ','; # componentPart1 = componentPart1 +'PAD_INDEX = ON '; # } # # if (sqlEnableSortInTempDB.value()) # { # if (strLen(componentPart1)>0) # componentPart1 = componentPart1 + ','; # componentPart1 = componentPart1 +'SORT_IN_TEMPDB = ON '; # } # # // Add MAXDOP - start # if (sqlEnableMaxDop.value()) # { # if (strLen(componentPart1)>0) # componentPart1 = componentPart1 + ','; # componentPart1 = componentPart1 +'MAXDOP = '+int2str(sqlMaxDop.value())+' '; # } # // Add MAXDOP - end # # if (sqlEnableCompression.value()) # { # if (isDataCompressionSupported) # { # if (strLen(componentPart1)>0) # componentPart1 = componentPart1 + ','; # switch(sqlCompressionSelection.selection()) # { # case #noCompression: # componentPart1 = componentPart1 +'DATA_COMPRESSION = NONE'+' '; # break; # case #pageCompression: # componentPart1 = componentPart1 +'DATA_COMPRESSION = PAGE'+' '; # break; # case #rowCompression: # componentPart1 = componentPart1 +'DATA_COMPRESSION = ROW'+' '; # break; # } # } # } # if (strLen(componentPart1)>0) # componentPart1 = 'WITH ('+ componentPart1 + ') '; # # # if (strLen(componentPart1)>0) # componentPart1 = subStr(componentPart1,1,strLen(componentPart1)-1); # if (strLen(componentPart2)>0) # componentPart2 = subStr(componentPart2,1,strLen(componentPart2)-1); # compoundComponent=componentPart1+'\n'+componentPart2; # # # if (setupHelper.typeSelection() == #allTables || # setupHelper.typeSelection() == #singleTable || # (setupHelper.typeSelection() == #multiSelect && tablesInMultiSelect)) # { # exampleComponent = exampleComponent +'CREATE TABLE ( ) ' +compoundComponent; # } # # if (setupHelper.typeSelection() == #allIndexes || # setupHelper.typeSelection() == #allIndexesForSingleTable || setupHelper.typeSelection() == #singleIndexForSingleTable || # (setupHelper.typeSelection() == #multiSelect && indexesInMultiSelect)) # { # if (exampleComponent) # exampleComponent = exampleComponent +'\n'; # exampleComponent = exampleComponent +'CREATE INDEX ON ( ) ' +compoundComponent; # } #} ENDSOURCE SOURCE #init #void init() #{ # setupHelper = new SysSqlSetupHelper(); # super(); # dictionary = new Dictionary(); # # nSelectedItems = 0; # isTempTable = false; #} ENDSOURCE SOURCE #refreshSQL #void refreshSQL() #{ # this.generateComponents(); # sqlText.text( exampleComponent ); #} ENDSOURCE SOURCE #run #void run() #{ # FormTreeItem formTreeItem; # FormRun callFromForm; # SysTableIndexItem sysTableIndexItem; # DictTable dictTable; # int selectedIdx; # str s; # ; # # if (!element.args().caller()) //open from the checklist # { # ftcSelectedTablesAndIndexes = null; # setupHelper.typeSelection(#singleTable); # # element.fillTables(1); # # setupHelper.oldTableId(tableName2id(tableList.getText(tableList.selection()))); # setupHelper.oldIndexId(indexName2id(setupHelper.oldTableId(), indexList.getText(indexList.selection()))); # tableList.clear(); # } # else # { # callFromForm = element.args().caller(); # # if (callFromForm.name() == formStr(sysSqlAdmin)) // If called from SysSqlAdmin # { # tablesInMultiSelect = false; # indexesInMultiSelect = false; # # ftcSelectedTablesAndIndexes = element.args().parmObject(); # selectedIdx = ftcSelectedTablesAndIndexes.getFirstSelected(); # formTreeItem = ftcSelectedTablesAndIndexes.getItem(selectedIdx); # sysTableIndexItem = formTreeItem.data(); # # switch (sysTableIndexItem.getObjectType()) # { # case #tableRoot: # setupHelper.typeSelection(#allTables); # break; # case #indexRoot: # setupHelper.typeSelection(#allIndexes); # break; # case #table: # setupHelper.typeSelection(#singleTable); # setupHelper.oldTableId(sysTableIndexItem.getTableId()); # break; # case #index: # setupHelper.typeSelection(#singleIndexForSingleTable); # setupHelper.oldTableId(sysTableIndexItem.getTableId()); # setupHelper.oldIndexId(sysTableIndexItem.getIndexId()); # break; # } # # gSelection.visible(false); # # if ( setupHelper.typeSelection() == #singleTable || # setupHelper.typeSelection() == #singleIndexForSingleTable ) # { # sTableIndexName.visible(true); # s = dictionary.tableName(sysTableIndexItem.getTableId()); # dictTable = new DictTable(sysTableIndexItem.getTableId()); # if (sysTableIndexItem.getIndexId()) # { # s = s +'/' +dictTable.indexName(sysTableIndexItem.getIndexId()); # } # isTempTable = dictTable.isTempDb() || dictTable.isTmp() || dictTable.isMap(); # sTableIndexName.text(s); # } # # } # } # isDataCompressionSupported = setupHelper.isDataCompressionSupported(); # if (isTempTable) # { # element.enableIndexControls(false); # sqlEnableCompression.enabled(false); # sqlCompressionText.enabled(false); # sqlCompressionSelection.enabled(false); # } # else # { # if(!isDataCompressionSupported) # { # sqlEnableCompression.visible(false); # sqlCompressionText.visible(false); # sqlCompressionSelection.visible(false); # sqlCompressionSelection.enabled(false); # } # element.setSelection(); # } # # super(); # if (!element.args().caller()) # { # element.fillTables(); # tableList.selection(0); # } #} ENDSOURCE SOURCE #save #boolean save() #{ # if (!modified) # return true; # # if (!element.sqlServerSaveSelection()) # return false; # # element.saveClauses(); # # modified=false; # # element.evaluate(); # return true; #} ENDSOURCE SOURCE #saveClauses #void saveClauses() #{ # FormTreeItem formTreeItem; # SysTableIndexItem sysTableIndexItem; # int selectedIdx; # # // Variable which is used for the progression meter # int nTab = 0; // Number of selected tables # int pTab = 0; // Number of processed tables # # void doSaveClause(int id, int objectType, tableId tableId, indexId indexId, str clause) # { # setupHelper.doSaveClauseOnServer(id, objectType, tableId, indexId, clause); # } # # // # // Start of method # // # switch(setupHelper.typeSelection()) # { # case #allTables: # doSaveClause(1, #table, 0, 0, componentPart1); # doSaveClause(2, #table, 0, 0, componentPart2); # break; # case #singleTable: # doSaveClause(1, #table, setupHelper.oldTableId(), 0, componentPart1); # doSaveClause(2, #table, setupHelper.oldTableId(), 0, componentPart2); # break; # case #allIndexes: # doSaveClause(1, #index, 0, 0, componentPart1); # doSaveClause(2, #index, 0, 0, componentPart2); # break; # case #allIndexesForSingleTable: # doSaveClause(1, #index, setupHelper.oldTableId(), 0, componentPart1); # doSaveClause(2, #index, setupHelper.oldTableId(), 0, componentPart2); # break; # case #singleIndexForSingleTable: # doSaveClause(1, #index, setupHelper.oldTableId(), setupHelper.oldIndexId(), componentPart1); # doSaveClause(2, #index, setupHelper.oldTableId(), setupHelper.oldIndexId(), componentPart2); # break; # case #multiSelect: # // Setup progress meter # // Count the number of tables selected # selectedIdx = ftcSelectedTablesAndIndexes.getFirstSelected(); # while (selectedIdx) # { # nTab++; # selectedIdx = ftcSelectedTablesAndIndexes.getNextSelected(selectedIdx); # } # operationProgress = new SysOperationProgress(); # operationProgress.setCaption("@SYS58820"); # operationProgress.updateInterval(0); # operationProgress.setTotal(nTab); # operationProgress.setCount(pTab); # # selectedIdx = 0; # do # { # if (selectedIdx==0) # selectedIdx = ftcSelectedTablesAndIndexes.getFirstSelected(); # else # selectedIdx = ftcSelectedTablesAndIndexes.getNextSelected(selectedIdx); # # if (selectedIdx) # { # formTreeItem = ftcSelectedTablesAndIndexes.getItem(selectedIdx); # sysTableIndexItem = formTreeItem.data(); # ptab++; # operationProgress.setCount(pTab); # operationProgress.setText((sysTableIndexItem.getObjectType() == #table ? tableId2name(sysTableIndexItem.getTableId()) : indexId2name(sysTableIndexItem.getTableId(), sysTableIndexItem.getIndexId()))); # doSaveClause(1, sysTableIndexItem.getObjectType(), sysTableIndexItem.getTableId(), sysTableIndexItem.getIndexId(), componentPart1); # doSaveClause(2, sysTableIndexItem.getObjectType(), sysTableIndexItem.getTableId(), sysTableIndexItem.getIndexId(), componentPart2); # } # } while (selectedIdx!=0); # # # break; # } #} ENDSOURCE SOURCE #setControl #str setControl(FormCheckBoxControl _checkBox, # FormControl _control, # int objectType, # tableId tableId, # indexId indexId, # boolean override, # str 25 parm, # boolean setControl = false) #{ # str value; # setupHelper.findSqlStorage(objectType, tableId, indexId, override, parm); # value = setupHelper.getSqlStorageValue(); # # if (_checkBox) # { # _checkBox.enabled(true); # _checkBox.value(value ? true : false); # if (setControl) # _control.enabled(value ? true : false); # } # # return value; #} ENDSOURCE SOURCE #setDataCompressionControls #public void setDataCompressionControls() #{ # int val = sqlEnableCompression.value(); # if(isDataCompressionSupported) # { # sqlCompressionSelection.enabled(val); # if (!val) # sqlCompressionSelection.selection(0); # sqlCompressionSelection.modified(); # } #} ENDSOURCE SOURCE #setSelection #void setSelection() #{ # switch(setupHelper.typeSelection()) # { # case #singleTable: # tableList.enabled(true); # indexList.enabled(false); # break; # case #singleIndexForSingleTable: # tableList.enabled(true); # indexList.enabled(true); # break; # case #allIndexesForSingleTable: # tableList.enabled(true); # indexList.enabled(false); # break; # case #allTables: # tableList.enabled(false); # indexList.enabled(false); # break; # case #allIndexes: # tableList.enabled(false); # indexList.enabled(false); # break; # case #multiSelect: # tableList.enabled(false); # indexList.enabled(false); # break; # } # # element.sqlServerSetSelection(); # this.evaluate(); #} ENDSOURCE SOURCE #setSelectionInComboBoxFromString #void setSelectionInComboBoxFromString( FormComboBoxControl cb, str strActiveValue ) #{ # int i; # # for( i = 1; i <= cb.count(); i++ ) # { # cb.item( i ); # if( cb.text() == strActiveValue ) # { # cb.selection( i - 1 ); # break; # } # } # #} ENDSOURCE SOURCE #sqlServerSaveSelection #boolean sqlServerSaveSelection() #{ # if(isDataCompressionSupported) # { # setupHelper.saveSqlSelection(#parmCompression, sqlEnableCompression, int2str(sqlCompressionSelection.selection()), ftcSelectedTablesAndIndexes); # } # setupHelper.saveSqlSelection(#parmFillFactor, sqlEnableFillFactor, int2str(sqlFillFactor.value()), ftcSelectedTablesAndIndexes); # setupHelper.saveSqlSelection(#parmPadIndex, sqlEnablePadIndex, int2str(1), ftcSelectedTablesAndIndexes); # setupHelper.saveSqlSelection(#parmSortInTempDb, sqlEnableSortInTempDb, int2str(1), ftcSelectedTablesAndIndexes); # // Add MAXDOP - start # setupHelper.saveSqlSelection(#parmMaxDop, sqlEnableMaxDop, int2str(sqlMaxDop.value()), ftcSelectedTablesAndIndexes); # // Add MAXDOP - end # return true; #} ENDSOURCE SOURCE #sqlServerSetSelection #void sqlServerSetSelection() #{ # str value; # # switch(setupHelper.typeSelection()) # { # case #allTables: # this.enableIndexControls(false); # if(isDataCompressionSupported && !isTempTable) # { # value = this.setControl(sqlEnableCompression, sqlCompressionSelection, #Table, 0, 0, 0, #parmCompression, true); # sqlCompressionSelection.selection(str2int(value)); # } # //this.setDataCompressionControls(); # break; # case #SingleTable: # this.enableIndexControls(false); # if(isDataCompressionSupported && !isTempTable) # { # value = this.setControl(sqlEnableCompression, sqlCompressionSelection, #Table, setupHelper.oldTableId(), 0, 0, #parmCompression, true); # sqlCompressionSelection.selection(str2int(value)); # } # //this.setDataCompressionControls(); # break; # case #allIndexes: # this.enableIndexControls(true); # # value = this.setControl(sqlEnableSortInTempDB, sqlEnableSortInTempDB, #Index, 0, 0, 0, #parmSortInTempDb); # sqlEnableSortInTempDB.value(str2int(value)); # # value = this.setControl(sqlEnableFillFactor, sqlFillFactor, #Index, 0, 0, 0, #parmFillFactor, true); # sqlFillFactor.value(str2int(value)); # # value = this.setControl(sqlEnablePadIndex, sqlEnablePadIndex, #Index, 0, 0, 0, #parmPadIndex); # sqlEnablePadIndex.value(str2int(value)); # # if(isDataCompressionSupported && !isTempTable) # { # value = this.setControl(sqlEnableCompression, sqlCompressionSelection, #Index, 0, 0, 0, #parmCompression, true); # sqlCompressionSelection.selection(str2int(value)); # //this.setDataCompressionControls(); # } # // Add MAXDOP - start # value = this.setControl(sqlEnableMaxDop, sqlMaxDop, #index, 0, 0, 0, #parmMaxDop, true); # sqlMaxDop.value(str2int(value)); # // Add MAXDOP - end # # break; # case #allIndexesForSingleTable: # this.enableIndexControls(true); # # value = this.setControl(sqlEnableSortInTempDB, sqlEnableSortInTempDB, #Index, setupHelper.oldTableId(), 0, 0, #parmSortInTempDb); # sqlEnableSortInTempDB.value(str2int(value)); # # value = this.setControl(sqlEnableFillFactor, sqlFillFactor, #Index, setupHelper.oldTableId(), 0, 0, #parmFillFactor, true); # sqlFillFactor.value(str2int(value)); # # value = this.setControl(sqlEnablePadIndex, sqlEnablePadIndex, #Index, setupHelper.oldTableId(), 0, 0, #parmPadIndex); # sqlEnablePadIndex.value(str2int(value)); # # if(isDataCompressionSupported && !isTempTable) # { # value = this.setControl(sqlEnableCompression, sqlCompressionSelection, #Index, setupHelper.oldTableId(), 0, 0, #parmCompression, true); # sqlCompressionSelection.selection(str2int(value)); # //sqlCompressionSelection.modified(); # //this.setDataCompressionControls(); # } # break; # case #singleIndexForSingleTable: # this.enableIndexControls(true); # # value = this.setControl(sqlEnableSortInTempDB, sqlEnableSortInTempDB, #Index, setupHelper.oldTableId(), setupHelper.oldIndexId(), 0, #parmSortInTempDb); # sqlEnableSortInTempDB.value(str2int(value)); # # value = this.setControl(sqlEnableFillFactor, sqlFillFactor, #Index, setupHelper.oldTableId(), setupHelper.oldIndexId(), 0, #parmFillFactor, true); # sqlFillFactor.value(str2int(value)); # # value = this.setControl(sqlEnablePadIndex, sqlEnablePadIndex, #Index, setupHelper.oldTableId(), setupHelper.oldIndexId(), 0, #parmPadIndex); # sqlEnablePadIndex.value(str2int(value)); # # if(isDataCompressionSupported && !isTempTable) # { # value = this.setControl(sqlEnableCompression, sqlCompressionSelection, #Index, setupHelper.oldTableId(), setupHelper.oldIndexId(), 0, #parmCompression, true); # sqlCompressionSelection.selection(str2int(value)); # //sqlCompressionSelection.modified(); # } # break; # } # this.redraw(); #} ENDSOURCE ENDMETHODS OBJECTBANK PROPERTIES ENDPROPERTIES ENDOBJECTBANK REFERENCEDATASOURCES ENDREFERENCEDATASOURCES JOINS ENDJOINS PARTREFERENCES ENDPARTREFERENCES DESIGN PROPERTIES Left #27 Caption #@SYS335945 Frame #Dialog HideToolbar #Yes StatusBarStyle #Simple ENDPROPERTIES CONTAINER CONTROL BUTTONGROUP PROPERTIES Name #ButtonGroup Left #Auto (left) ElementPosition #1610612733 HierarchyParent #Group ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL GROUP PROPERTIES Name #Group ElementPosition #715827882 FrameType #None Columns #2 ArrangeGuide ARRAY INDEX Columns #0 #0 ENDARRAY ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL GROUP PROPERTIES Name #gSelection AutoDeclaration #Yes Width #Column width ElementPosition #858993458 HierarchyParent #MainGroup Caption #@SYS55767 Columns #2 ArrangeGuide ARRAY INDEX Columns #0 #0 ENDARRAY ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL GROUP PROPERTIES Name #MainGroup Width #Column width ElementPosition #1073741822 HierarchyParent #Group FrameType #None ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL GROUP PROPERTIES Name #sqlCompressionGroup ElementPosition #1342177275 HierarchyParent #SqlServerGroup FrameType #None Columns #5 ArrangeGuide ARRAY INDEX Columns #0 #0 #0 #0 #0 ENDARRAY ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL GROUP PROPERTIES Name #SqlServerGroup AutoDeclaration #Yes ElementPosition #1431655764 HierarchyParent #tabSQLServer Caption #@SYS60109 Columns #2 ArrangeGuide ARRAY INDEX Columns #0 #0 ENDARRAY ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL TAB PROPERTIES Name #sqlTabs AutoDeclaration #Yes ElementPosition #1717986916 HierarchyParent #MainGroup Tabs #2 ShowTabs #No ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL TABPAGE PROPERTIES Name #tabSQLServer AutoDeclaration #Yes ElementPosition #1610612733 HierarchyParent #sqlTabs Caption #@SYS60105 LeftMargin #0 Columns #2 ArrangeGuide ARRAY INDEX Columns #0 #0 ENDARRAY ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL BUTTON PROPERTIES Name #saveValues AutoDeclaration #Yes HelpText #@SYS12229 ElementPosition #1431655764 HierarchyParent #ButtonGroup Text #@SYS12229 ShowShortCut #No ENDPROPERTIES METHODS SOURCE #clicked #void clicked() #{ # element.save(); #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL CHECKBOX PROPERTIES Name #sqlEnableCompression AutoDeclaration #Yes ElementPosition #536870910 HierarchyParent #SqlServerGroup Label #@SYS335946 ENDPROPERTIES METHODS SOURCE #clicked #void clicked() #{ # super(); # element.setDataCompressionControls(); #} ENDSOURCE SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate(true); # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL CHECKBOX PROPERTIES Name #sqlEnableFillFactor AutoDeclaration #Yes ElementPosition #805306365 HierarchyParent #SqlServerGroup Label #@SYS335947 ENDPROPERTIES METHODS SOURCE #clicked #void clicked() #{ # super(); # sqlFillFactor.enabled(this.value()); # element.redraw(); #} ENDSOURCE SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # modified = true; # # if(!this.value()) # { # sqlFillFactor.value(0); # sqlFillFactor.modified(); # } # else # { # element.evaluate(); # } # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL CHECKBOX PROPERTIES Name #sqlEnableMaxDop AutoDeclaration #Yes ElementPosition #1207959547 HierarchyParent #SqlServerGroup Label #Enable MaxDop ENDPROPERTIES METHODS SOURCE #clicked #public void clicked() #{ # super(); # sqlMaxDop.enabled(this.value()); # element.redraw(); #} ENDSOURCE SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # modified = true; # # if (!this.value()) # { # sqlMaxDop.value(1); # sqlMaxDop.modified(); # } # else # { # element.evaluate(); # } # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL CHECKBOX PROPERTIES Name #sqlEnablePadIndex AutoDeclaration #Yes ElementPosition #1073741820 HierarchyParent #SqlServerGroup Label #@SYS335948 ENDPROPERTIES METHODS SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate( true ); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL CHECKBOX PROPERTIES Name #sqlEnableSortInTempDB AutoDeclaration #Yes ElementPosition #1879048185 HierarchyParent #SqlServerGroup Label #@SYS335949 ENDPROPERTIES METHODS SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate( true ); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL COMBOBOX PROPERTIES Name #indexList AutoDeclaration #Yes Width #Column width ElementPosition #1717986916 HierarchyParent #gSelection Label #@SYS1074 ComboType #List ENDPROPERTIES METHODS SOURCE #selectionChange #int selectionChange() #{ # int ret; # # ret = super(); # element.save(); # # setupHelper.oldIndexId(indexName2id(setupHelper.oldTableId(), indexList.getText(indexList.selection()))); # element.setSelection(); # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL COMBOBOX PROPERTIES Name #tableList AutoDeclaration #Yes Width #Column width ElementPosition #1288490187 HierarchyParent #gSelection Label #@SYS40151 ComboType #List ENDPROPERTIES METHODS SOURCE #selectionChange #int selectionChange() #{ # int ret; # # ret = super(); # element.save(); # # setupHelper.oldTableId(tableName2id(tableList.getText(tableList.selection()))); # setupHelper.oldIndexId(indexName2id(setupHelper.oldTableId(), indexList.getText(indexList.selection()))); # # element.setSelection(); # element.fillIndexes(setupHelper.oldTableId()); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL INTEDIT PROPERTIES Name #sqlFillFactor AutoDeclaration #Yes ElementPosition #1610612730 HierarchyParent #SqlServerGroup Label #@SYS26268 ENDPROPERTIES METHODS SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate( true ); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL INTEDIT PROPERTIES Name #sqlMaxDop AutoDeclaration #Yes ElementPosition #2013265915 HierarchyParent #SqlServerGroup Label #MaxDop ENDPROPERTIES METHODS SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate( true ); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL RADIOBUTTON PROPERTIES Name #selection AutoDeclaration #Yes ElementPosition #858993458 HierarchyParent #gSelection DisplayLength #0 Text ARRAY INDEX Items #@SYS55753 #@SYS55756 #@SYS55755 #@SYS55752 #@SYS55754 ENDARRAY Item #5 Items #5 ENDPROPERTIES METHODS SOURCE #selectionChange #int selectionChange() #{ # int ret = 0; # ret = super(); # # element.save(); # setupHelper.typeSelection(selection.selection()); # element.setSelection(); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL RADIOBUTTON PROPERTIES Name #sqlCompressionSelection AutoDeclaration #Yes ElementPosition #1610612733 HierarchyParent #sqlCompressionGroup Text ARRAY INDEX Items #@SYS80100 #@SYS342950 #@SYS1647 ENDARRAY Item #3 Items #3 Columns #3 FrameType #None ENDPROPERTIES METHODS SOURCE #modified #boolean modified() #{ # boolean ret; # # ret = super(); # element.evaluate( true ); # # return ret; #} ENDSOURCE ENDMETHODS ENDCONTROL CONTROL STATICTEXT PROPERTIES Name #sqlCompressionText AutoDeclaration #Yes ElementPosition #1073741822 HierarchyParent #sqlCompressionGroup Text #@SYS335950 ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL STRINGEDIT PROPERTIES Name #sqlText AutoDeclaration #Yes AllowEdit #No Width #Column width ElementPosition #1431655764 MultiLine #Yes ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL CONTROL STRINGEDIT PROPERTIES Name #sTableIndexName AutoDeclaration #Yes Visible #No AllowEdit #No Width #Column width ElementPosition #1288490187 HierarchyParent #MainGroup Label #@SYS60104 ENDPROPERTIES METHODS ENDMETHODS ENDCONTROL ENDCONTAINER ENDDESIGN PERMISSIONS #Permissions PROPERTIES ENDPROPERTIES PERMISSIONSET #Read PROPERTIES ENDPROPERTIES FORM #Controls ENDFORM TABLES #Tables ENDTABLES SERVERMETHODS #Server Methods ENDSERVERMETHODS ASSOCIATEDFORMS #Associated Forms ENDASSOCIATEDFORMS ENDPERMISSIONSET PERMISSIONSET #Update PROPERTIES ENDPROPERTIES FORM #Controls ENDFORM TABLES #Tables ENDTABLES SERVERMETHODS #Server Methods ENDSERVERMETHODS ASSOCIATEDFORMS #Associated Forms ENDASSOCIATEDFORMS ENDPERMISSIONSET PERMISSIONSET #Create PROPERTIES ENDPROPERTIES FORM #Controls ENDFORM TABLES #Tables ENDTABLES SERVERMETHODS #Server Methods ENDSERVERMETHODS ASSOCIATEDFORMS #Associated Forms ENDASSOCIATEDFORMS ENDPERMISSIONSET PERMISSIONSET #Delete PROPERTIES ENDPROPERTIES FORM #Controls ENDFORM TABLES #Tables ENDTABLES SERVERMETHODS #Server Methods ENDSERVERMETHODS ASSOCIATEDFORMS #Associated Forms ENDASSOCIATEDFORMS ENDPERMISSIONSET ENDPERMISSIONS ENDFORM ***Element: PRN ; Microsoft Dynamics AX Project : SysSqlSetup_MaxDop unloaded ; -------------------------------------------------------------------------------- PROJECTVERSION 2 PROJECT #SysSqlSetup_MaxDop SHARED PROPERTIES Name #SysSqlSetup_MaxDop Origin #{D064ED90-065F-4471-A3C4-49F5ADC40B94} ENDPROPERTIES PROJECTCLASS ProjectNode GROUP #Macros PROPERTIES Name #Macros ProjectGroupType #Macros GroupMask # PreventEditProperties #No ENDPROPERTIES BEGINNODE FILETYPE 0 UTILTYPE 4 UTILOBJECTID 0 NODETYPE 218 NAME #SysSqlSetup ENDNODE ENDGROUP GROUP #Forms PROPERTIES Name #Forms ProjectGroupType #Forms GroupMask # PreventEditProperties #No ENDPROPERTIES BEGINNODE FILETYPE 0 UTILTYPE 11 UTILOBJECTID 0 NODETYPE 201 NAME #SysSqlSetup ENDNODE ENDGROUP ENDPROJECT ***Element: END