Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: CLS ; Microsoft Business Solutions-Axapta Class: TRG_TempTablesReport unloaded at Sunday 09/01/2005 ; -------------------------------------------------------------------------------- CLSVERSION 1 CLASS #TRG_TempTablesReport PROPERTIES Name #TRG_TempTablesReport Extends #RunBaseReport RunOn #Server ENDPROPERTIES METHODS Version: 3 SOURCE #canGoBatch #public boolean canGoBatch() #{ # return false; #} ENDSOURCE SOURCE #classDeclaration #// RunOn::Server #class TRG_TempTablesReport extends RunBaseReport #{ # TRG_TempTable tempTable; #} ENDSOURCE SOURCE #lastValueElementName #public identifiername lastValueElementName() #{ # return ReportStr(TRG_TempTablesReport); #} ENDSOURCE SOURCE #parmTempTable #public TRG_TempTable parmTempTable(TRG_TempTable tmpNew = tempTable) #{ # tempTable = tmpNew; # return tempTable; #} ENDSOURCE SOURCE #populateTempTable #private void populateTempTable() #{ # ; # # // Insert three records # tempTable.AccountNum = "100"; # tempTable.CurrencyCode = "AUD"; # tempTable.Balance = 1070.00; # tempTable.insert(); # # tempTable.AccountNum = "100"; # tempTable.CurrencyCode = "USD"; # tempTable.Balance = 667.00; # tempTable.insert(); # # tempTable.AccountNum = "100"; # tempTable.CurrencyCode = "EUR"; # tempTable.Balance = 2471.00; # tempTable.insert(); #} ENDSOURCE SOURCE #run #public void run() #{ # ; # this.populateTempTable(); # # super(); #} ENDSOURCE SOURCE #description #static ClassDescription description() #{ # return reportStr(TRG_TempTablesReport); #} ENDSOURCE SOURCE #main #static void main(Args _args) #{ # TRG_TempTablesReport tempTables; # ; # # tempTables = new TRG_TempTablesReport(); # if (tempTables.prompt()) # tempTables.run(); #} ENDSOURCE ENDMETHODS ENDCLASS ***Element: DBT ; Microsoft Business Solutions-Axapta Table : TRG_TempTable unloaded at Sunday 09/01/2005 ; -------------------------------------------------------------------------------- TABLEVERSION 1 TABLE #TRG_TempTable PROPERTIES Name #TRG_TempTable Label # FormRef # TitleField1 # TitleField2 # Temporary #Yes TableContents #Not specified Systemtable #No ConfigurationKey # SecurityKey # MaxAccessMode #Delete CacheLookup #None CreateRecIdIndex #No SaveDataPerCompany #Yes TableGroup #Miscellaneous PrimaryIndex # ClusterIndex # ModifiedDate #No ModifiedTime #No ModifiedBy #No ModifiedTransactionId #No CreatedDate #No CreatedTime #No CreatedBy #No CreatedTransactionId #No ENDPROPERTIES FIELDS FIELD #AccountNum STRING PROPERTIES Type #String Name #AccountNum Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes ConfigurationKey # Table #TRG_TempTable AliasFor # ExtendedDataType ARRAY #AccountNum # ENDARRAY StringSize #15 Adjustment #Right ENDPROPERTIES FIELD #Balance REAL PROPERTIES Type #Real Name #Balance Label #@SYS95 HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes ConfigurationKey # Table #TRG_TempTable AliasFor # ExtendedDataType ARRAY #AmountCur # ENDARRAY FieldUpdate #Absolute ENDPROPERTIES FIELD #CurrencyCode STRING PROPERTIES Type #String Name #CurrencyCode Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes ConfigurationKey # Table #TRG_TempTable AliasFor # ExtendedDataType ARRAY #CurrencyCode # ENDARRAY StringSize #3 Adjustment #Left ENDPROPERTIES ENDFIELDS GROUPS GROUP #AutoReport PROPERTIES Name #AutoReport OldName # Label # ENDPROPERTIES GROUPFIELDS ENDGROUPFIELDS ENDGROUP GROUP #AutoLookup PROPERTIES Name #AutoLookup OldName # Label # ENDPROPERTIES GROUPFIELDS ENDGROUPFIELDS ENDGROUP ENDGROUPS INDICES ENDINDICES REFERENCES ENDREFERENCES DELETEACTIONS ENDDELETEACTIONS METHODS Version: 3 SOURCE #getRowCount #// Doesn't work as the TRG_TempTable reference implicitly creates a new buffer variable, which will have no data. #// #// In actual fact, having non-static (instance) methods on a temporary table is nonsensical as you should always #// pass through the buffer anyway. #public int getRowCount() #{ # return ((select count(recid) from TRG_TempTable).recid); #} ENDSOURCE SOURCE #find #// This declares a NEW temp table buffer "tempTable" which contains NO data. Therefore the 'select' will #// never return anything. #public static TRG_TempTable find(AccountNum _accountNum, CurrencyCode _currencyCode, boolean _forUpdate = false) #{ # TRG_TempTable tempTable; # ; # # if (_accountNum && _currencyCode) # { # tempTable.selectForUpdate(_forUpdate); # select firstonly tempTable # where tempTable.AccountNum == _accountNum # && tempTable.CurrencyCode == _currencyCode; # } # # return tempTable; #} ENDSOURCE SOURCE #findTemp #// Must pass through a buffer to the temporary table that we are using. #public static TRG_TempTable findTemp(AccountNum _accountNum, CurrencyCode _currencyCode, # TRG_TempTable _tempTable, boolean _forUpdate = false) #{ # TRG_TempTable tempTable; # ; # # if (_accountNum && _currencyCode) # { # // Points the local buffer to the same temporary data as _tempTable # tempTable.setTmpData(_tempTable); # # tempTable.selectForUpdate(_forUpdate); # select firstonly tempTable # where tempTable.AccountNum == _accountNum # && tempTable.CurrencyCode == _currencyCode; # } # # return tempTable; #} ENDSOURCE SOURCE #getRowCountTemp #public static int getRowCountTemp(TRG_TempTable _tempTable) #{ # select count(recid) from _tempTable; # return _tempTable.recid; #} ENDSOURCE ENDMETHODS ENDTABLE ***Element: RG ; Microsoft Business Solutions-Axapta Report: TRG_TempTablesReport unloaded at Sunday 09/01/2005 ; -------------------------------------------------------------------------------- VERSION 1 REPORT #TRG_TempTablesReport PROPERTIES Name #TRG_TempTablesReport Interactive #Yes AllowCheck #Yes AutoJoin #No ENDPROPERTIES METHODS Version: 3 SOURCE #fetch #public boolean fetch() #{ # boolean ret; # # if (tempTablesReport) # this.queryRun().setRecord(tempTablesReport.parmTempTable()); # # ret = super(); # # return ret; #} ENDSOURCE SOURCE #init #public void init() #{ # Args args; # ; # # args = element.args(); # if (classIdGet(args.caller()) == classNum(TRG_TempTablesReport)) # { # tempTablesReport = args.caller(); # } # # super(); #} ENDSOURCE SOURCE #classDeclaration #public class ReportRun extends ObjectRun #{ # TRG_TempTablesReport tempTablesReport; #} ENDSOURCE ENDMETHODS QUERY #Query PROPERTIES Name #Query Title # Form #SysQueryForm UserUpdate #Yes Version #5 Literals #Default Interactive #No AllowCheck #No RecordLevelSecurity #Yes NextUniqueId #1001 ENDPROPERTIES METHODS Version: 3 SOURCE #classDeclaration #public class QueryRun extends ObjectRun #{ #} ENDSOURCE ENDMETHODS BLOCKS BLOCK #TRG_TempTable PROPERTIES Name #TRG_TempTable Table #TRG_TempTable UniqueId #1000 Company # FirstOnly #No FirstFast #No AllowAdd #All fields OrderMode #Order by FetchMode #1:n JoinMode #InnerJoin Update #No Relations #No Enabled #Yes ENDPROPERTIES FIELDLIST PROPERTIES Dynamic #Yes ENDPROPERTIES ENDFIELDLIST SORTING ENDSORTING LINES ENDLINES BLOCKS ENDBLOCKS ENDBLOCK ENDBLOCKS ENDQUERY DESIGNS DESIGN PROPERTIES Name #ReportDesign1 AutoDeclaration #No Caption # Description # JobType # EmptyReportPrompt # ArrangeWhen #Auto ColorScheme #RGB ForegroundColor #0 0 0 ResolutionX # ResolutionY # Ruler #Standard ReportTemplate # TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto Language #Auto Font # FontSize # Italic #No Underline #No Bold #Default CharacterSet #0 PrintFormName #SysPrintForm HideBorder #No Orientation #Auto FitToPage #Auto RemoveRepeatedHeaders #No RemoveRepeatedFooters #No RemoveRedundantFooters #No LocalWebMenu # ENDPROPERTIES AUTOBODIES PROPERTIES GrandHeader #No HeaderText # GrandTotal #No FooterText # ENDPROPERTIES ENDAUTOBODIES GENERATEDDESIGN SORTKEY PROPERTIES Name #TRG_TempTable Table #TRG_TempTable DataField # ENDPROPERTIES BODYBLOCK PROPERTIES Name #TRG_TempTable_Body AutoDeclaration #No ControlNumber #1 Top #Auto Bottom #Auto Height #Auto ArrangeWhen #Default ArrangeMethod #Horizontal, flush right Columns #Auto Columnspace #Auto NoOfHeadingLines #Auto ColumnHeadingsStrategy #WordWrap LabelTopMargin #Auto LabelBottomMargin #Auto TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ColorScheme #RGB ForegroundColor #255 255 255 LineAbove #None LineBelow #None LineLeft #None LineRight #None Thickness #Hairline ResolutionX # ResolutionY # Ruler #Standard Font # FontSize # Italic #No Underline #No Bold #Default CharacterSet #0 GrandHeader #No HeaderText # HeaderDetailLevel #Auto GrandTotal #No FooterText # SumDetailLevel #Auto ENDPROPERTIES STRFIELD PROPERTIES Name #TRG_TempTable_AccountNum AutoDeclaration #No Left #Auto (left) Top #Auto Width #Auto Height #Auto DynamicHeight #No TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ModelFieldName # ConfigurationKey # SecurityKey # Label # LabelLineBelow #Solid LabelLineThickness #pt1 ChangeLabelCase #Auto ShowLabel #Yes LabelTabLeader #Auto LabelFont # LabelFontSize # LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 LabelWidth #Auto LabelPosition #Above Visible #Yes MenuItemType #Display MenuItemName # CssClass # LabelCssClass # WebTarget # Table #TRG_TempTable DataField #AccountNum ArrayIndex #0 DataMethod # ColorScheme #RGB BackgroundColor #255 255 255 BackStyle #Opaque ForegroundColor #0 0 0 LineAbove #None LineBelow #None LineLeft #None LineRight #None Thickness #Hairline Font # FontSize # Italic #No Underline #No Bold #Default CharacterSet #0 Alignment #Auto ChangeCase #Auto ExtendedDataType # ENDPROPERTIES ENDSTRFIELD DBLFIELD PROPERTIES Name #TRG_TempTable_Balance AutoDeclaration #No Left #Auto (left) Top #Auto Width #Auto Height #Auto TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ModelFieldName # ConfigurationKey # SecurityKey # Label # LabelLineBelow #Solid LabelLineThickness #pt1 ChangeLabelCase #Auto ShowLabel #Yes LabelTabLeader #Auto LabelFont # LabelFontSize # LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 LabelWidth #Auto LabelPosition #Above Visible #Yes MenuItemType #Display MenuItemName # CssClass # LabelCssClass # WebTarget # Table #TRG_TempTable DataField #Balance ArrayIndex #0 DataMethod # ColorScheme #RGB BackgroundColor #255 255 255 BackStyle #Opaque ForegroundColor #0 0 0 LineAbove #None LineBelow #None LineLeft #None LineRight #None Thickness #Hairline Font # FontSize # Italic #No Underline #No Bold #Default CharacterSet #0 SumAll #No SumPos #No SumNeg #No ExtraSumWidth #Auto Alignment #Auto SignDisplay #Auto RotateSign #Auto ShowZero #Auto DisplaceNegative #Auto AllowNegative #Auto ThousandSeparator #Auto DecimalSeparator #Auto NoOfDecimals #Auto AutoInsSeparator #Auto FormatMST #Auto ExtendedDataType # ENDPROPERTIES ENDDBLFIELD ENDBODYBLOCK ENDSORTKEY ENDGENERATEDDESIGN ENDDESIGN ENDDESIGNS ENDREPORT ***Element: FTM ; Microsoft Business Solutions-Axapta MENUITEM : TRG_TempTablesReport unloaded at Sunday 09/01/2005 ; -------------------------------------------------------------------------------- VERSION 1 MENUITEM #TRG_TempTablesReport Type: 2 PROPERTIES Name #TRG_TempTablesReport Label # HelpText # Class #Class Object #TRG_TempTablesreport Parameters # EnumTypeParameter # EnumParameter # RunOn #Server ConfigurationKey # CountryConfigurationkey # WebConfigurationkey # SecurityKey # NeededAccessLevel #View Web # WebAccess #All WebSecureTransaction #No WebPage # MultiSelect #No ENDPROPERTIES ENDMENUITEM ***Element: PRN ; Microsoft Business Solutions-Axapta Project : TRG_TempTablesReports unloaded at Sunday 09/01/2005 ; -------------------------------------------------------------------------------- PROJECTVERSION 2 PROJECT #TRG_TempTablesReports SHARED PROPERTIES Name #TRG_TempTablesReports ENDPROPERTIES BEGINNODE FILETYPE 0 UTILTYPE 45 UTILOBJECTID 30159 NODETYPE 329 NAME #TRG_TempTablesReport ENDNODE BEGINNODE FILETYPE 0 UTILTYPE 44 UTILOBJECTID 30113 NODETYPE 204 NAME #TRG_TempTable ENDNODE BEGINNODE FILETYPE 0 UTILTYPE 18 UTILOBJECTID 0 NODETYPE 202 NAME #TRG_TempTablesReport ENDNODE BEGINNODE FILETYPE 0 UTILTYPE 2 UTILOBJECTID 0 NODETYPE 296 NAME #TRG_TempTablesReport ENDNODE ENDPROJECT ***Element: END