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 (DataLog)

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.

Syntax

'Declaration
 
Public Shared Sub UpdateSpecific( _
   ByVal sessionId As Integer, _
   ByVal rowId As Long, _
   ByVal entId As DBInt, _
   ByVal sampleTimeUTC 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 genealogyId As DBString, _
   ByVal segmentRequirementId As DBString, _
   ByVal segmentResponseId As DBString, _
   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 value49 As DBString, _
   ByVal value50 As DBString, _
   ByVal value51 As DBString, _
   ByVal value52 As DBString, _
   ByVal value53 As DBString, _
   ByVal value54 As DBString, _
   ByVal value55 As DBString, _
   ByVal value56 As DBString, _
   ByVal value57 As DBString, _
   ByVal value58 As DBString, _
   ByVal value59 As DBString, _
   ByVal value60 As DBString, _
   ByVal value61 As DBString, _
   ByVal value62 As DBString, _
   ByVal value63 As DBString, _
   ByVal value64 As DBString, _
   ByRef lastEditAt As Nullable(Of Date) _
) 
'Usage
 
Dim sessionId As Integer
Dim rowId As Long
Dim entId As DBInt
Dim sampleTimeUTC 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 genealogyId As DBString
Dim segmentRequirementId As DBString
Dim segmentResponseId As DBString
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 value49 As DBString
Dim value50 As DBString
Dim value51 As DBString
Dim value52 As DBString
Dim value53 As DBString
Dim value54 As DBString
Dim value55 As DBString
Dim value56 As DBString
Dim value57 As DBString
Dim value58 As DBString
Dim value59 As DBString
Dim value60 As DBString
Dim value61 As DBString
Dim value62 As DBString
Dim value63 As DBString
Dim value64 As DBString
Dim lastEditAt As Nullable(Of Date)
 
DataLog.UpdateSpecific(sessionId, rowId, entId, sampleTimeUTC, woId, operId, seqNo, stepNo, itemId, lotNo, sublotNo, genealogyId, segmentRequirementId, segmentResponseId, 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, value49, value50, value51, value52, value53, value54, value55, value56, value57, value58, value59, value60, value61, value62, value63, value64, lastEditAt)
public static void UpdateSpecific( 
   int sessionId,
   long rowId,
   DBInt entId,
   Nullable<DateTime> sampleTimeUTC,
   DBString woId,
   DBString operId,
   DBInt seqNo,
   DBInt stepNo,
   DBString itemId,
   DBString lotNo,
   DBString sublotNo,
   DBString genealogyId,
   DBString segmentRequirementId,
   DBString segmentResponseId,
   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 value49,
   DBString value50,
   DBString value51,
   DBString value52,
   DBString value53,
   DBString value54,
   DBString value55,
   DBString value56,
   DBString value57,
   DBString value58,
   DBString value59,
   DBString value60,
   DBString value61,
   DBString value62,
   DBString value63,
   DBString value64,
   ref Nullable<DateTime> lastEditAt
)

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.
entId
Optional. Holds the ID of the entity.
sampleTimeUTC
Optional. Holds the date and time when the sample was first taken, in UTC.
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.
genealogyId
Optional filter parameter. Holds the PEM intra-segment genealogy ID.
segmentRequirementId
Optional. Holds the S95 segment requirement ID.
segmentResponseId
Optional. Holds the S95 segment response ID.
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.
value49
Optional. Holds the contents of the user-defined value49 field.
value50
Optional. Holds the contents of the user-defined value50 field.
value51
Optional. Holds the contents of the user-defined value51 field.
value52
Optional. Holds the contents of the user-defined value52 field.
value53
Optional. Holds the contents of the user-defined value53 field.
value54
Optional. Holds the contents of the user-defined value54 field.
value55
Optional. Holds the contents of the user-defined value55 field.
value56
Optional. Holds the contents of the user-defined value56 field.
value57
Optional. Holds the contents of the user-defined value57 field.
value58
Optional. Holds the contents of the user-defined value58 field.
value59
Optional. Holds the contents of the user-defined value59 field.
value60
Optional. Holds the contents of the user-defined value60 field.
value61
Optional. Holds the contents of the user-defined value61 field.
value62
Optional. Holds the contents of the user-defined value62 field.
value63
Optional. Holds the contents of the user-defined value63 field.
value64
Optional. Holds the contents of the user-defined value64 field.
lastEditAt

Optional. Holds the date and 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 and time value when the record was updated by this called method.

Remarks

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.

See Also

Reference

DataLog Class
DataLog Members

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