UpdateSpecific Method (JobExec)
- Last UpdatedNov 06, 2025
- 5 minute read
The UpdateSpecific() method updates selected columns of the specified job exec record in the Job_Exec table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal entId As Integer, _
ByVal jobPos As Nullable(Of Integer), _
ByVal nextJobOnly As Nullable(Of Boolean), _
ByVal itemBasedDesc As Nullable(Of Boolean), _
ByVal jobEndConfirmMsg As DBString, _
ByVal defToEntId As DBInt, _
ByVal defRejectEntId As DBInt, _
ByVal defFromEntId As DBInt, _
ByVal defProdReasCd As Nullable(Of Integer), _
ByVal defConsReasCd As DBInt, _
ByVal defLotNo As DBString, _
ByVal defSubLotNo As DBString, _
ByVal autoLoadJobSpecs As Nullable(Of Boolean), _
ByVal autoSeqStartOption As Nullable(Of AutoSeqStartOption), _
ByVal autoJobStartOption As Nullable(Of AutoJobStartOption), _
ByVal autoJobEndOption As Nullable(Of AutoJobEndOption), _
ByVal inclClassReas As Nullable(Of Boolean), _
ByVal mustCompleteSteps As Nullable(Of Boolean), _
ByVal mustProdReqdQty As Nullable(Of Boolean), _
ByVal localMovableConsEnt As Nullable(Of Boolean), _
ByVal localMovableProdEnt As Nullable(Of Boolean), _
ByVal runWithoutOperator As Nullable(Of Boolean), _
ByVal applyPostExecFcCounts As Nullable(Of Boolean), _
ByVal suppressStartQtyPrompt As Nullable(Of Boolean), _
ByVal allowZeroQtySplit As Nullable(Of Boolean), _
ByVal autoAllocQtyToRunningJob As Nullable(Of Boolean), _
ByVal curWoId As DBString, _
ByVal curOperId As DBString, _
ByVal curSeqNo As DBInt, _
ByVal curStepNo As DBInt, _
ByVal curStepStart As Nullable(Of Date), _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim entId As Integer
Dim jobPos As Nullable(Of Integer)
Dim nextJobOnly As Nullable(Of Boolean)
Dim itemBasedDesc As Nullable(Of Boolean)
Dim jobEndConfirmMsg As DBString
Dim defToEntId As DBInt
Dim defRejectEntId As DBInt
Dim defFromEntId As DBInt
Dim defProdReasCd As Nullable(Of Integer)
Dim defConsReasCd As DBInt
Dim defLotNo As DBString
Dim defSubLotNo As DBString
Dim autoLoadJobSpecs As Nullable(Of Boolean)
Dim autoSeqStartOption As Nullable(Of AutoSeqStartOption)
Dim autoJobStartOption As Nullable(Of AutoJobStartOption)
Dim autoJobEndOption As Nullable(Of AutoJobEndOption)
Dim inclClassReas As Nullable(Of Boolean)
Dim mustCompleteSteps As Nullable(Of Boolean)
Dim mustProdReqdQty As Nullable(Of Boolean)
Dim localMovableConsEnt As Nullable(Of Boolean)
Dim localMovableProdEnt As Nullable(Of Boolean)
Dim runWithoutOperator As Nullable(Of Boolean)
Dim applyPostExecFcCounts As Nullable(Of Boolean)
Dim suppressStartQtyPrompt As Nullable(Of Boolean)
Dim allowZeroQtySplit As Nullable(Of Boolean)
Dim autoAllocQtyToRunningJob As Nullable(Of Boolean)
Dim curWoId As DBString
Dim curOperId As DBString
Dim curSeqNo As DBInt
Dim curStepNo As DBInt
Dim curStepStart As Nullable(Of Date)
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Nullable(Of Date)
JobExec.UpdateSpecific(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 UpdateSpecific(
int sessionId,
int entId,
Nullable<int> jobPos,
Nullable<bool> nextJobOnly,
Nullable<bool> itemBasedDesc,
DBString jobEndConfirmMsg,
DBInt defToEntId,
DBInt defRejectEntId,
DBInt defFromEntId,
Nullable<int> defProdReasCd,
DBInt defConsReasCd,
DBString defLotNo,
DBString defSubLotNo,
Nullable<bool> autoLoadJobSpecs,
Nullable<AutoSeqStartOption> autoSeqStartOption,
Nullable<AutoJobStartOption> autoJobStartOption,
Nullable<AutoJobEndOption> autoJobEndOption,
Nullable<bool> inclClassReas,
Nullable<bool> mustCompleteSteps,
Nullable<bool> mustProdReqdQty,
Nullable<bool> localMovableConsEnt,
Nullable<bool> localMovableProdEnt,
Nullable<bool> runWithoutOperator,
Nullable<bool> applyPostExecFcCounts,
Nullable<bool> suppressStartQtyPrompt,
Nullable<bool> allowZeroQtySplit,
Nullable<bool> autoAllocQtyToRunningJob,
DBString curWoId,
DBString curOperId,
DBInt curSeqNo,
DBInt curStepNo,
Nullable<DateTime> curStepStart,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref Nullable<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
- Optional. A Boolean data type.
- itemBasedDesc
- Optional. A Boolean data type.
- jobEndConfirmMsg
- Optional. Holds the job-end confirmation message.
- defToEntId
- Optional. An integer data type to hold definition to entity ID
- defRejectEntId
- Optional. An integer data type to hold definition of rejected entity ID
- defFromEntId
- Optional. An integer data type to hold definition from entity ID
- defProdReasCd
- Optional. An integer data type to hold definition to hold production reason code.
- defConsReasCd
- Optional. An integer data type to hold definition to hold consumed reason code.
- defLotNo
- Optional. A string data type to hold definition of lot no.
- defSubLotNo
- Optional. A string data type to hold definition of sub lot no.
- autoLoadJobSpecs
- Optional. A Boolean data type.
- autoSeqStartOption
- Optional. An integer data type to hold enumerated value for auto sequence start option. DoNotAutoStartNext = 0, AutoStartNext = 1
- autoJobStartOption
- Optional. An integer data type to hold enumerated value for auto job start option. DoNotAutoStartNext = 0, AutoStartNextWhenReady = 1, AutoStartNextBasedOnTag = 2
- autoJobEndOption
- Optional. An integer data type to hold enumerated value for auto job end option. DoNotAutoEnd = 0, AutoEndWhenQtyDoneEqualsOrExceedsQtyReqd = 1
- inclClassReas
- Optional. A Boolean data type.
- mustCompleteSteps
- Optional. A Boolean data type.
- mustProdReqdQty
- Optional. A Boolean data type.
- localMovableConsEnt
- Optional. A Boolean data type.
- localMovableProdEnt
- Optional. A Boolean data type.
- runWithoutOperator
- Optional. A Boolean data type.
- applyPostExecFcCounts
- Optional. A Boolean data type.
- suppressStartQtyPrompt
- Optional. A Boolean data type.
- allowZeroQtySplit
- Optional. A Boolean data type.
- autoAllocQtyToRunningJob
- Optional. 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
- Optional. 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
Optional. Holds the date/time when this record was added or last updated, for optimistic concurrency control. If it is specified, 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:
- 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.