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

Update Method (DataLog48)

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

The Update() method updates all fields for the specified data log record in the Data_Log table, except for the grp_id field.

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 Update( _
   ByVal sessionId As Integer, _
   ByVal rowId As Integer, _
   ByVal grpId As Integer, _
   ByVal sampleTimeLocal As 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 Date, _
   ByVal shiftId As 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 Integer
Dim sampleTimeLocal As 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 Date
Dim shiftId As 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.Update(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 Update( 
   int sessionId,
   int rowId,
   int grpId,
   DateTime sampleTimeLocal,
   DBString woId,
   DBString operId,
   DBInt seqNo,
   DBInt stepNo,
   DBString itemId,
   DBString lotNo,
   DBString sublotNo,
   DateTime shiftStartLocal,
   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

Required. Holds the ID of the data log group.

Note: Changes to the grp_id field in the table are ignored and not made.

sampleTimeLocal
Required. Holds the date and time when sample was first taken, in local time.
woId
Required. Holds the ID of the work order.
operId
Required. Holds the ID of the operation.
seqNo
Required. Holds the operation sequence number.
stepNo
Required. Holds the step number of the job.
itemId
Required. Holds the ID of the item.
lotNo
Required. Holds the lot number of the item.
sublotNo
Required. Holds the sublot number of the item.
shiftStartLocal
Required. Holds the date and time when the shift started, in local time.
shiftId
Required. Holds the ID of the shift.
entId
Required. Holds the ID of the entity.
value1
Required. Holds the contents of the user-defined value1 field.
value2
Required. Holds the contents of the user-defined value2 field.
value3
Required. Holds the contents of the user-defined value3 field.
value4
Required. Holds the contents of the user-defined value4 field.
value5
Required. Holds the contents of the user-defined value5 field.
value6
Required. Holds the contents of the user-defined value6 field.
value7
Required. Holds the contents of the user-defined value7 field.
value8
Required. Holds the contents of the user-defined value8 field.
value9
Required. Holds the contents of the user-defined value9 field.
value10
Required. Holds the contents of the user-defined value10 field.
value11
Required. Holds the contents of the user-defined value11 field.
value12
Required. Holds the contents of the user-defined value12 field.
value13
Required. Holds the contents of the user-defined value13 field.
value14
Required. Holds the contents of the user-defined value14 field.
value15
Required. Holds the contents of the user-defined value15 field.
value16
Required. Holds the contents of the user-defined value16 field.
value17
Required. Holds the contents of the user-defined value17 field.
value18
Required. Holds the contents of the user-defined value18 field.
value19
Required. Holds the contents of the user-defined value19 field.
value20
Required. Holds the contents of the user-defined value20 field.
value21
Required. Holds the contents of the user-defined value21 field.
value22
Required. Holds the contents of the user-defined value22 field.
value23
Required. Holds the contents of the user-defined value23 field.
value24
Required. Holds the contents of the user-defined value24 field.
value25
Required. Holds the contents of the user-defined value25 field.
value26
Required. Holds the contents of the user-defined value26 field.
value27
Required. Holds the contents of the user-defined value27 field.
value28
Required. Holds the contents of the user-defined value28 field.
value29
Required. Holds the contents of the user-defined value29 field.
value30
Required. Holds the contents of the user-defined value30 field.
value31
Required. Holds the contents of the user-defined value31 field.
value32
Required. Holds the contents of the user-defined value32 field.
value33
Required. Holds the contents of the user-defined value33 field.
value34
Required. Holds the contents of the user-defined value34 field.
value35
Required. Holds the contents of the user-defined value35 field.
value36
Required. Holds the contents of the user-defined value36 field.
value37
Required. Holds the contents of the user-defined value37 field.
value38
Required. Holds the contents of the user-defined value38 field.
value39
Required. Holds the contents of the user-defined value39 field.
value40
Required. Holds the contents of the user-defined value40 field.
value41
Required. Holds the contents of the user-defined value41 field.
value42
Required. Holds the contents of the user-defined value42 field.
value43
Required. Holds the contents of the user-defined value43 field.
value44
Required. Holds the contents of the user-defined value44 field.
value45
Required. Holds the contents of the user-defined value45 field.
value46
Required. Holds the contents of the user-defined value46 field.
value47
Required. Holds the contents of the user-defined value47 field.
value48
Required. Holds the contents of the user-defined value48 field.
lastEditComment
Required. 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