Api.JetSetColumn method (JET_SESID, JET_TABLEID, JET_COLUMNID, Byte , Int32, SetColumnGrbit, JET_SETINFO)
The JetSetColumn function modifies a single column value in a modified record to be inserted or to update the current record. It can overwrite an existing value, add a new value to a sequence of values in a multi-valued column, remove a value from a sequence of values in a multi-valued column, or update all or part of a long value (a column of type LongText or LongBinary).
Namespace: Microsoft.Isam.Esent.Interop
Assembly: Microsoft.Isam.Esent.Interop (in Microsoft.Isam.Esent.Interop.dll)
Syntax
'Declaration
Public Shared Function JetSetColumn ( _
sesid As JET_SESID, _
tableid As JET_TABLEID, _
columnid As JET_COLUMNID, _
data As Byte(), _
dataSize As Integer, _
grbit As SetColumnGrbit, _
setinfo As JET_SETINFO _
) As JET_wrn
'Usage
Dim sesid As JET_SESID
Dim tableid As JET_TABLEID
Dim columnid As JET_COLUMNID
Dim data As Byte()
Dim dataSize As Integer
Dim grbit As SetColumnGrbit
Dim setinfo As JET_SETINFO
Dim returnValue As JET_wrn
returnValue = Api.JetSetColumn(sesid, _
tableid, columnid, data, dataSize, _
grbit, setinfo)
public static JET_wrn JetSetColumn(
JET_SESID sesid,
JET_TABLEID tableid,
JET_COLUMNID columnid,
byte[] data,
int dataSize,
SetColumnGrbit grbit,
JET_SETINFO setinfo
)
Parameters
sesid
Type: Microsoft.Isam.Esent.Interop.JET_SESIDThe session which is performing the update.
tableid
Type: Microsoft.Isam.Esent.Interop.JET_TABLEIDThe cursor to update. An update should be prepared.
columnid
Type: Microsoft.Isam.Esent.Interop.JET_COLUMNIDThe columnid to set.
data
Type: []The data to set.
dataSize
Type: System.Int32The size of data to set.
grbit
Type: Microsoft.Isam.Esent.Interop.SetColumnGrbitSetColumn options.
setinfo
Type: Microsoft.Isam.Esent.Interop.JET_SETINFOUsed to specify itag or long-value offset.
Return value
Type: Microsoft.Isam.Esent.Interop.JET_wrn
A warning code.
Remarks
The SetColumn methods provide datatype-specific overrides which may be more efficient.