project BLF > class Database Component > method DataLoad

Description

Load data from the database into the class temp-tables of the business class.
Records can be selected based on primary keys (full or partly), rowids or identity values.


Parameters


icRowidsinputcharacterComma seperated list of rowids of records of the main table, converted to string format.
icPkeysinputcharacterList of the values of the primary key fields of records of the main table.
Fields are chr(2) seperated, keys are chr(4) seperated.
Fields are listed in the order as they appear in the primary index. You are not obliged to give a value for all fields of the primary index, but the list cannot contain any 'gaps'.
icObjectIdsinputcharacterComma seperated list of values of the identity field of records of the main table.
icFreeforminputcharacterIn case none of the standard keys (primary, rowid, identity) are available, you can load data based on a freeform for each statement on the main table of the business class.
This for each statement should not contain break by, sorting or no-lock options.
ilKeepPreviousinputlogicalTrue if the data to load must be added to the already existing data in the class temp-tables.
False if the data to load must replace the already existing data.
oiReturnStatusoutputinteger


Internal usage


BLF
method database.apiDeleteInstance
method database.ApiDumpXmlRepresentation
method database.ApiDumpXmlRepresentationV01
method database.ApiForcePublish
method BBaseDaemon.ApiValidateStatus
method BBaseDaemon.ControlDaemon
method BBaseDaemonQueue.ApiResetDaemonQueueStatus
method BBaseDaemonQueue.LockWorkItem
method BBaseDaemonQueue.SetWorkResult
method BBusinessComponent.ApiSynchronise
method BBusinessComponent.ApiSynchroniseDefaultActivities
method BBusinessComponent.DataLoadByInput
method BCompany.ApiSynchronise
method BCompany.SynchronizeSharedSet
method BControlProperty.apiExportFactoryDefaults
method BControlProperty.ApiReadCustomizationV01
method BControlProperty.DataLoadByInput
method BControlProperty.RemoveCustomFieldFromUI
method BCorrLog.ConfirmReported
method BCustomField.ApiExportCustomFields
method BCustomField.DataLoadByInput
method BDocumentLink.ApiDumpDocuments
method BDocumentLink.CopyObjectsDocuments
method BDocumentLink.DumpDocument
method BDocumentLink.StoreDocument
method BDomain.SetDomainTypeAsSystem
method BDomain.SetPrimaryCompany
method BDomain.SynchronizeSharedSet
method BDraftInstance.apiDeleteDraftByTransactionID
method BEventDaemon.ApiUpdate
method BEventDaemonQueue.GetDocument
method BFcSession.DeleteFcSessionRecord
method BFcSession.UpdateFcSessionRecord
method BFcTranslation.LoadResourceFile
method BFieldSecurity.DataLoadFieldSecurityRules
method BLanguage.ApiSynchronise
method BNumber.ActivateSequence
method BNumber.ApiPrepareReleasedNumbers
method BNumber.ApiSetFreeNumbers
method BNumber.DeActivateSequence
method BObjectSecurity.DataLoadObjectSecurity
method BPrinter.apiRefreshInfo
method BQueryCache.ApiDeleteQuery
method BQueryCache.RunQuery
method BReportDaemon.UpdateSocketInformation
method BReportDaemonQueue.UpdateQueue
method BReportRequest.apiGetRequest
method BReportTranslation.apiSynchronise
method BReportVariant.apiExportCustomization
method BReportVariant.apiExportFactoryDefaults
method BReportVariant.apiGetVariant
method BReportVariant.ApiGetVariantInformation
method BReportVariant.DataLoadByInput
method BReportVariant.SetReportCBF
method BResource.ApiLinkResource
method BResource.ApiSetResourceCategories
method BResource.CreateResource
method BResource.DataLoadByInput
method BResource.GetReportCBF
method BRole.ApiExportRoles
method BRole.CreateRolResource
method BRole.DataLoadByInput
method BScanDaemon.ApiUpdateDaemonConfiguration
method BSetting.ApiUpdateSetting
method BSetting.CreateSystemSettings
method BSetting.DataLoadCompany
method BSetting.DataLoadDomain
method BSetting.DataLoadSystem
method BSetting.DataLoadUser
method BSettingConfiguration.apiSynchronise
method BSharedSet.ApiSynchronise
method BSharedSetType.ApiSynchronise
method BSODCategory.ApiCreateCategories
method BSODCategory.DataLoadByInput
method BSODCategoryExclusion.ApiGetMatrixData
method BSODCategoryExclusion.ApiSetMatrixData
method BSODCategoryExclusion.DataLoadByInput
method BSODLog.ApiArchive
method BSODPolicyException.DataLoadByInput
method BSODViolationRule1.CheckRule1
method BSODViolationRule1.DeleteByRoleResource
method BSODViolationRule1.DeleteBySODCategoryExclusion
method BSODViolationRule2.CheckRule2
method BSODViolationRule2.DeleteByDomain
method BSODViolationRule2.DeleteByRoleResource
method BSODViolationRule2.DeleteByUserRoleCompanyCategory
method BStoredSearch.ApiExportCustomization
method BStoredSearch.apiExportFactoryDefaults
method BStoredSearch.apiGetLookupInformation
method BStoredSearch.apiGetStoredSearch
method BStoredSearch.apiSaveStoredSearch
method BStoredSearch.ApiSetStoredSearchDeletion
method BStoredSearch.CreateAndDeleteStoredSearches
method BStoredSearch.DataLoadByInput
method BSystem.ActivateSOD
method BTranslation.ApiSetTranslation
method BTranslation.DataLoadByParent
method BTranslation.DataLoadNewByParent
method BUDCConfiguration.apiExportCustomization
method BUDCConfiguration.DataLoadByInput
method BUser.ApiDumpUserInXml
method BUser.ApiSaveUserDomainEntityAccess
method BUser.ApiSynchronise
method BUser.DataLoadByInput
method BUser.LinkCompanyToDaemonUsers
method BUserRole.ApiSaveUserMembership
method BUserRole.ApiSynchronise
method BUserRole.DataLoadByInput
method BUserRole.DataLoadForForm
method BUserRole.UpdateUsrRoleFromUserMnt
method BWorkClass.ApiUpdate
method BWorkObject.CreateOrUpdateWorkObject
method BWorkObject.DataLoadByObjectID
method BWorkObject.DeleteWorkObjectScopeHolders
method BXmlDaemon.ApiSynchronise
method BXmlDaemon.ApiUpdate
method BXmlDaemonQueue.ApiClearQueue
method BXmlDaemonQueue.GetDocument
method Session.GetWorkAssistantObjects
method BRole.ApiMaintainRolesForModuleURI
method BFcTranslation.ApiSaveFcTranslation

