Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateless API

TABLE OF CONTENTS

UpdateSpecific Method (DataLog48)

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL

The UpdateSpecific() method updates selected columns for the specified data log record in the Data_Log table.

Note: The methods in the DataLog48 class should not be used. They have been replaced by the DataLog class methods.

Syntax

'Declaration
 
Public Shared Sub UpdateSpecific( _
   ByVal sessionId As Integer, _
   ByVal rowId As Integer, _
   ByVal grpId As Nullable(Of Integer), _
   ByVal sampleTimeLocal As Nullable(Of Date), _
   ByVal woId As DBString, _
   ByVal operId As DBString, _
   ByVal seqNo As DBInt, _
   ByVal stepNo As DBInt, _
   ByVal itemId As DBString, _
   ByVal lotNo As DBString, _
   ByVal sublotNo As DBString, _
   ByVal shiftStartLocal As Nullable(Of Date), _
   ByVal shiftId As Nullable(Of Integer), _
   ByVal entId As DBInt, _
   ByVal value1 As DBString, _
   ByVal value2 As DBString, _
   ByVal value3 As DBString, _
   ByVal value4 As DBString, _
   ByVal value5 As DBString, _
   ByVal value6 As DBString, _
   ByVal value7 As DBString, _
   ByVal value8 As DBString, _
   ByVal value9 As DBString, _
   ByVal value10 As DBString, _
   ByVal value11 As DBString, _
   ByVal value12 As DBString, _
   ByVal value13 As DBString, _
   ByVal value14 As DBString, _
   ByVal value15 As DBString, _
   ByVal value16 As DBString, _
   ByVal value17 As DBString, _
   ByVal value18 As DBString, _
   ByVal value19 As DBString, _
   ByVal value20 As DBString, _
   ByVal value21 As DBString, _
   ByVal value22 As DBString, _
   ByVal value23 As DBString, _
   ByVal value24 As DBString, _
   ByVal value25 As DBString, _
   ByVal value26 As DBString, _
   ByVal value27 As DBString, _
   ByVal value28 As DBString, _
   ByVal value29 As DBString, _
   ByVal value30 As DBString, _
   ByVal value31 As DBString, _
   ByVal value32 As DBString, _
   ByVal value33 As DBString, _
   ByVal value34 As DBString, _
   ByVal value35 As DBString, _
   ByVal value36 As DBString, _
   ByVal value37 As DBString, _
   ByVal value38 As DBString, _
   ByVal value39 As DBString, _
   ByVal value40 As DBString, _
   ByVal value41 As DBString, _
   ByVal value42 As DBString, _
   ByVal value43 As DBString, _
   ByVal value44 As DBString, _
   ByVal value45 As DBString, _
   ByVal value46 As DBString, _
   ByVal value47 As DBString, _
   ByVal value48 As DBString, _
   ByVal lastEditComment As DBString _
) 
'Usage
 
Dim sessionId As Integer
Dim rowId As Integer
Dim grpId As Nullable(Of Integer)
Dim sampleTimeLocal As Nullable(Of Date)
Dim woId As DBString
Dim operId As DBString
Dim seqNo As DBInt
Dim stepNo As DBInt
Dim itemId As DBString
Dim lotNo As DBString
Dim sublotNo As DBString
Dim shiftStartLocal As Nullable(Of Date)
Dim shiftId As Nullable(Of Integer)
Dim entId As DBInt
Dim value1 As DBString
Dim value2 As DBString
Dim value3 As DBString
Dim value4 As DBString
Dim value5 As DBString
Dim value6 As DBString
Dim value7 As DBString
Dim value8 As DBString
Dim value9 As DBString
Dim value10 As DBString
Dim value11 As DBString
Dim value12 As DBString
Dim value13 As DBString
Dim value14 As DBString
Dim value15 As DBString
Dim value16 As DBString
Dim value17 As DBString
Dim value18 As DBString
Dim value19 As DBString
Dim value20 As DBString
Dim value21 As DBString
Dim value22 As DBString
Dim value23 As DBString
Dim value24 As DBString
Dim value25 As DBString
Dim value26 As DBString
Dim value27 As DBString
Dim value28 As DBString
Dim value29 As DBString
Dim value30 As DBString
Dim value31 As DBString
Dim value32 As DBString
Dim value33 As DBString
Dim value34 As DBString
Dim value35 As DBString
Dim value36 As DBString
Dim value37 As DBString
Dim value38 As DBString
Dim value39 As DBString
Dim value40 As DBString
Dim value41 As DBString
Dim value42 As DBString
Dim value43 As DBString
Dim value44 As DBString
Dim value45 As DBString
Dim value46 As DBString
Dim value47 As DBString
Dim value48 As DBString
Dim lastEditComment As DBString
 
