Update(Int32,Int32,String,String,Nullable<Int32>,Nullable<Double>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Boolean>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,String,String,String,DateTime) Method
- Last UpdatedNov 06, 2025
- 5 minute read
The Update() method updates all columns of the specified sample frequency record in the Sample_Freq table.
This overload of the method includes the startDelay input parameter.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal freqId As Integer, _
ByVal freqName As String, _
ByVal freqDesc As String, _
ByVal freqType As Nullable(Of Integer), _
ByVal interval As Nullable(Of Double), _
ByVal intervalUnit As Nullable(Of Integer), _
ByVal prodResetOption As Nullable(Of Integer), _
ByVal startDelay As Nullable(Of Integer), _
ByVal offsetStart As Nullable(Of Integer), _
ByVal offsetStartUnit As Nullable(Of Integer), _
ByVal offsetEnd As Nullable(Of Integer), _
ByVal offsetEndUnit As Nullable(Of Integer), _
ByVal samplesPerShift As Nullable(Of Integer), _
ByVal multiplier As Nullable(Of Integer), _
ByVal enabled As Nullable(Of Boolean), _
ByVal expiryTime As Nullable(Of Integer), _
ByVal expiryUnit As Nullable(Of Integer), _
ByVal warningTime As Nullable(Of Integer), _
ByVal warningUnit As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditComment As String, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim freqId As Integer
Dim freqName As String
Dim freqDesc As String
Dim freqType As Nullable(Of Integer)
Dim interval As Nullable(Of Double)
Dim intervalUnit As Nullable(Of Integer)
Dim prodResetOption As Nullable(Of Integer)
Dim startDelay As Nullable(Of Integer)
Dim offsetStart As Nullable(Of Integer)
Dim offsetStartUnit As Nullable(Of Integer)
Dim offsetEnd As Nullable(Of Integer)
Dim offsetEndUnit As Nullable(Of Integer)
Dim samplesPerShift As Nullable(Of Integer)
Dim multiplier As Nullable(Of Integer)
Dim enabled As Nullable(Of Boolean)
Dim expiryTime As Nullable(Of Integer)
Dim expiryUnit As Nullable(Of Integer)
Dim warningTime As Nullable(Of Integer)
Dim warningUnit As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditComment As String
Dim lastEditAt As Date
SampleFreq.Update(sessionId, freqId, freqName, freqDesc, freqType, interval, intervalUnit, prodResetOption, startDelay, offsetStart, offsetStartUnit, offsetEnd, offsetEndUnit, samplesPerShift, multiplier, enabled, expiryTime, expiryUnit, warningTime, warningUnit, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int freqId,
string freqName,
string freqDesc,
Nullable<int> freqType,
Nullable<double> interval,
Nullable<int> intervalUnit,
Nullable<int> prodResetOption,
Nullable<int> startDelay,
Nullable<int> offsetStart,
Nullable<int> offsetStartUnit,
Nullable<int> offsetEnd,
Nullable<int> offsetEndUnit,
Nullable<int> samplesPerShift,
Nullable<int> multiplier,
Nullable<bool> enabled,
Nullable<int> expiryTime,
Nullable<int> expiryUnit,
Nullable<int> warningTime,
Nullable<int> warningUnit,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
Required. Holds the session ID and thus the user who is making this method.
- freqId
Required. The ID of the sample frequency.
- freqName
Required. Holds the unique name of the sample plan frequency for display.
- freqDesc
Required. Holds the description of the sample plan frequency.
- freqType
Required. Holds the type of sample plan frequency.
0 = shift
1 (default) = calendar time
2 = run time
3 = production
4 = main item produced changes (job_bom.current_subst for bom_pos = 0)
5 = item consumed at any BOM position changes
6 = the lot number of the main item produced changes (job_bom.def_lot_no for bom_pos = 0)
7 = the lot number of an item consumed at any BOM position changes
8 = the job changes
9 = utilization changes from runtime to downtime
10 = utilization changes from runtime to idle time
11 = utilization changes from downtime to runtime
12 = utilization changes from downtime to idle time
13 = utilization changes from idle time to runtime
14 = utilization changes from idle time to downtime
15 = inventory is received
16 = a new specification value is downloaded for the job running on a job position
17 = a step with action_type 6 starts
18 = a step with action_type 6 finishes
- interval
Required. Holds the amount of time or production between samples.
- intervalUnit
Required. Holds an enumeration that indicates the units for the amount of time or production between samples:
0 = seconds
1= minutes
2 = hours
3 = days
4 = weeks
5 = units of product
6 = number of lots
7 = number of jobs
8 = number of segment responses: 0 – 4 are used when freq_type = 0, 1, or 2 (shift, calendar time, run time); 5 – 8 when freq_type = 3 (production)
- prodResetOption
Required. Holds an enumeration that indicates what causes the count of production between samples to be reset. Used only if freq_type = 3 (production).
0 = nothing (no reset ever)
1 = job changes on job_exec (disallowed if interval_unit = 7)
2 = main item produced changes
3 = shift changes on entity
4 = entity utilization changes from runtime or downtime to idle time
- startDelay
Required. Holds the amount of time, in seconds, to delay the generation of the first sample after a job has started on an entity. Used only if freqType = 1 (calendar time). This parameter is only applicable when the offsetStart parameter is not being used to specify a time-of-day trigger.
- offsetStart
Required. Holds the offset value from the start of the shift.
- offsetStartUnit
Required. Holds an enumeration that indicates the units for the offset value from the start of the shift:
1= minutes
2 = hours
3 = days
- offsetEnd
Required. Holds the offset value from the end of the shift.
- offsetEndUnit
Required. Holds an enumeration that indicates the units for the end of the shift:
1= minutes
2 = hours
3 = days
- samplesPerShift
Required. Holds the number of times to ready an event between the offsets from the ends of a shift.
- multiplier
- Required. Holds the sample size multiplier.
- enabled
- Required. Holds a flag that, if true, specifies that the sample frequency can be used at runtime.
- expiryTime
- Required. Holds the amount of time to wait for the sample to be pulled before changing its status to MISSING.
- expiryUnit
Required. Holds an enumeration that indicates the units for the expiryTime parameter:
1= minutes
2 = hours
3 = days
- warningTime
- Required. Holds the amount of time to wait for a sample to be pulled before changing its status to READY WARNING.
- warningUnit
Required. Holds an enumeration that indicates the units for the warningTime parameter:
1= minutes (default)
2 = hours
3 = days
- spare1
- Required. Holds a value defined by language term 5157.
- spare2
- Required. Holds a value defined by language term 5158.
- spare3
- Required. Holds a value defined by language term 5159.
- spare4
- Required. Holds a value defined by language term 5160.
- lastEditComment
- Required. Holds the new comment that describes 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.