method ValidateComponent

Description

Write here all tests on database update (new / modify / delete) that cannot be coded with a validation mask.
The type of update can be found in tc_status (N/C/D).
If you find incorrect data, you must write an entry in tFcMessages (using SetMessage) and set the return status of this method to either +1 or -1.
Return status +1 = data will still be accepted.
Return status -1 = data will not be accepted.
This method is run from SetPublicTables, before transferring the received data into the class temp-tables.

Parameters

oiReturnStatus

output

integer

Internal usage

unused

program code (program/bfieldsecurity.p)

/* ================================================================= */
/* Convert activity label into an ID                                 */
/* ================================================================= */
for each t_sFieldSecurity where
         t_sFieldSecurity.tc_Status = "N":U or
         t_sFieldSecurity.tc_Status = "C":U :

    if t_sFieldSecurity.tcBusActivityCode = ""
    or t_sFieldSecurity.tcBusActivityCode = ?
    or t_sFieldSecurity.tcBusComponentCode = ""
    or t_sFieldSecurity.tcBusComponentCode = ?
    then assign t_sFieldSecurity.BusActivity_ID = 0.
    else do:
        <Q-1 run BusActivityPrim (all)  (Read)  (NoCache)  (input 0, (BusActivityID) 
                          input t_sFieldSecurity.tcBusActivityCode, (BusActivityCode) 
                          input t_sFieldSecurity.tcBusComponentCode, (BusComponentCode)
                          output dataset tqBusActivityPrim) in BBusinessComponent >
        find first tqBusActivityPrim no-error.
        if available tqBusActivityPrim
        then assign t_sFieldSecurity.BusActivity_ID = tqBusActivityPrim.tiBusActivity_ID.
        else do:
            assign t_sFieldSecurity.BusActivity_ID = 0
                   oiReturnStatus = -1.
            <M-2 run SetMessage (input  #T-2'Invalid activity code.':40(466)T-2# (icMessage), 
                     input  '' (icArguments), 
                     input  't_sFieldSecurity.tcBusActivityCode':U (icFieldName), 
                     input  t_sFieldSecurity.tcBusComponentCode + '/':U + t_sFieldSecurity.tcBusActivityCode (icFieldValue), 
                     input  'E':U (icType), 
                     input  3 (iiSeverity), 
                     input  t_sFieldSecurity.tc_Rowid (icRowid), 
                     input  'BLF-107':U (icFcMsgNumber), 
                     input  '' (icFcExplanation), 
                     input  '' (icFcIdentification), 
                     input  '' (icFcContext), 
                     output viFcReturnSuper (oiReturnStatus)) in BFieldSecurity>
        end.
    end.
end.

<ANCESTOR-CODE>