Update Method (JobExec)
- Last UpdatedNov 06, 2025
- 4 minute read
The Update() method updates all columns of the specified job exec record in the Job_Exec table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal entId As Integer, _
ByVal jobPos As Integer, _
ByVal nextJobOnly As Boolean, _
ByVal itemBasedDesc As Boolean, _
ByVal jobEndConfirmMsg As DBString, _
ByVal defToEntId As DBInt, _
ByVal defRejectEntId As DBInt, _
ByVal defFromEntId As DBInt, _
ByVal defProdReasCd As Integer, _
ByVal defConsReasCd As DBInt, _
ByVal defLotNo As DBString, _
ByVal defSubLotNo As DBString, _
ByVal autoLoadJobSpecs As Boolean, _
ByVal autoSeqStartOption As AutoSeqStartOption, _
ByVal autoJobStartOption As AutoJobStartOption, _
ByVal autoJobEndOption As AutoJobEndOption, _
ByVal inclClassReas As Boolean, _
ByVal mustCompleteSteps As Boolean, _
ByVal mustProdReqdQty As Boolean, _
ByVal localMovableConsEnt As Boolean, _
ByVal localMovableProdEnt As Boolean, _
ByVal runWithoutOperator As Boolean, _
ByVal applyPostExecFcCounts As Boolean, _
ByVal suppressStartQtyPrompt As Boolean, _
ByVal allowZeroQtySplit As Boolean, _
ByVal autoAllocQtyToRunningJob As Boolean, _
ByVal curWoId As DBString, _
ByVal curOperId As DBString, _
ByVal curSeqNo As DBInt, _
ByVal curStepNo As DBInt, _
ByVal curStepStart As Date, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim entId As Integer
Dim jobPos As Integer
Dim nextJobOnly As Boolean
Dim itemBasedDesc As Boolean
Dim jobEndConfirmMsg As DBString
Dim defToEntId As DBInt
Dim defRejectEntId As DBInt
Dim defFromEntId As DBInt
Dim defProdReasCd As Integer
Dim defConsReasCd As DBInt
Dim defLotNo As DBString
Dim defSubLotNo As DBString
Dim autoLoadJobSpecs As Boolean
Dim autoSeqStartOption As AutoSeqStartOption
Dim autoJobStartOption As AutoJobStartOption
Dim autoJobEndOption As AutoJobEndOption
Dim inclClassReas As Boolean
Dim mustCompleteSteps As Boolean
Dim mustProdReqdQty As Boolean
Dim localMovableConsEnt As Boolean
Dim localMovableProdEnt As Boolean
Dim runWithoutOperator As Boolean
Dim applyPostExecFcCounts As Boolean
Dim suppressStartQtyPrompt As Boolean
Dim allowZeroQtySplit As Boolean
Dim autoAllocQtyToRunningJob As Boolean
Dim curWoId As DBString
Dim curOperId As DBString
Dim curSeqNo As DBInt
Dim curStepNo As DBInt
Dim curStepStart As Date
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
JobExec.Update(sessionId, entId, jobPos, nextJobOnly, itemBasedDesc, jobEndConfirmMsg, defToEntId, defRejectEntId, defFromEntId, defProdReasCd, defConsReasCd, defLotNo, defSubLotNo, autoLoadJobSpecs, autoSeqStartOption, autoJobStartOption, autoJobEndOption, inclClassReas, mustCompleteSteps, mustProdReqdQty, localMovableConsEnt, localMovableProdEnt, runWithoutOperator, applyPostExecFcCounts, suppressStartQtyPrompt, allowZeroQtySplit, autoAllocQtyToRunningJob, curWoId, curOperId, curSeqNo, curStepNo, curStepStart, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int entId,
int jobPos,
bool nextJobOnly,
bool itemBasedDesc,
DBString jobEndConfirmMsg,
DBInt defToEntId,
DBInt defRejectEntId,
DBInt defFromEntId,
int defProdReasCd,
DBInt defConsReasCd,
DBString defLotNo,
DBString defSubLotNo,
bool autoLoadJobSpecs,
AutoSeqStartOption autoSeqStartOption,
AutoJobStartOption autoJobStartOption,
AutoJobEndOption autoJobEndOption,
bool inclClassReas,
bool mustCompleteSteps,
bool mustProdReqdQty,
bool localMovableConsEnt,
bool localMovableProdEnt,
bool runWithoutOperator,
bool applyPostExecFcCounts,
bool suppressStartQtyPrompt,
bool allowZeroQtySplit,
bool autoAllocQtyToRunningJob,
DBString curWoId,
DBString curOperId,
DBInt curSeqNo,
DBInt curStepNo,
DateTime curStepStart,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- entId
- Required. Holds the ID of the entity.
- jobPos
- Required. Holds the job position.
- nextJobOnly
- Required. A Boolean data type.
- itemBasedDesc
- Required. A Boolean data type.
- jobEndConfirmMsg
- Optional. Holds the job-end confirmation message.
- defToEntId
- Optional. Holds the definition to entity ID.
- defRejectEntId
- Optional. Holds the definition of rejected entity ID.
- defFromEntId
- Optional. Holds the definition from entity ID.
- defProdReasCd
- Required. Holds the definition to hold production reason code.
- defConsReasCd
- Optional. Holds the definition to hold consumed reason code.
- defLotNo
- Optional. Holds the definition of the lot number.
- defSubLotNo
- Optional. Holds the definition of the sublot number.
- autoLoadJobSpecs
- Required. A Boolean data type.
- autoSeqStartOption
- Required. An integer data type to hold enumerated value for auto sequence start option. DoNotAutoStartNext = 0, AutoStartNext = 1
- autoJobStartOption
- Required. An integer data type to hold enumerated value for auto job start option. DoNotAutoStartNext = 0, AutoStartNextWhenReady = 1, AutoStartNextBasedOnTag = 2
- autoJobEndOption
- Required. An integer data type to hold enumerated value for auto job end option. DoNotAutoEnd = 0, AutoEndWhenQtyDoneEqualsOrExceedsQtyReqd = 1
- inclClassReas
- Required. A Boolean data type.
- mustCompleteSteps
- Required. A Boolean data type.
- mustProdReqdQty
- Required. A Boolean data type.
- localMovableConsEnt
- Required. A Boolean data type.
- localMovableProdEnt
- Required. A Boolean data type.
- runWithoutOperator
- Required. A Boolean data type.
- applyPostExecFcCounts
- Required. A Boolean data type.
- suppressStartQtyPrompt
- Required. A Boolean data type.
- allowZeroQtySplit
- Required. A Boolean data type.
- autoAllocQtyToRunningJob
- Required. A Boolean data type.
- curWoId
- Optional. Holds the current work order ID.
- curOperId
- Optional. Holds the current operation ID.
- curSeqNo
- Optional. Holds the current job sequence number.
- curStepNo
- Optional. Holds the current job step number.
- curStepStart
- Required. Holds the current step start time.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Optional. Holds comments that describe why this record is being updated.
- lastEditAt
Required. Holds the date/time when this record was added or last updated, for optimistic concurrency control. The passed value must match the lastEditAt value in the record for the update to succeed.
Output. Holds the date/time value when the record was updated by this called method.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Required DB* parameters: Must pass a value. To clear the existing value and enter an empty value, pass DB*.null (e.g., DBInt.null).
- Optional non-DB* parameters: Either enter a new value or leave the existing value unchanged by passing a null.
- Optional DB* parameters: To clear the existing value and enter an empty value, pass DB*.null (e.g., DBInt.null). To leave the existing value unchanged, pass a null.