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