DataLog48.UpdateSpecific(sessionId, rowId, grpId, sampleTimeLocal, woId, operId, seqNo, stepNo, itemId, lotNo, sublotNo, shiftStartLocal, shiftId, entId, value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21, value22, value23, value24, value25, value26, value27, value28, value29, value30, value31, value32, value33, value34, value35, value36, value37, value38, value39, value40, value41, value42, value43, value44, value45, value46, value47, value48, lastEditComment)
public static void UpdateSpecific( 
   int sessionId,
   int rowId,
   Nullable<int> grpId,
   Nullable<DateTime> sampleTimeLocal,
   DBString woId,
   DBString operId,
   DBInt seqNo,
   DBInt stepNo,
   DBString itemId,
   DBString lotNo,
   DBString sublotNo,
   Nullable<DateTime> shiftStartLocal,
   Nullable<int> shiftId,
   DBInt entId,
   DBString value1,
   DBString value2,
   DBString value3,
   DBString value4,
   DBString value5,
   DBString value6,
   DBString value7,
   DBString value8,
   DBString value9,
   DBString value10,
   DBString value11,
   DBString value12,
   DBString value13,
   DBString value14,
   DBString value15,
   DBString value16,
   DBString value17,
   DBString value18,
   DBString value19,
   DBString value20,
   DBString value21,
   DBString value22,
   DBString value23,
   DBString value24,
   DBString value25,
   DBString value26,
   DBString value27,
   DBString value28,
   DBString value29,
   DBString value30,
   DBString value31,
   DBString value32,
   DBString value33,
   DBString value34,
   DBString value35,
   DBString value36,
   DBString value37,
   DBString value38,
   DBString value39,
   DBString value40,
   DBString value41,
   DBString value42,
   DBString value43,
   DBString value44,
   DBString value45,
   DBString value46,
   DBString value47,
   DBString value48,
   DBString lastEditComment
)

Parameters

sessionId
Required. Holds the session ID and thus the user who is making this method call.
rowId
Required. Holds the row ID of the data log record to be modified.
grpId
Optional. Holds the ID of the data log group.
sampleTimeLocal
Optional. Holds the date and time when sample was first taken, in local time.
woId
Optional. Holds the ID of the work order.
operId
Optional. Holds the ID of the operation.
seqNo
Optional. Holds the operation sequence number.
stepNo
Optional. Holds the step number of the job.
itemId
Optional. Holds the ID of the item.
lotNo
Optional. Holds the lot number of the item.
sublotNo
Optional. Holds the sublot number of the item.
shiftStartLocal
Optional. Holds the date and time when the shift started, in local time.
shiftId
Optional. Holds the ID of the shift.
entId
Optional. Holds the ID of the entity.
value1
Optional. Holds the contents of the user-defined value1 field.
value2
Optional. Holds the contents of the user-defined value2 field.
value3
Optional. Holds the contents of the user-defined value3 field.
value4
Optional. Holds the contents of the user-defined value4 field.
value5
Optional. Holds the contents of the user-defined value5 field.
value6
Optional. Holds the contents of the user-defined value6 field.
value7
Optional. Holds the contents of the user-defined value7 field.
value8
Optional. Holds the contents of the user-defined value8 field.
value9
Optional. Holds the contents of the user-defined value9 field.
value10
Optional. Holds the contents of the user-defined value10 field.
value11
Optional. Holds the contents of the user-defined value11 field.
value12
Optional. Holds the contents of the user-defined value12 field.
value13
Optional. Holds the contents of the user-defined value13 field.
value14
Optional. Holds the contents of the user-defined value14 field.
value15
Optional. Holds the contents of the user-defined value15 field.
value16
Optional. Holds the contents of the user-defined value16 field.
value17
Optional. Holds the contents of the user-defined value17 field.
value18
Optional. Holds the contents of the user-defined value18 field.
value19
Optional. Holds the contents of the user-defined value19 field.
value20
Optional. Holds the contents of the user-defined value20 field.
value21
Optional. Holds the contents of the user-defined value21 field.
value22
Optional. Holds the contents of the user-defined value22 field.
value23
Optional. Holds the contents of the user-defined value23 field.
value24
Optional. Holds the contents of the user-defined value24 field.
value25
Optional. Holds the contents of the user-defined value25 field.
value26
Optional. Holds the contents of the user-defined value26 field.
value27
Optional. Holds the contents of the user-defined value27 field.
value28
Optional. Holds the contents of the user-defined value28 field.
value29
Optional. Holds the contents of the user-defined value29 field.
value30
Optional. Holds the contents of the user-defined value30 field.
value31
Optional. Holds the contents of the user-defined value31 field.
value32
Optional. Holds the contents of the user-defined value32 field.
value33
Optional. Holds the contents of the user-defined value33 field.
value34
Optional. Holds the contents of the user-defined value34 field.
value35
Optional. Holds the contents of the user-defined value35 field.
value36
Optional. Holds the contents of the user-defined value36 field.
value37
Optional. Holds the contents of the user-defined value37 field.
value38
Optional. Holds the contents of the user-defined value38 field.
value39
Optional. Holds the contents of the user-defined value39 field.
value40
Optional. Holds the contents of the user-defined value40 field.
value41
Optional. Holds the contents of the user-defined value41 field.
value42
Optional. Holds the contents of the user-defined value42 field.
value43
Optional. Holds the contents of the user-defined value43 field.
value44
Optional. Holds the contents of the user-defined value44 field.
value45
Optional. Holds the contents of the user-defined value45 field.
value46
Optional. Holds the contents of the user-defined value46 field.
value47
Optional. Holds the contents of the user-defined value47 field.
value48
Optional. Holds the contents of the user-defined value48 field.
lastEditComment
Optional. Holds comments that describe why this record is being updated.

Remarks

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.

See Also

Reference

DataLog48 Class
DataLog48 Members

In This Topic
TitleResults for “How to create a CRG?”Also Available in