project QadFinancials > class Database Component > method ValCharNotNULL

validation procedure

Description

ValCharNotNULL: Validation-method that raises an error in case the character-field has the NULL value


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.
oiReturnStatusoutputintegerReturn status of the method.


Internal usage


QadFinancials
validation on tAcctIFFilter.AcctIFFilterAcctBookNo
validation on tAcctIFFilter.AcctIFFilterAcctLevel
validation on tAcctIFFilter.AcctIFFilterFiscalYear
validation on tAcctIFFilter.AcctIFFilterIndustry
validation on tAcctIFFilter.AcctIFFilterLayerCode
validation on tAcctIFFilter.AcctIFFilterOrgCode
validation on tAcctIFFilter.AcctIFFilterStructCodeBS
validation on tAcctIFFilter.AcctIFFilterStructCodeIS
validation on tBankNumber.BankNumberExtension
validation on tAddress.AddressStreet1
validation on tAddress.AddressStreet2
validation on tAddress.AddressStreet3
validation on tAddress.AddressZip
validation on tContact.ContactName
validation on tCInvoiceVat.TxclTaxCls
validation on tCInvoiceVat.TxenvTaxEnv
validation on tCInvoiceVat.TxuTaxUsage
validation on tCOACrossRefDet.COACrossRefDetSrcCCFrom
validation on tCOACrossRefDet.COACrossRefDetSrcCCTo
validation on tCOACrossRefDet.COACrossRefDetSrcDivFrom
validation on tCOACrossRefDet.COACrossRefDetSrcDivTo
validation on tCOACrossRefDet.COACrossRefDetSrcGLFrom
validation on tCOACrossRefDet.COACrossRefDetSrcGLTo
validation on tCOACrossRefDet.COACrossRefDetSrcProjFrom
validation on tCOACrossRefDet.COACrossRefDetSrcProjTo
validation on tCOAMaskCCDiv.COAMaskCCDivFrom
validation on tCOAMaskCCDiv.COAMaskCCDivTo
validation on tCOAMaskCCGL.COAMaskCCGLFrom
validation on tCOAMaskCCGL.COAMaskCCGLTo
validation on tCOAMaskProjCC.COAMaskProjCCFrom
validation on tCOAMaskProjCC.COAMaskProjCCTo
validation on tCOAMaskProjDiv.COAMaskProjDivFrom
validation on tCOAMaskProjDiv.COAMaskProjDivTo
validation on tCOAMaskProjGL.COAMaskProjGLFrom
validation on tCOAMaskProjGL.COAMaskProjGLTo
validation on tDInvoiceVat.TxclTaxCls
validation on tDInvoiceVat.TxenvTaxEnv
validation on tDInvoiceVat.TxuTaxUsage
validation on tEmployee.EmployeeCode
validation on tJournal.JournalCode
validation on tJournalGroup.JournalGroupCode
validation on tPeriodMark.PeriodMarkCode
validation on tPostingTemplate.PostingTemplateCode
validation on tWHT.WHTChargeType


program code (program1/database.p)

    
    /* ValCharNotNULL: Validation-method that raises an error in case the character-field has the NULL value */
    if icTargetField = ?
    then do :
        <M-59 run SetMessage
           (input  #T-57'This field cannot have the unknown-value.':255(133401422)T-57# (icMessage), 
            input  '' (icArguments), 
            input  icTargetFieldName (icFieldName), 
            input  '' (icFieldValue), 
            input  'E':U (icType), 
            input  3 (iiSeverity), 
            input  icRowid (icRowid), 
            input  'qadfin-587302':U (icFcMsgNumber), 
            input  '' (icFcExplanation), 
            input  '' (icFcIdentification), 
            input  '' (icFcContext), 
            output oiReturnStatus (oiReturnStatus)) in database>  
        assign oiReturnStatus = -1.
    end. /* if icTargetField = ? */