QadFinancials
method BAcctIFFilters.ApiUpdateAcctIFFilter
method BAcctIFFilters.GetFilter
method BAddressType.ApiStdMaintainTT
method BAddressType.ApiSynchronise
method BAddressType.DumpAddressTypeForConsolid
method BAllocationBatch.ExecuteAllocationBatch
method BAltCOAGroup.DataLoadByInput
method BAltCOAStruct.DataLoadByInput
method BAPMatching.CancelAPMatching
method BAPMatching.CopyIntoNew
method BAPMatching.LoadMatchingPosting
method BApproveStatusTransition.LoadApproveStatusTransition
method BBankAccountFormat.ApiSynchronise
method BBankBranch.DataLoadByInput
method BBankEntry.AddBankEntryHeader
method BBankEntry.ApiCreateBankEntryFromImport
method BBankEntry.ApiStdMaintainTT
method BBankEntry.DataLoadByInput
method BBankEntry.LoadBEPosting
method BBankImportLine.SaveAndProcess
method BBankNumber.ApiDumpBankNumberInXml
method BBankNumber.ApiStdMaintainTT
method BBankNumber.ChangeDefaultBankNumber
method BBankNumber.CreateBankNumberAsCopy
method BBankNumber.CreateBankNumberAsCopyCreditorDebtor
method BBankNumber.CreateCDBankNumberAsCopy
method BBankNumber.DataLoadByInput
method BBankNumber.SetBankNumber
method BBankNumber.SetBankNumberPayCode
method BBankNumber.ValidateComponentIsDefault
method BBankPayFormat.DataLoadMultiple
method BBankPayFormat.UpdateBankPayFormatNbr
method BBill.ChangeBillStatus
method BBill.ConfirmPrint
method BBLWICountry.ApiStdMaintainTT
method BBLWICountry.DumpBLWICountryForConsolid
method BBudget.ApiCopyBudget
method BBudget.DataLoadActiveOnly
method BBudgetGroup.DataLoadByInput
method BBudgetLink.ApiCreateOrUpdateBudgetLink
method BBudgetLink.DeleteBudgetLinkByBudgetID
method BBudgetLinkAcc.ApiCreateOrUpdateBudgetLinkAcc
method BBudgetLinkAcc.DeleteBudgetLinkAccByBudgetID
method BBudgetLinkAccDet.ApiCreateOrUpdateBudgetLinkAccDet
method BBudgetLinkAccDet.DeleteBudgetLinkAccDetByBudgetID
method BBudgetLinkActual.ApiCreateBudgetLinkActual
method BBudgetLinkActual.ApiUpdateBudgetLinkActualRep
method BBudgetLinkActual.DeleteBudgetLinkActualByBudgetID
method BBudgetLinkCommitment.ApiCreateBudgetLinkCommit
method BBudgetLinkCommitment.DeleteBudgetLinkCommitByBudgetID
method BBusinessRelation.ApiLoadSingleBusinessRelation
method BBusinessRelation.ApiMaintainAddressForEI
method BBusinessRelation.ApiStdMaintainTT
method BBusinessRelation.ApiStdMaintainTTExtended
method BBusinessRelation.CreateRemittanceAddress
method BBusinessRelation.DataLoadByInput
method BBusinessRelation.DataLoadByInputSampleCode
method BBusinessRelation.DataLoadOnlyAddressId
method BBusinessRelation.DataLoadOnlyFinanceAddress
method BBusinessRelation.DumpBusinessRelationForConsolid
method BBusinessRelation.MaintainAddressMulti
method BCashGroup.DataLoadByInput
method BCCollection.UpdateCCollection
method BCDocument.ApiSetCDocumentStatusChange
method BCDocument.ApiUpdateCDocumentPrint
method BCDocument.BouncePayments
method BCDocument.ChangeStatus
method BCDocument.CreateVoidedDocument
method BCDocument.DataLoadByInput
method BCDocument.PayOrBounceCDocuments
method BCInvoice.AddCInvoicePO
method BCInvoice.AllocateCInvoices
method BCInvoice.ApiGetIdentification
method BCInvoice.CopyIntoNew
method BCInvoice.CreateCInvoiceMovements
method BCInvoice.LoadCIAndMFPosting
method BCInvoice.ReplaceCInvoice
method BCInvoice.ReplaceCInvoicePosting
method BCInvoice.ReverseCInvoice
method BCInvoice.ReverseCInvoicePosting
method BCInvoice.UpdateCInvoiceBank
method BCInvoice.UpdateCInvoiceBankNumber
method BCInvoice.UpdateCInvoiceFromAPM
method BCInvoice.UpdateCInvoiceIsSelected
method BCInvoice.UpdateCInvoiceVat
method BCInvoice.UpdateCInvoiceVatDelay
method BCMask.Copy
method BCMask.DataLoadByInput
method BCOACrossRef.DataLoadByInput
method BCOAMaskCC.DataLoadByInput
method BCOAMaskDiv.DataLoadByInput
method BCOAMaskProj.DataLoadByInput
method BCompany.ApiReplicateFromDaemon
method BCompany.ApiStdMaintainTT
method BCompany.DataLoadByInput
method BCompany.SharedSetSynchronise
method BCompanyGroup.DataLoadByInput
method BCompanyProperty.ReplicateCompanyFromDomain
method BCompanyProperty.SwitchPrimaryCompany
method BCompanyProperty.UpdateCompanyProperty
method BConCheck.ConCheckExecute
method BConCheck.ModifyConCheck
method BConCheck.UpdateConCheckToDate
method BConsolidPeriodXref.ApiSetConsolidPeriods
method BCorporateGroup.DataLoadByInput
method BCostCentre.ApiReplicateFromDaemon
method BCostCentre.ApiStdMaintainTT
method BCostCentre.DataLoadByInput
method BCostCentre.DumpCostCentreForConsolid
method BCountry.ApiStdMaintainTT
method BCountry.DataLoadByInput
method BCountry.DumpCountryForConsolid
method BCounty.ApiStdMaintainTT
method BCounty.DataLoadByInput
method BCPay.UpdateCPay
method BCreditor.ApiDumpCreditorInXml
method BCreditor.ApiReplicateFromDaemon
method BCreditor.ApiStdMaintainTTV01
method BCreditor.DataLoadByInput
method BCreditorBalance.RebuildHistory
method BCreditorBalance.UpdateCBalanceAndCHist
method BCreditorType.DataLoadByInput
method BCurrency.ApiStdMaintainTT
method BCurrency.DataLoadByInput
method BCurrency.DumpCurrencyForConsolid
method BCurrency.UpdateNumberOfDecimals
method BDCollection.UpdateDCollection
method BDDocument.ApiSetDDocumentStatusChange
method BDDocument.ChangeStatus
method BDDocument.CreateDDocumentHeader
method BDDocument.DataLoadByInput
method BDDocument.PayOrBounceDDocuments
method BDDocument.UpdateDDocument
method BDebtor.ApiCheckCreditLimit
method BDebtor.ApiDumpDebtorInXml
method BDebtor.ApiExtractHighCreditInfo
method BDebtor.ApiGetDebtorCreditStatus
method BDebtor.ApiGetDebtorLastSale
method BDebtor.ApiGetFixedCreditLimit
method BDebtor.ApiGetOpenOrdersTotal
method BDebtor.ApiGetTurnoverCreditLimit
method BDebtor.ApiReplicateFromDaemon
method BDebtor.ApiStdMaintainTT
method BDebtor.ApiUpdateDebtorHighCreditInfo
method BDebtor.ApiUpdateDebtorPaymentSales
method BDebtor.DataLoadByInput
method BDebtorBalance.RebuildHistory
method BDebtorBalance.UpdateDBalanceAndDHist
method BDebtorCreditRating.DataLoadByInput
method BDebtorEndUser.ApiDeleteEndUserForDebtor
method BDebtorEndUser.ApiReplicateFromDaemon
method BDebtorEndUser.ApiStdMaintainTT
method BDebtorEndUser.DataLoadByInput
method BDebtorEndUser.ValidateComponentUpdateAllSharedEndusers
method BDebtorShipTo.ApiDeleteShiptoForDebtor
method BDebtorShipTo.ApiMaintainDebtorShipto
method BDebtorShipTo.ApiReplicateFromDaemon
method BDebtorShipTo.DataLoadByInput
method BDebtorShipTo.ValidateComponentUpdateAllSharedShiptos
method BDebtorType.DataLoadByInput
method BDeductionCat.DataLoadByInput
method BDInvoice.AdditionalUpdatesAllCreateDALinkedDI
method BDInvoice.ApiSetDeductionStatus
method BDInvoice.AutoPopulateInvoiceStage
method BDInvoice.CreateDInvoiceMovements
method BDInvoice.CreateDInvoicesFinChargeSub
method BDInvoice.LoadCInvoiceForNewBankAPI
method BDInvoice.LoadDIPosting
method BDInvoice.UpdateDeductionDetail
method BDInvoice.UpdateDeductionForBouncedDDoc
method BDInvoice.UpdateDInvoiceBank
method BDInvoice.UpdateDInvoiceBankNumber
method BDInvoice.UpdateDInvoiceDeductionStatus
method BDInvoice.UpdateDInvoiceDueDate
method BDInvoice.UpdateDInvoiceIsSelected
method BDInvoice.UpdateDInvoiceOpInfo
method BDInvoice.UpdateDInvoiceReminderCount
method BDInvoice.UpdateDInvoiceReminderCountV01
method BDInvoice.UpdateDInvoiceVat
method BDivision.ApiReplicateFromDaemon
method BDivision.ApiStdMaintainTT
method BDivision.DataLoadByInput
method BDivision.DumpDivisionForConsolid
method BDomain.ApiSynchronise
method BDomain.DataLoadByInput
method BDomain.UpdateSharedSet
method BDomainProperty.UpdateDomainProperty
method BDPaymentSelection.DeleteDPaySelLine
method BDPaymentSelection.RemoveEmptyPaySel
method BDPaymentSelection.SetDPaySel
method BDPaymentSelection.SetDPaySelPayCode
method BDPaymentSelection.StoreBankReference
method BDPaymentSelection.StoreSelectedObjects
method BEmployee.ApiReplicateFromDaemon
method BEmployee.DataLoadByInput
method BERS.ModifyERS
method BExchangeRate.ApiReplicateFromDaemon
method BExchangeRate.ApiStdMaintainTT
method BExchangeRate.DataLoadByInput
method BExchangeRate.PreValidateComponentDateTill
method BExchangeRateType.ApiSynchronise
method BExchangeRateType.DataLoadByInput
method BExchangeRateType.UpdateExchangeRateType
method BExpenseGLMatrix.ApiSetExpenseGLMatrix
method BFixedAssetAsset.ApiStdMaintainTT
method BFixedAssetAsset.CapitalizeAsset
method BFixedAssetAsset.DisposeFAAssetBook
method BFixedAssetAsset.RevalFAAssetBook
method BFixedAssetAsset.UpdateFAAssetBook
method BFixedAssetCapital.ApiStdMaintainStatus
method BFRWAnalysisCode.UpdateFRWAnCode
method BFRWTreeView.AdditionalUpdates
method BFRWTreeView.GetFRWTreeViewBalance
method BFRWTreeView.UpdateFRWTreeNodeId
method BGL.ApiReplicateFromDaemon
method BGL.ApiStdMaintainTT
method BGL.DataLoadByInput
method BGL.DumpGLForConsolid
method BGLCalendar.DataLoadByInput
method BGLCalendar.DataLoadMultiple
method BGLMask.ApiGetGLMasks
method BGLMask.ApiSetGLMasks
method BGLMask.ApiStdMaintainTT
method BGLMask.DataLoadByInput
method BGLOpenItem.CreateUpdateGLOpenItemMov
method BGLSystemType.ApiSynchronise
method BGLSystemType.SynchronizeGLSystemType
method BGLType.ApiSynchronise
method BGrossIncomeAccounting.DataLoadByInput
method BJournal.ApiGenerateInitialJournals
method BJournal.ApiReplicateFromDaemon
method BJournal.ApiStdMaintainTT
method BJournal.DataLoadByInput
method BJournal.DumpJournalForConsolid
method BPosting.ApiDumpPostingInXML
method BPosting.ApiMassReversePeriodicCostingPostings
method BPosting.DataLoadByInput
method BPosting.DataLoadMirrorPosting
method BPosting.GetPostingRowidBasedOnPostingID
method BPosting.MassDeletePeriodicCostingPostings
method BPosting.MassReversePeriodicCostingPostings
method BPosting.ValidateComponentReversingPostingDelete
method BPosting.ValidateComponentReversingPostingModifyOriginal
method BPosting.ValidateComponentReversingPostingModifyReversing
method BJournalEntry.ApiUpdateJournal
method BJournalEntry.CreateRecEntryPostingTemplate
method BJournalEntry.CreateReverseEntries
method BJournalEntry.DumpJEDetForConsolid
method BJournalEntry.LoadTemplate
method BJournalGroup.DataLoadByInput
method BJournalType.ApiSynchronise
method BLanguage.DataLoadByInput
method BLayer.ApiGenerateInitialLayers
method BLayer.ApiStdMaintainTT
method BLayer.DataLoadByInput
method BLayer.DumpLayerForConsolid
method BMfgAccount.ApiReplicateFromFinancials
method BMfgAccount.DeleteRoleFromCanRun
method BMfgAccount.LoadMfgData
method BMfgAccountDefaultMaster.LoadMfgData
method BMfgAccountPayableCtrl.GetNextBatchNumber
method BMfgAcctSubCCProj.ApiReplicateFromFinancials
method BMfgAcctSubCCProj.LoadMfgData
method BMfgAddress.ApiReplicateFromFinancialsBusRel
method BMfgAddress.ApiReplicateFromFinancialsCreditor
method BMfgAddress.ApiReplicateFromFinancialsDebtor
method BMfgAddress.ApiReplicateFromFinancialsEndUSer
method BMfgAddress.ApiReplicateFromFinancialsShipTo
method BMfgAddress.DeleteDockAddressesForCustomer
method BMfgAddress.LoadMfgData
method BMfgAddress.ReplicateFromFinancialsShipToDebtorLink
method BMfgAddressListDetail.ApiReplicateFromFinancialsCreditor
method BMfgAddressListDetail.ApiReplicateFromFinancialsDebtor
method BMfgAddressListDetail.ApiReplicateFromFinancialsEndUser
method BMfgAddressListDetail.ApiReplicateFromFinancialsShipTo
method BMfgAddressListDetail.LoadMfgData
method BMfgGeneralizedCode.LoadMfgData
method BMfgComment.DeleteComment
method BMfgControlWorkTable.DeleteRoleFromCanRun
method BMfgCostCenter.ApiReplicateFromFinancials
method BMfgCostCenter.LoadMfgData
method BMfgCountry.LoadMfgData
method BMfgCreditTerms.ApiReplicateFromFinancials
method BMfgCreditTerms.LoadMfgData
method BMfgCreditTermsDetail.LoadMfgData
method BMfgCurrency.LoadMfgData
method BMfgCustomer.ApiReplicateFromFinancials
method BMfgCustomer.LoadMfgData
method BMfgCustomer.UpdateCustomerLanguageSearchName
method BMfgDataEntryProfile.DeleteRoleFromCanRun
method BMfgDaybook.ApiReplicateFromFinancials
method BMfgDaybook.LoadMfgData
method BMfgDomain.LoadMfgData
method BMfgEmployee.ApiReplicateFromFinancials
method BMfgEmployee.LoadMfgData
method BMfgEndUser.ApiReplicateFromFinancials
method BMfgEndUser.LoadMfgData
method BMfgEndUser.MaintainDataBusinessRelation
method BMfgEntity.ApiReplicateFromFinancials
method BMfgEntity.LoadMfgData
method BMfgEntity.SwitchPrimaryEntity
method BMfgExchangeRate.ApiReplicateFromFinancials
method BMfgExchangeRate.LoadMfgData
method BMfgGLCalendar.LoadMfgData
method BMfgInventoryMovSite.DeleteRoleFromCanRun
method BMfgLanguage.LoadMfgData
method BMfgLocation.LoadLocation
method BMfgLocationDet.LoadLocationDet
method BMfgMenu.DeleteMenuFromResource
method BMfgNRM.ApiReplicateFromFinancials
method BMfgNRM.LoadMfgData
method BMfgPendingVoucher.UpdatePendingVoucherFromERS
method BMfgPeriod.LoadMfgData
method BMfgProject.ApiReplicateFromFinancials
method BMfgProject.LoadMfgData
method BMfgRole.LoadMfgData
method BMfgRoundingMethod.LoadMfgData
method BMfgSite.DeleteRoleFromCanRun
method BMfgSubAccount.ApiReplicateFromFinancials
method BMfgSubAccount.LoadMfgData
method BMfgSupplier.ApiReplicateFromFinancials
method BMfgSupplier.LoadMfgData
method BMfgSupplier.UpdateSupplierLanguageSearchName
method BMfgSystemAccountControl.LoadMfgData
method BMfgSystemAccountControl.PerformMfgUpdate
method BMfgSystemAccountControl.UpdateRndMthd
method BMfgUserDomainForUser.LoadMfgData
method BMfgUserDomainForUsrRole.LoadMfgData
method BMfgUserRole.LoadMfgData
method BMirroringGL.DataLoadByInput
method BMirroringJournal.DataLoadByInput
method BPaymentCondition.ApiReplicateFromDaemon
method BPaymentCondition.ApiStdMaintainTT
method BPaymentCondition.DataLoadByInput
method BPaymentFormat.ApiExportPaymentFormat
method BPaymentFormat.ApiImportPaymentFormat
method BPaymentFormat.ApiSynchronise
method BPaymentFormat.DataLoadByInput
method BPaymentGroup.DataLoadByInput
method BPaymentSelection.ApiRepetitiveTransferPayments
method BPaymentSelection.APITransferPayments
method BPaymentSelection.BuildProDataSet
method BPaymentSelection.ChangeStatusPaymentSelection
method BPaymentSelection.ChangeStatusPaymentSelInBatch
method BPaymentSelection.GenerateASCII
method BPeriod.ApiActivatePeriodForPeriodicCosting
method BPeriod.ApiDeactivatePeriodForPeriodicCosting
method BPeriod.ApiStdMaintainTT
method BPeriod.ApiUpdatePeriodStatus
method BPeriod.CheckIfDaybookMaskAllowed
method BPeriod.DataLoadByInput
method BPeriod.DataLoadMultiple
method BPeriod.LoadAndUpdateInstanceData
method BPeriod.SynchronizePeriod
method BPeriod.YearClosingClosePeriods
method BPrepayment.UpdatePaySelPrepay
method BProfile.ApiStdMaintainTT
method BProfile.DataLoadByInput
method BProfile.DumpProfileForConsolid
method BProfile.UpdateProfile
method BProfileType.ApiSynchronise
method BProject.ApiReplicateFromDaemon
method BProject.ApiStdMaintainTT
method BProject.DataLoadByInput
method BProject.DumpProjectForConsolid
method BProjectGroup.ApiStdMaintainTT
method BProjectGroup.DataLoadByInput
method BProjectGroup.DumpProjectGroupForConsolid
method BProjectStatus.ApiStdMaintainTT
method BProjectStatus.DataLoadByInput
method BProjectStatus.DumpProjectStatusForConsolid
method BPurchaseType.DataLoadByInput
method BQBudgetActual.ApiDeleteQBudgetLinkActual
method BQBudgetCommitment.ApiDeleteQBudgetLinkCommit
method BQCInvoiceMovement.ApiProcessQCInvoiceMovement
method BQCrossCyPosting.ApiProcessQCrossCyPosting
method BQCrossCyPosting.ApiProcessQCrossCyPostingForReverse
method BQDInvoiceMovement.ApiProcessQDInvoiceMovement
method BQFRWCube.ApiDeleteQFRWCube
method BQPosting.ApiProcessQPostingLineSaf
method BReason.DataLoadByInput
method BRecurringEntry.ApiPostRecEntryCommit
method BRecurringEntry.DataLoadByInput
method BReportPeriod.DataLoadMultiple
method BReportTree.ApiGetChildNodeList
method BReportTree.ApiGetFRWTreeNodeIdByRowId
method BReportTree.ApiIsRootNode
method BReportTree.DataLoadByInput
method BReportTree.LoadGLChartCompletenessCheck
method BReportTree.UpdateReportTreeNodeDesc
method BResource.ApiSynchronizeCustom
method BRevaluation.AdditionalUpdatesPosting
method BRole.AddGenCodeGroupToRoles
method BRoundingMethod.DataLoadByInput
method BSaf.ApiStdMaintainTT
method BSaf.DataLoadByInput
method BSaf.DumpSafForConsolid
method BSafConcept.ApiStdMaintainTT
method BSafConcept.DataLoadByInput
method BSafConcept.DumpSafConceptForConsolid
method BSafStructure.ApiStdMaintainTT
method BSafStructure.DataLoadByInput
method BSafStructure.DumpSafStructureForConsolid
method BSafStructureLink.ApiStdMaintainTT
method BSafStructureLink.DumpSafStructureLinkForConsolid
method BSafStructureLink.UpdateSafStructureLink
method BSharedSet.DataLoadByInput
method BSharedSetMergeLog.LogEndMerge
method BState.ApiStdMaintainTT
method BState.DataLoadByInput
method BSystem.ApiSetSystemPropertiesExtInvCert
method BSystemProperty.SetSystemProperties
method BSystemProperty.SetSystemPropertiesExtInvCert
method BSystemProperty.SynchronisePropertyInvCert
method BTaxRegister.DataLoadByInput
method BTaxRegister.UpdateTaxRegisterFinalPrint
method BVAT.ApiDeleteOfTaxRate
method BVAT.ApiStdMaintainTT
method BVAT.DataLoadByInput
method BVATBox.DataLoadByInput
method BVATGroup.ApiStdMaintainTT
method BVATGroup.DataLoadByInput
method BVATPeriod.APIUpdateVATPeriodStatus
method BVATPeriod.DataLoadByInput
method BVATPeriod.DataLoadMultiple
method BVerifyStatusTransition.LoadVerifyStatusTransition
method BWithholdingTax.CreateAndOrUpdateWHT
method BWithholdingTax.UpdateWHTPrintedStatus
method BYearClosing.ApiStdMaintainTT
method BPayConf.DataLoadPayConf
method BBudget.UpdateBudgetCompanyFromChart
method BAccountingInterface.GetReportList
method BAccountingInterface.ApiUpdateAcctIF
method BBankImportLine.UpdateBankImportLineStatusAndLog
method BFRWColumnGroup.DataLoadByInput
method BFRWReportMaster.DataLoadByInput
method BSharedSetMerge.MergeBeforeMergeGL

