UpdateSpecific(Int32,Int32,String,DBString,Nullable<Int32>,String,DateTime,DBDateTime,DBInt,DBString,DBInt,DBString,DBString,Nullable<Int32>,DBInt,DBInt,DBString,DBString,DBString,DBString,DBString,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected columns of the specified specification record in the Qm_Spec table.
'Declaration
Public Overloads Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal qmSpecId As Integer, _
ByVal qmSpecName As String, _
ByVal qmSpecDesc As DBString, _
ByVal editLevel As Nullable(Of Integer), _
ByVal verId As String, _
ByVal startEffLocal As Date, _
ByVal endEffLocal As DBDateTime, _
ByVal entId As DBInt, _
ByVal itemId As DBString, _
ByVal itemCategoryId As DBInt, _
ByVal processId As DBString, _
ByVal operId As DBString, _
ByVal categoryId As Nullable(Of Integer), _
ByVal planId As DBInt, _
ByVal numberPointsPerPage As DBInt, _
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 qmSpecId As Integer
Dim qmSpecName As String
Dim qmSpecDesc As DBString
Dim editLevel As Nullable(Of Integer)
Dim verId As String
Dim startEffLocal As Date
Dim endEffLocal As DBDateTime
Dim entId As DBInt
Dim itemId As DBString
Dim itemCategoryId As DBInt
Dim processId As DBString
Dim operId As DBString
Dim categoryId As Nullable(Of Integer)
Dim planId As DBInt
Dim numberPointsPerPage As DBInt
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)
QmSpec.UpdateSpecific(sessionId, qmSpecId, qmSpecName, qmSpecDesc, editLevel, verId, startEffLocal, endEffLocal, entId, itemId, itemCategoryId, processId, operId, categoryId, planId, numberPointsPerPage, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void UpdateSpecific(
int sessionId,
int qmSpecId,
string qmSpecName,
DBString qmSpecDesc,
Nullable<int> editLevel,
string verId,
DateTime startEffLocal,
DBDateTime endEffLocal,
DBInt entId,
DBString itemId,
DBInt itemCategoryId,
DBString processId,
DBString operId,
Nullable<int> categoryId,
DBInt planId,
DBInt numberPointsPerPage,
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.
- qmSpecId
- Required. Holds the ID of the specification.
- qmSpecName
- Optional. Holds the name of the specification.
- qmSpecDesc
- Optional. Holds the description of the specification.
- editLevel
- Optional. Holds the privilege level required to edit this record.
- verId
- Required. Holds the version of this specification.
- startEffLocal
- Optional. Holds the local time when this version of this specification becomes effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.
- endEffLocal
- Optional. Holds the local time when this version of this specification ceases to be effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.
- entId
- Optional. Holds the entity or the entity class to which this specification applies.
- itemId
- Optional. Holds the item to which this specification applies.
- itemCategoryId
- Optional. Holds the item category to which this specification applies.
- processId
- Optional. Holds the process to which this specification applies.
- operId
- Optional. Holds the operation to which this specification applies.
- categoryId
- Optional. Holds the category to which this specification belongs.
- planId
- Optional. Holds the default sample plan for this specification.
- numberPointsPerPage
- Optional. Holds the number of samples per page for SPC Chart.
- 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 the new comment that describes why this record is being updated.
- lastEditAt
- In/Out parameter. Holds datetime of when record was created or last changed.
A QM specification's display_seq column value determines the order in which the specification record appears in a dataset returned by a QM specification Get method. If two or more specifications in the dataset have the same order value (e.g., 2), then those specifications are ordered alphabetically within that order value's subgroup. Because the displaySeq parameter is not included in this overload of the UpdateSpecific() method, it defaults to null. Therefore, the display_seq column for specifications updated by this overload will leave the value unchanged.
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.