Add(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,Int32) Method
- Last UpdatedNov 06, 2025
- 5 minute read
The Add() method adds a new sample plan frequency record to the Sample_Freq table.
This overload of the method includes the startDelay input parameter.
'Declaration
Public Overloads Shared Sub Add( _
ByVal sessionId 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, _
ByRef freqId As Integer _
)
'Usage
Dim sessionId 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
Dim freqId As Integer
SampleFreq.Add(sessionId, freqName, freqDesc, freqType, interval, intervalUnit, prodResetOption, startDelay, offsetStart, offsetStartUnit, offsetEnd, offsetEndUnit, samplesPerShift, multiplier, enabled, expiryTime, expiryUnit, warningTime, warningUnit, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt, freqId)
public static void Add(
int sessionId,
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,
out DateTime lastEditAt,
out int freqId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method.
- freqName
- Required. Holds the unique name of the sample plan frequency for display.
- freqDesc
- Optional. Holds the description of the sample plan frequency.
- freqType
Optional. 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
- Optional. Holds the amount of time or production between samples.
- intervalUnit
Optional. 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
Optional. 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
- Optional. 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
- Optional. Holds the offset value from the start of the shift.
- offsetStartUnit
Optional. Holds an enumeration that indicates the units for the offset value from the start of the shift:
1= minutes
2 = hours
3 = days
- offsetEnd
- Optional. Holds the offset value from the end of the shift.
- offsetEndUnit
Optional. Holds an enumeration that indicates the units for the end of the shift:
1= minutes
2 = hours
3 = days
- samplesPerShift
- Optional. Holds the number of times to ready an event between the offsets from the ends of a shift.
- multiplier
- Optional. Holds the sample size multiplier.
- enabled
- Optional. Holds a flag that, if true, specifies that the sample frequency can be used at runtime.
- expiryTime
- Optional. Holds the amount of time to wait for the sample to be pulled before changing its status to MISSING.
- expiryUnit
Optional. Holds an enumeration that indicates the units for the expiryTime parameter:
1= minutes
2 = hours
3 = days
- warningTime
- Optional. Holds the amount of time to wait for a sample to be pulled before changing its status to READY WARNING.
- warningUnit
Optional. Holds an enumeration that indicates the units for the warningTime parameter:
1= minutes (default)
2 = hours
3 = days
- spare1
- Optional. Holds a value defined by language term 5157.
- spare2
- Optional. Holds a value defined by language term 5158.
- spare3
- Optional. Holds a value defined by language term 5159.
- spare4
- Optional. Holds a value defined by language term 5160.
- lastEditComment
- Optional. Holds comments that describe why this record is being added.
- lastEditAt
- Output. Holds the date and time that this record was added.
- freqId
- Output. Holds the ID assigned to this record when it is added. The freq_id value is used by other methods that modify or delete this type of record.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.