project BLF > class Database Component > method ValIsActive

validation procedure

Description

On relations to a table with an 'IsActive' field, use this validation mask to check the field and return an error if an object that is not active is referenced.


Parameters


icTargetFieldinputcharacterValue of the business field to validate.
icTargetFieldNameinputcharacterName of the business field to validate.
icRowidinputcharacterContents of field tc_Rowid, if the target field is a field of a component temp-table.
ilIsActiveinputlogicalActive flag
icParentObjectLabelinputcharacterparent object
oiReturnStatusoutputintegerReturn status of the method.


Internal usage


BLF
validation on relation ROLEINWORKOBJECT
validation on relation USRINWORKOBJECTSCOPEHOLDER
validation on relation USRINWORKOBJECT
validation on relation SHAREDSETINWORKOBJECT
validation on relation SHAREDSETINCOMPANYSHAREDSET
validation on relation BUSACTIVITYINCONTROLPROPERTY
validation on relation USRINCORRLOG
validation on relation USRINDOCUMENTLINK
validation on relation BUSCOMPONENTINEVENTCONFIG
validation on relation COMPANYINEVENTCONFIG
validation on relation COMPANYINNUMBR
validation on relation OBJECTSTATUSINOBJECTFLEXSTATUS
validation on relation BUSCOMPONENTINREPORTTRANSLATION
validation on relation REPORTINREPORTTRANSLATIOM
validation on relation BUSCOMPONENTINROLE
validation on relation SHAREDSETTYPEINSHAREDSET
validation on relation USRINSTOREDSEARCH
validation on relation LNGINSYS
validation on relation LNGINTRANSLATIONSTRING
validation on relation DEFAULTLNGINUSR
validation on relation ROLEINUSRROLE
validation on relation USRINUSRROLE
validation on relation BUSACTIVITYONWORKCLASS
validation on relation BUSCOMPONENTINWORKCLASS
validation on relation ROLEINWORKCLASS
validation on relation USRINWORKCLASS
validation on relation BUSCOMPONENTINWORKOBJECT
validation on relation BUSINESSACTIVITYINWORKOBJECT
validation on relation COMPANYINWORKOBJECT

