ホーム › Storage.Jet › JetSetColumn
JetSetColumn
関数更新準備中のレコードに列の値を設定する。
シグネチャ
// ESENT.dll
#include <windows.h>
INT JetSetColumn(
JET_SESID sesid,
JET_TABLEID tableid,
DWORD columnid,
void* pvData, // optional
DWORD cbData,
DWORD grbit,
JET_SETINFO* psetinfo // optional
);パラメーター
| 名前 | 型 | 方向 |
|---|---|---|
| sesid | JET_SESID | in |
| tableid | JET_TABLEID | in |
| columnid | DWORD | in |
| pvData | void* | inoptional |
| cbData | DWORD | in |
| grbit | DWORD | in |
| psetinfo | JET_SETINFO* | inoptional |
戻り値の型: INT
各言語での呼び出し定義
// ESENT.dll
#include <windows.h>
INT JetSetColumn(
JET_SESID sesid,
JET_TABLEID tableid,
DWORD columnid,
void* pvData, // optional
DWORD cbData,
DWORD grbit,
JET_SETINFO* psetinfo // optional
);[DllImport("ESENT.dll", ExactSpelling = true)]
static extern int JetSetColumn(
UIntPtr sesid, // JET_SESID
UIntPtr tableid, // JET_TABLEID
uint columnid, // DWORD
IntPtr pvData, // void* optional
uint cbData, // DWORD
uint grbit, // DWORD
IntPtr psetinfo // JET_SETINFO* optional
);<DllImport("ESENT.dll", ExactSpelling:=True)>
Public Shared Function JetSetColumn(
sesid As UIntPtr, ' JET_SESID
tableid As UIntPtr, ' JET_TABLEID
columnid As UInteger, ' DWORD
pvData As IntPtr, ' void* optional
cbData As UInteger, ' DWORD
grbit As UInteger, ' DWORD
psetinfo As IntPtr ' JET_SETINFO* optional
) As Integer
End Function' sesid : JET_SESID
' tableid : JET_TABLEID
' columnid : DWORD
' pvData : void* optional
' cbData : DWORD
' grbit : DWORD
' psetinfo : JET_SETINFO* optional
Declare PtrSafe Function JetSetColumn Lib "esent" ( _
ByVal sesid As LongPtr, _
ByVal tableid As LongPtr, _
ByVal columnid As Long, _
ByVal pvData As LongPtr, _
ByVal cbData As Long, _
ByVal grbit As Long, _
ByVal psetinfo As LongPtr) As Long
' VBA7前提(PtrSafe)。32bit Office では LongPtr→Long。Integer=16bit / Long=32bit / LongLong=64bit。import ctypes
from ctypes import wintypes
JetSetColumn = ctypes.windll.esent.JetSetColumn
JetSetColumn.restype = ctypes.c_int
JetSetColumn.argtypes = [
ctypes.c_size_t, # sesid : JET_SESID
ctypes.c_size_t, # tableid : JET_TABLEID
wintypes.DWORD, # columnid : DWORD
ctypes.POINTER(None), # pvData : void* optional
wintypes.DWORD, # cbData : DWORD
wintypes.DWORD, # grbit : DWORD
ctypes.c_void_p, # psetinfo : JET_SETINFO* optional
]require 'fiddle'
require 'fiddle/import'
lib = Fiddle.dlopen('ESENT.dll')
JetSetColumn = Fiddle::Function.new(
lib['JetSetColumn'],
[
Fiddle::TYPE_UINTPTR_T, # sesid : JET_SESID
Fiddle::TYPE_UINTPTR_T, # tableid : JET_TABLEID
-Fiddle::TYPE_INT, # columnid : DWORD
Fiddle::TYPE_VOIDP, # pvData : void* optional
-Fiddle::TYPE_INT, # cbData : DWORD
-Fiddle::TYPE_INT, # grbit : DWORD
Fiddle::TYPE_VOIDP, # psetinfo : JET_SETINFO* optional
],
Fiddle::TYPE_INT)#[link(name = "esent")]
extern "system" {
fn JetSetColumn(
sesid: usize, // JET_SESID
tableid: usize, // JET_TABLEID
columnid: u32, // DWORD
pvData: *mut (), // void* optional
cbData: u32, // DWORD
grbit: u32, // DWORD
psetinfo: *mut JET_SETINFO // JET_SETINFO* optional
) -> i32;
}
// crates: windows-sys provides ready-made bindings for this API.$sig = @"
[DllImport("ESENT.dll")]
public static extern int JetSetColumn(UIntPtr sesid, UIntPtr tableid, uint columnid, IntPtr pvData, uint cbData, uint grbit, IntPtr psetinfo);
"@
$api = Add-Type -MemberDefinition $sig -Name 'ESENT_JetSetColumn' -Namespace Win32 -PassThru
# $api::JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, psetinfo)#uselib "ESENT.dll"
#func global JetSetColumn "JetSetColumn" sptr, sptr, sptr, sptr, sptr, sptr, sptr
; JetSetColumn sesid, tableid, columnid, pvData, cbData, grbit, varptr(psetinfo) ; 戻り値は stat
; sesid : JET_SESID -> "sptr"
; tableid : JET_TABLEID -> "sptr"
; columnid : DWORD -> "sptr"
; pvData : void* optional -> "sptr"
; cbData : DWORD -> "sptr"
; grbit : DWORD -> "sptr"
; psetinfo : JET_SETINFO* optional -> "sptr"
; ※HSP3.7は #func のため戻り値はシステム変数 stat に格納されます。出力引数:
#uselib "ESENT.dll" #cfunc global JetSetColumn "JetSetColumn" sptr, sptr, int, sptr, int, int, var ; res = JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, psetinfo) ; sesid : JET_SESID -> "sptr" ; tableid : JET_TABLEID -> "sptr" ; columnid : DWORD -> "int" ; pvData : void* optional -> "sptr" ; cbData : DWORD -> "int" ; grbit : DWORD -> "int" ; psetinfo : JET_SETINFO* optional -> "var" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。#uselib "ESENT.dll" #cfunc global JetSetColumn "JetSetColumn" sptr, sptr, int, sptr, int, int, sptr ; res = JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, varptr(psetinfo)) ; sesid : JET_SESID -> "sptr" ; tableid : JET_TABLEID -> "sptr" ; columnid : DWORD -> "int" ; pvData : void* optional -> "sptr" ; cbData : DWORD -> "int" ; grbit : DWORD -> "int" ; psetinfo : JET_SETINFO* optional -> "sptr" ; ※出力/バッファ引数はポインタ方式(token=sptr / 呼び出しは varptr(変数))。
出力引数:
; INT JetSetColumn(JET_SESID sesid, JET_TABLEID tableid, DWORD columnid, void* pvData, DWORD cbData, DWORD grbit, JET_SETINFO* psetinfo) #uselib "ESENT.dll" #cfunc global JetSetColumn "JetSetColumn" intptr, intptr, int, intptr, int, int, var ; res = JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, psetinfo) ; sesid : JET_SESID -> "intptr" ; tableid : JET_TABLEID -> "intptr" ; columnid : DWORD -> "int" ; pvData : void* optional -> "intptr" ; cbData : DWORD -> "int" ; grbit : DWORD -> "int" ; psetinfo : JET_SETINFO* optional -> "var" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。; INT JetSetColumn(JET_SESID sesid, JET_TABLEID tableid, DWORD columnid, void* pvData, DWORD cbData, DWORD grbit, JET_SETINFO* psetinfo) #uselib "ESENT.dll" #cfunc global JetSetColumn "JetSetColumn" intptr, intptr, int, intptr, int, int, intptr ; res = JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, varptr(psetinfo)) ; sesid : JET_SESID -> "intptr" ; tableid : JET_TABLEID -> "intptr" ; columnid : DWORD -> "int" ; pvData : void* optional -> "intptr" ; cbData : DWORD -> "int" ; grbit : DWORD -> "int" ; psetinfo : JET_SETINFO* optional -> "intptr" ; ※出力/バッファ引数はポインタ方式(token=intptr / 呼び出しは varptr(変数))。
import (
"golang.org/x/sys/windows"
"unsafe"
)
var (
esent = windows.NewLazySystemDLL("ESENT.dll")
procJetSetColumn = esent.NewProc("JetSetColumn")
)
// sesid (JET_SESID), tableid (JET_TABLEID), columnid (DWORD), pvData (void* optional), cbData (DWORD), grbit (DWORD), psetinfo (JET_SETINFO* optional)
r1, _, err := procJetSetColumn.Call(
uintptr(sesid),
uintptr(tableid),
uintptr(columnid),
uintptr(pvData),
uintptr(cbData),
uintptr(grbit),
uintptr(psetinfo),
)
_ = err // syscall.Errno (valid when the call sets last-error)
_ = r1 // INTfunction JetSetColumn(
sesid: NativeUInt; // JET_SESID
tableid: NativeUInt; // JET_TABLEID
columnid: DWORD; // DWORD
pvData: Pointer; // void* optional
cbData: DWORD; // DWORD
grbit: DWORD; // DWORD
psetinfo: Pointer // JET_SETINFO* optional
): Integer; stdcall;
external 'ESENT.dll' name 'JetSetColumn';result := DllCall("ESENT\JetSetColumn"
, "UPtr", sesid ; JET_SESID
, "UPtr", tableid ; JET_TABLEID
, "UInt", columnid ; DWORD
, "Ptr", pvData ; void* optional
, "UInt", cbData ; DWORD
, "UInt", grbit ; DWORD
, "Ptr", psetinfo ; JET_SETINFO* optional
, "Int") ; return: INT●JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, psetinfo) = DLL("ESENT.dll", "int JetSetColumn(int, int, dword, void*, dword, dword, void*)")
# 呼び出し: JetSetColumn(sesid, tableid, columnid, pvData, cbData, grbit, psetinfo)
# sesid : JET_SESID -> "int"
# tableid : JET_TABLEID -> "int"
# columnid : DWORD -> "dword"
# pvData : void* optional -> "void*"
# cbData : DWORD -> "dword"
# grbit : DWORD -> "dword"
# psetinfo : JET_SETINFO* optional -> "void*"
# なでしこ1は32bit・ANSI(Shift_JIS)。文字列=char*(ANSI)、ポインタ/ハンドル=void*(4byte)。