QadFitnesse
method BCompanyProperty.ApiUpdateARAPTaxDateProperties
method BCompanyProperty.ApiCompanyUpdate


program code (program1/database.p)

/* ========================================== */
/* Set class-data-item based upon input param */
/* ========================================== */
assign vlDataLoadKeepPrevious = ilKeepPrevious.

/* ============================================================= */
/* Start by clearing the instance when input param requests this */
/* ============================================================= */
if ilKeepPrevious = no
then do:
    /* Empty all generated temp-tables */
    <M-8 run ClearData  (output viFcReturnSuper (oiReturnStatus)) in database>
    if viFcReturnSuper <> 0
    then assign oiReturnStatus = viFcReturnSuper.
    if viFcReturnSuper < 0
    then return.
end. /* if ilKeepPrevious = no */

/* ========================================== */
/* Load the temp-table tFcDynRel              */
/* ========================================== */
<M-79 run DataDescription
   (input  icRowids (icRowids), 
    input  icPkeys (icPkey), 
    input  icObjectIds (icObjectIds), 
    input  no (ilAllTables), 
    output viFcReturnSuper (oiReturnStatus)) in database>
if viFcReturnSuper <> 0
then assign oiReturnStatus = viFcReturnSuper.
if viFcReturnSuper < 0
then return.
if  (icRowids = "" or icRowids = ?)       and 
    (icPkeys = "" or icPkeys = ?)         and 
    (icObjectIds = "" or icObjectIds = ?) and
    icFreeform <> ""                      and 
    icFreeform <> ?