QadFinancials
method BAPMatching.ValReason
method BCInvoice.ValidateComponentPostJournal
method BCInvoice.ValidateComponentPostCAJournal
method BCInvoice.ValidateComponentPostAnalysis
validation on relation COSTCENTREINAPMATCHINGLN
validation on relation DIVISIONINAPMATCHINGLN
validation on relation GLINAPMATCHINGLN
validation on relation COMPANYINBANKSTATE
validation on relation CURRENCYINBANKSTATE
validation on relation GLINBANKSTATE
validation on relation COMPANYINBANKSTATEALLOC
validation on relation CURRENCYINBANKSTATEALLOC
validation on relation COMPANYINBANKSTATEALLOCCOLL
validation on relation COMPANYINBANKSTATELINE
validation on relation BUSINESSRELATIONINBANKNUMBER
validation on relation CREDITORINBANKNUMBER
validation on relation CURRENCYINBANKNUMBER
validation on relation DEBTORINBANKNUMBER
validation on relation GLINBANKNUMBER
validation on relation PAYFORMATCODEINBANKNUMBERPAYCODE
validation on relation COMPANYINBANKSTATEIMPORT
validation on relation USRINBANKSTATEIMPORT
validation on relation EMPLOYEEINBILL
validation on relation COSTCENTREINBUDGET
validation on relation COSTCENTRESHAREDSETINBUDGET
validation on relation CURRENCYINBUDGET
validation on relation DIVISIONSHAREDSETINBUDGET
validation on relation GLSHAREDSETINBUDGET
validation on relation PROJECTSHAREDSETINBUDGET
validation on relation USRINBUDGET
validation on relation COMPANYINBUDGETCOMPONY
validation on relation BUDGETGROUPINBUDGETWBS
validation on relation SAFCONCEPTINBUDGETWBS
validation on relation SAFSTRUCTUREINBUDGETWBS
validation on relation UNITINBUDGETWBS
validation on relation BUSCOMPONENTINBUDGETWBSBUSCOMPONENT
validation on relation ADDRESSTYPEINADDRESS
validation on relation COUNTRYINADDRESS
validation on relation COUNTYINADDRESS
validation on relation LNGINADDRESS
validation on relation STATEINADDRESS
validation on relation LNGINBUSINESSRELATION
validation on relation LNGINCONTACT
validation on relation DIVISIONICASHREPORT
validation on relation USRINCASHREPORT
validation on relation GLININCASHREPORTGL
validation on relation COMPANYINCCOLLECTION
validation on relation GLINCCOLLECTION
validation on relation COMPANYINCDOCUMENT
validation on relation CREDITORINCDOCUMENT
validation on relation CURRENCYINCDOCUMENT
validation on relation GLINCDOCUMENT
validation on relation GLINCDOCUMENTSTATUS
validation on relation BLWIGROUPINCINVOICE
validation on relation CINVOICECURRENCYINCINVOICE
validation on relation COMPANYINCINVOICE
validation on relation CREDITORINCINVOICE
validation on relation DIVISIONINCINVOICE
validation on relation ENDCOUNTRYINCINVOICE
validation on relation NORMALPAYMENTCONDITIONINCINVOICE
validation on relation PURCHASETYPEINCINVOICE
validation on relation REASONINCINVOICE
validation on relation ROLEINCINVOICE
validation on relation STARTCOUNTRYINCINVOICE
validation on relation BANKNUMBERINCINVOICEBANK
validation on relation BUSINESSRELATIONINCOMPANYPROPERTY
validation on relation CURRENCYINCOMPANYPROPERTY
validation on relation UNITINCOMPANYPROPERTY
validation on relation MANAGEMENTJOURNALINCONSOLIDCYCLECOMPANY
validation on relation OFFICIALIJOURNALNCONSOLIDCYCLECOMPANY
validation on relation TRANSIENTJOURNALINCONSOLIDCYCLECOMPANY
validation on relation BUDGETGROUPINCOSTCENTRE
validation on relation DIVISIONPROFILEINCOSTCENTRE
validation on relation SHAREDSETINCOSTCENTRE
validation on relation USRINCOSTCENTRE
validation on relation BLWICOUNTRYINCOUNTRY
validation on relation CURRENCYINCOUNTRY
validation on relation BLWIGROUPINCREDITOR
validation on relation BUSINESSRELATIONINCREDITOR
validation on relation CNCONTROLGLPROFILEINCREDITOR
validation on relation CREDITORTYPEINCREDITOR
validation on relation CURRENCYINCREDITOR
validation on relation DIVISIONPROFILEINCREDITOR
validation on relation INVCONTROLGLPROFILEINCREDITOR
validation on relation NORMALPAYMENTCONDITIONINCREDITOR
validation on relation PAYMENTGROUPINCREDITOR
validation on relation PURCHASETYPEINCREDITOR
validation on relation REASONINCREDITOR
validation on relation SHAREDSETINCREDITOR
validation on relation COMPANYINDCOLLECTION
validation on relation GLINDCOLLECTION
validation on relation DEBTORINDDOCUMENT
validation on relation GLINDDOCUMENTSTATUS
validation on relation BILLSCHEDULEINDEBTOR
validation on relation BLWIGROUPINDEBTOR
validation on relation BUSINESSRELATIONINDEBTOR
validation on relation CNCONTROLGLPROFILEINDEBTOR
validation on relation CURRENCYINDEBTOR
validation on relation DEBTORTYPEINDEBTOR
validation on relation DIVISIONPROFILEINDEBTOR
validation on relation EMPLOYEEINDEBTOR
validation on relation INVCONTROLGLPROFILEINDEBTOR
validation on relation NORMALPAYMENTCONDITIONINDEBTOR
validation on relation REASONINDEBTOR
validation on relation SHAREDSETINDEBTOR
validation on relation BUDGETGROUPINDIVISION
validation on relation SHAREDSETINDIVISION
validation on relation ACTIVITYCODEINEMPLOYEE
validation on relation BUSINESSRELATIONINEMPLOYEE
validation on relation COMPANYINEMPLOYEE
validation on relation COSTCENTREINEMPLOYEE
validation on relation CREDITORINEMPLOYEE
validation on relation CURRENCYINEMPLOYEE
validation on relation DIVISIONINEMPLOYEE
validation on relation EXPENSECODEINEMPLOYEE
validation on relation USRINEMPLOYEE
validation on relation SHAREDSETINEXCHANGERATE
validation on relation SHAREDSETINEXPENSEGLMATRIX
validation on relation DOMAINSINGLCALENDAR
validation on relation COMPANYINGLOPENITEM
validation on relation GLINGLOPENITEM
validation on relation JOURNALTYPEINJOURNAL
validation on relation LAYERINJOURNAL
validation on relation SHAREDSETINJOURNAL
validation on relation COMPANYINPOSTING
validation on relation JOURNALINPOSTING
validation on relation PERIODMARKINPOSTING
validation on relation COSTCENTREINPOSTINGLINE
validation on relation CURRENCYINPOSTINGLINE
validation on relation DIVISIONINPOSTINGLINE
validation on relation GLINPOSTINGLINE
validation on relation INTERCOINPOSTINGLINE
validation on relation SAFINPOSTINGSAF
validation on relation SAFSTRUCTUREINPOSTINGSAF
validation on relation PERIODMARKINPOSTINGVAT
validation on relation VATINPOSTINGVAT
validation on relation COMPANYINMIRRORINGGL
validation on relation COMPANYINMIRRORINGJOURNAL
validation on relation CURRENCYINPAYFORMATTYPE
validation on relation COMPANYINPAYSEL
validation on relation USRINPAYSELHISTORY
validation on relation PAYFORMATTYPEINPAYSELLINE
validation on relation PERIODMARKINPERIOD
validation on relation COSTCENTRE1SAFIDINPSAFCOMBINED
validation on relation COSTCENTRE1SAFINPOSTINGSAFCOMB
validation on relation COSTCENTRE2SAFIDINPSAFCOMBINED
validation on relation COSTCENTRE2SAFINPOSTINGSAFCOMB
validation on relation COSTCENTRE3SAFIDINPSAFCOMBINED
validation on relation COSTCENTRE3SAFINPOSTINGSAFCOMB
validation on relation COSTCENTRE4SAFIDINPSAFCOMBINED
validation on relation COSTCENTRE4SAFINPOSTINGSAFCOMB
validation on relation COSTCENTRE5SAFIDINPSAFCOMBINED
validation on relation COSTCENTRE5SAFINPOSTINGSAFCOMB
validation on relation GL1SAFIDINPSAFCOMBINED
validation on relation GL1SAFINPOSTINGSAFCOMBINED
validation on relation GL2SAFIDINPSAFCOMBINED
validation on relation GL2SAFINPOSTINGSAFCOMBINED
validation on relation GL3SAFIDINPSAFCOMBINED
validation on relation GL3SAFINPOSTINGSAFCOMBINED
validation on relation GL4SAFIDINPSAFCOMBINED
validation on relation GL4SAFINPOSTINGSAFCOMBINED
validation on relation GL5SAFIDINPSAFCOMBINED
validation on relation GL5SAFINPOSTINGSAFCOMBINED
validation on relation PROJECT1SAFIDINPSAFCOMBINED
validation on relation PROJECT1SAFINPOSTINGSAFCOMB
validation on relation PROJECT2SAFIDINPSAFCOMBINED
validation on relation PROJECT2SAFINPOSTINGSAFCOMB
validation on relation PROJECT3SAFIDINPSAFCOMBINED
validation on relation PROJECT3SAFINPOSTINGSAFCOMB
validation on relation PROJECT4SAFIDINPSAFCOMBINED
validation on relation PROJECT4SAFINPOSTINGSAFCOMB
validation on relation PROJECT5SAFIDINPSAFCOMBINED
validation on relation PROJECT5SAFINPOSTINGSAFCOMB
validation on relation SAFINPOSTINGSAFHIST
validation on relation COMPANYINPOSTINGTEMPLATE
validation on relation BUSINESSRELATIONINPAYSELPREPAY
validation on relation CREDITORINPAYSELPREP
validation on relation CURRENCYINPAYSELPREP
validation on relation PROFILETYPEINPROFILE
validation on relation COSTCENTREINPROFILELINK
validation on relation CREDITNOTEGLINPROFILELINK
validation on relation CREDITORINPROFILELINK
validation on relation DEBTORINPROFILELINK
validation on relation DELAYEDGLINPROFILELINK
validation on relation DIVISIONINPROFILELINK
validation on relation EMPLOYEEINPROFILELINK
validation on relation GLINPROFILELINK
validation on relation INVOICEGLINPROFILELINK
validation on relation JOURNALINPROFILELINK
validation on relation SHAREDSETINPROFILELINK
validation on relation DIVISIONINPROJECT
validation on relation EXCHANGERATETYPEINPROJECT
validation on relation PAYMENTCONDITIONINPROJECT
validation on relation PROJECTGROUPINPROJECT
validation on relation PROJECTMANAGERUSRINPROJECT
validation on relation PROJECTSTATUSINPROJECT
validation on relation SHAREDSETINPROJECT
validation on relation COMPANYINRECENTRY
validation on relation JOURNALINRECENTRY
validation on relation COUNTRYINREGION
validation on relation BUDGETGROUPINSAF
validation on relation SAFCONCEPTINSAF
validation on relation SAFCONCEPTINSAFSTRUCTURELINE
validation on relation COSTCENTREINSAFSTRUCTURELINK
validation on relation SAFSTRUCTUREINSAFSTRUCTURELINK
validation on relation SHAREDSETINCMSHAREDSET
validation on relation CURRENCYINSYSPROPERTY
validation on relation COMPHANDLERUSRINUSERPROPERTY
validation on relation COMPLCOORDUSRINUSERPROPERTY
validation on relation COMPLOGGERUSRINUSERPROPERTY
validation on relation CREDCONTROLTMPUSRINUSERPROPERTY
validation on relation CREDCONTROLUSRINUSERPROPERTY
validation on relation USRINUSERPROPERTY
validation on relation CREDITNOTEGLPROFILEINVATRULE
validation on relation CREDITNOTEVATGROUPINVATRULE
validation on relation DELAYEDGLPROFILEINVATRULE
validation on relation INVOICEGLPROFILEINVATRULE
validation on relation INVOICEVATGROUPINVATRULE
validation on relation VATPERCENTINVATRULE
validation on relation COUNTRYINVATBOX
validation on relation DISCOUNTGLPROFILEINVATGROUP
validation on relation VATBOXINVATGROUPBOXLINK
validation on relation COMPANYINVATPERIOD
validation on relation PERIODMARKINVATPERIOD


program code (program1/database.p)

if ilIsActive <> true
then do:
    <M-2 run SetMessage
          (input  #T-3'The selected item ($1) is not active.':100(474)t-3# (icMessage), 
           input  icParentObjectLabel (icArguments), 
           input  icTargetFieldName (icFieldName), 
           input  icTargetField (icFieldValue), 
           input  'E':U (icType), 
           input  3 (iiSeverity), 
           input  icRowid (icRowid), 
           input  'BLF-334':U (icFcMsgNumber), 
           input  '' (icFcExplanation), 
           input  '' (icFcIdentification), 
           input  '' (icFcContext), 
           output viFcReturnSuper (oiReturnStatus)) in database>
    assign oiReturnStatus = -1.
end.