then do:
    find first tFcDynRel where tFcDynRel.tcFcFrom = "" no-error.
    if available tFcDynRel
    then assign tFcDynRel.tcFcRel = icFreeform.
end. /* if  (icRowids = "" or icRowids = ?)       and */

/* =================================== */
/* Load the generated temp-tables t<x> */
/* =================================== */
<M-6 run StartPersistence
   (output vhFcComponent (ohPersistence), 
    output viFcReturnSuper (oiReturnStatus)) in database>
if viFcReturnSuper <> 0
then assign oiReturnStatus = viFcReturnSuper.
if viFcReturnSuper < 0
then return.
<M-7 run ReadData
   (input  tFcDynRel (tDynRel), 
    input  {&TARGETPROCEDURE} (ihClass), 
    output viFcReturnSuper (oiReturnStatus)) in persistence>
if viFcReturnSuper <> 0
then assign oiReturnStatus = viFcReturnSuper.
if viFcReturnSuper < 0
then return.

/* ====================================================================== */
/* Set class-data-item vlFcDataValidated to false as we have now loaded   */
/* (additional) data into the instance and this data is not validated yet */
/* ====================================================================== */
assign vlFcDataValidated = false.

/* ======================== */
/* Execute Calculate method */
/* ======================== */
if not vlDataLoadSkipCalculate
then do :
    <M-5 run Calculate (output viFcReturnSuper (oiReturnStatus)) in database>
    if viFcReturnSuper <> 0
    then assign oiReturnStatus = viFcReturnSuper.
    if viFcReturnSuper < 0
    then return.    
    /* If we are keeping the previously loaded instances then register the rowids of the new read records as passed the calculate-method */
    if ilKeepPrevious
    then do:
        <M-10 run DataDescription
           (input  icRowids (icRowids), 
            input  icPkeys (icPkey), 
            input  icObjectIds (icObjectIds), 
            input  yes (ilAllTables), 
            output viFcReturnSuper (oiReturnStatus)) in database>    
        for each tFcDynRel on error undo, throw:
            create query vhQuery in widget-pool "non-persistent".
            vhQuery:forward-only = yes.
            vhQuery:set-buffers(tFcDynRel.thFcBuffer).
            vhQuery:query-prepare ("for each ":U + tFcDynRel.thFcBuffer:name).
            vhQuery:query-open().
            vhQuery:get-first().
            do while not vhQuery:query-off-end:
                if not can-find (tAlreadyCalculatedRecords where
                                 tAlreadyCalculatedRecords.tcTableName = tFcDynRel.tcFcTo and
                                 tAlreadyCalculatedRecords.tc_Rowid    = tFcDynRel.thFcBuffer::tc_Rowid)
                then do:
                    create tAlreadyCalculatedRecords.
                    assign tAlreadyCalculatedRecords.tcTableName = tFcDynRel.tcFcTo
                           tAlreadyCalculatedRecords.tc_Rowid    = tFcDynRel.thFcBuffer::tc_Rowid.
                end. /* if not can-find */
                vhQuery:get-next().
            end. /* do while not vhQuery:query-off-end: */
            vhQuery:query-close().
            delete object vhQuery.
            assign vhQuery = ?.
        end. /* for each tFcDynRel on error undo, throw: */
    end. /* if ilKeepPrevious */
end. /* if not vlDataLoadSkipCalculate */

finally:
    if vhQuery <> ? 
    then delete object vhQuery.
end finally.