ホーム › Storage.Jet › JetGetTableColumnInfoW
JetGetTableColumnInfoW
関数テーブルIDで指定したテーブルの列情報を取得する(Unicode版)。
シグネチャ
// ESENT.dll (Unicode / -W)
#include <windows.h>
INT JetGetTableColumnInfoW(
JET_SESID sesid,
JET_TABLEID tableid,
WORD* szColumnName, // optional
void* pvResult,
DWORD cbMax,
DWORD InfoLevel
);パラメーター
| 名前 | 型 | 方向 | 説明 |
|---|---|---|---|
| sesid | JET_SESID | in | 操作に使用するセッションID。 |
| tableid | JET_TABLEID | in | 対象テーブルのカーソルID。 |
| szColumnName | WORD* | inoptional | 情報を取得する列名を指すワイド文字列(WORD*)。 |
| pvResult | void* | out | 取得した列情報を受け取る出力バッファへのポインタ。 |
| cbMax | DWORD | in | pvResultバッファのバイトサイズ。 |
| InfoLevel | DWORD | in | 取得する情報レベル(JET_ColInfo系定数)。 |
戻り値の型: INT
各言語での呼び出し定義
// ESENT.dll (Unicode / -W)
#include <windows.h>
INT JetGetTableColumnInfoW(
JET_SESID sesid,
JET_TABLEID tableid,
WORD* szColumnName, // optional
void* pvResult,
DWORD cbMax,
DWORD InfoLevel
);[DllImport("ESENT.dll", CharSet = CharSet.Unicode, ExactSpelling = true)]
static extern int JetGetTableColumnInfoW(
UIntPtr sesid, // JET_SESID
UIntPtr tableid, // JET_TABLEID
IntPtr szColumnName, // WORD* optional
IntPtr pvResult, // void* out
uint cbMax, // DWORD
uint InfoLevel // DWORD
);<DllImport("ESENT.dll", CharSet:=CharSet.Unicode, ExactSpelling:=True)>
Public Shared Function JetGetTableColumnInfoW(
sesid As UIntPtr, ' JET_SESID
tableid As UIntPtr, ' JET_TABLEID
szColumnName As IntPtr, ' WORD* optional
pvResult As IntPtr, ' void* out
cbMax As UInteger, ' DWORD
InfoLevel As UInteger ' DWORD
) As Integer
End Function' sesid : JET_SESID
' tableid : JET_TABLEID
' szColumnName : WORD* optional
' pvResult : void* out
' cbMax : DWORD
' InfoLevel : DWORD
Declare PtrSafe Function JetGetTableColumnInfoW Lib "esent" ( _
ByVal sesid As LongPtr, _
ByVal tableid As LongPtr, _
ByVal szColumnName As LongPtr, _
ByVal pvResult As LongPtr, _
ByVal cbMax As Long, _
ByVal InfoLevel As Long) As Long
' Unicode(W): 文字列は ByVal As LongPtr とし StrPtr(unicodeStr) を渡す
' VBA7前提(PtrSafe)。32bit Office では LongPtr→Long。Integer=16bit / Long=32bit / LongLong=64bit。import ctypes
from ctypes import wintypes
JetGetTableColumnInfoW = ctypes.windll.esent.JetGetTableColumnInfoW
JetGetTableColumnInfoW.restype = ctypes.c_int
JetGetTableColumnInfoW.argtypes = [
ctypes.c_size_t, # sesid : JET_SESID
ctypes.c_size_t, # tableid : JET_TABLEID
ctypes.POINTER(ctypes.c_ushort), # szColumnName : WORD* optional
ctypes.POINTER(None), # pvResult : void* out
wintypes.DWORD, # cbMax : DWORD
wintypes.DWORD, # InfoLevel : DWORD
]require 'fiddle'
require 'fiddle/import'
lib = Fiddle.dlopen('ESENT.dll')
JetGetTableColumnInfoW = Fiddle::Function.new(
lib['JetGetTableColumnInfoW'],
[
Fiddle::TYPE_UINTPTR_T, # sesid : JET_SESID
Fiddle::TYPE_UINTPTR_T, # tableid : JET_TABLEID
Fiddle::TYPE_VOIDP, # szColumnName : WORD* optional
Fiddle::TYPE_VOIDP, # pvResult : void* out
-Fiddle::TYPE_INT, # cbMax : DWORD
-Fiddle::TYPE_INT, # InfoLevel : DWORD
],
Fiddle::TYPE_INT)
# Wide strings: pass str.encode("UTF-16LE") + "\x00\x00"#[link(name = "esent")]
extern "system" {
fn JetGetTableColumnInfoW(
sesid: usize, // JET_SESID
tableid: usize, // JET_TABLEID
szColumnName: *mut u16, // WORD* optional
pvResult: *mut (), // void* out
cbMax: u32, // DWORD
InfoLevel: u32 // DWORD
) -> i32;
}
// crates: windows-sys provides ready-made bindings for this API.$sig = @"
[DllImport("ESENT.dll", CharSet = CharSet.Unicode)]
public static extern int JetGetTableColumnInfoW(UIntPtr sesid, UIntPtr tableid, IntPtr szColumnName, IntPtr pvResult, uint cbMax, uint InfoLevel);
"@
$api = Add-Type -MemberDefinition $sig -Name 'ESENT_JetGetTableColumnInfoW' -Namespace Win32 -PassThru
# $api::JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)#uselib "ESENT.dll"
#func global JetGetTableColumnInfoW "JetGetTableColumnInfoW" wptr, wptr, wptr, wptr, wptr, wptr
; JetGetTableColumnInfoW sesid, tableid, varptr(szColumnName), pvResult, cbMax, InfoLevel ; 戻り値は stat
; sesid : JET_SESID -> "wptr"
; tableid : JET_TABLEID -> "wptr"
; szColumnName : WORD* optional -> "wptr"
; pvResult : void* out -> "wptr"
; cbMax : DWORD -> "wptr"
; InfoLevel : DWORD -> "wptr"
; ※HSP3.7は #func のため戻り値はシステム変数 stat に格納されます。出力引数:
#uselib "ESENT.dll" #cfunc global JetGetTableColumnInfoW "JetGetTableColumnInfoW" sptr, sptr, var, sptr, int, int ; res = JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel) ; sesid : JET_SESID -> "sptr" ; tableid : JET_TABLEID -> "sptr" ; szColumnName : WORD* optional -> "var" ; pvResult : void* out -> "sptr" ; cbMax : DWORD -> "int" ; InfoLevel : DWORD -> "int" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。#uselib "ESENT.dll" #cfunc global JetGetTableColumnInfoW "JetGetTableColumnInfoW" sptr, sptr, sptr, sptr, int, int ; res = JetGetTableColumnInfoW(sesid, tableid, varptr(szColumnName), pvResult, cbMax, InfoLevel) ; sesid : JET_SESID -> "sptr" ; tableid : JET_TABLEID -> "sptr" ; szColumnName : WORD* optional -> "sptr" ; pvResult : void* out -> "sptr" ; cbMax : DWORD -> "int" ; InfoLevel : DWORD -> "int" ; ※出力/バッファ引数はポインタ方式(token=sptr / 呼び出しは varptr(変数))。
出力引数:
; INT JetGetTableColumnInfoW(JET_SESID sesid, JET_TABLEID tableid, WORD* szColumnName, void* pvResult, DWORD cbMax, DWORD InfoLevel) #uselib "ESENT.dll" #cfunc global JetGetTableColumnInfoW "JetGetTableColumnInfoW" intptr, intptr, var, intptr, int, int ; res = JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel) ; sesid : JET_SESID -> "intptr" ; tableid : JET_TABLEID -> "intptr" ; szColumnName : WORD* optional -> "var" ; pvResult : void* out -> "intptr" ; cbMax : DWORD -> "int" ; InfoLevel : DWORD -> "int" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。; INT JetGetTableColumnInfoW(JET_SESID sesid, JET_TABLEID tableid, WORD* szColumnName, void* pvResult, DWORD cbMax, DWORD InfoLevel) #uselib "ESENT.dll" #cfunc global JetGetTableColumnInfoW "JetGetTableColumnInfoW" intptr, intptr, intptr, intptr, int, int ; res = JetGetTableColumnInfoW(sesid, tableid, varptr(szColumnName), pvResult, cbMax, InfoLevel) ; sesid : JET_SESID -> "intptr" ; tableid : JET_TABLEID -> "intptr" ; szColumnName : WORD* optional -> "intptr" ; pvResult : void* out -> "intptr" ; cbMax : DWORD -> "int" ; InfoLevel : DWORD -> "int" ; ※出力/バッファ引数はポインタ方式(token=intptr / 呼び出しは varptr(変数))。
import (
"golang.org/x/sys/windows"
"unsafe"
)
var (
esent = windows.NewLazySystemDLL("ESENT.dll")
procJetGetTableColumnInfoW = esent.NewProc("JetGetTableColumnInfoW")
)
// sesid (JET_SESID), tableid (JET_TABLEID), szColumnName (WORD* optional), pvResult (void* out), cbMax (DWORD), InfoLevel (DWORD)
r1, _, err := procJetGetTableColumnInfoW.Call(
uintptr(sesid),
uintptr(tableid),
uintptr(szColumnName),
uintptr(pvResult),
uintptr(cbMax),
uintptr(InfoLevel),
)
_ = err // syscall.Errno (valid when the call sets last-error)
_ = r1 // INTfunction JetGetTableColumnInfoW(
sesid: NativeUInt; // JET_SESID
tableid: NativeUInt; // JET_TABLEID
szColumnName: Pointer; // WORD* optional
pvResult: Pointer; // void* out
cbMax: DWORD; // DWORD
InfoLevel: DWORD // DWORD
): Integer; stdcall;
external 'ESENT.dll' name 'JetGetTableColumnInfoW';result := DllCall("ESENT\JetGetTableColumnInfoW"
, "UPtr", sesid ; JET_SESID
, "UPtr", tableid ; JET_TABLEID
, "Ptr", szColumnName ; WORD* optional
, "Ptr", pvResult ; void* out
, "UInt", cbMax ; DWORD
, "UInt", InfoLevel ; DWORD
, "Int") ; return: INT●JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel) = DLL("ESENT.dll", "int JetGetTableColumnInfoW(int, int, void*, void*, dword, dword)")
# 呼び出し: JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)
# sesid : JET_SESID -> "int"
# tableid : JET_TABLEID -> "int"
# szColumnName : WORD* optional -> "void*"
# pvResult : void* out -> "void*"
# cbMax : DWORD -> "dword"
# InfoLevel : DWORD -> "dword"
# なでしこ1は32bit・ANSI(Shift_JIS)。文字列=char*(ANSI)、ポインタ/ハンドル=void*(4byte)。
# ※-W(Unicode)関数。なでしこ1はANSIのため -A 版の利用を推奨。const std = @import("std");
extern "esent" fn JetGetTableColumnInfoW(
sesid: usize, // JET_SESID
tableid: usize, // JET_TABLEID
szColumnName: [*c]u16, // WORD* optional
pvResult: ?*anyopaque, // void* out
cbMax: u32, // DWORD
InfoLevel: u32 // DWORD
) callconv(std.os.windows.WINAPI) i32;
// Unicode(-W): UTF-16LE のヌル終端バッファ([*c]const u16)を渡す。proc JetGetTableColumnInfoW(
sesid: uint, # JET_SESID
tableid: uint, # JET_TABLEID
szColumnName: ptr uint16, # WORD* optional
pvResult: pointer, # void* out
cbMax: uint32, # DWORD
InfoLevel: uint32 # DWORD
): int32 {.importc: "JetGetTableColumnInfoW", stdcall, dynlib: "ESENT.dll".}
# Unicode(-W): WideCString は newWideCString("...") で生成。pragma(lib, "esent");
extern(Windows)
int JetGetTableColumnInfoW(
size_t sesid, // JET_SESID
size_t tableid, // JET_TABLEID
ushort* szColumnName, // WORD* optional
void* pvResult, // void* out
uint cbMax, // DWORD
uint InfoLevel // DWORD
);ccall((:JetGetTableColumnInfoW, "ESENT.dll"), stdcall, Int32,
(Csize_t, Csize_t, Ptr{UInt16}, Ptr{Cvoid}, UInt32, UInt32),
sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)
# sesid : JET_SESID -> Csize_t
# tableid : JET_TABLEID -> Csize_t
# szColumnName : WORD* optional -> Ptr{UInt16}
# pvResult : void* out -> Ptr{Cvoid}
# cbMax : DWORD -> UInt32
# InfoLevel : DWORD -> UInt32
# stdcall は 32bit のみ意味を持つ(x64 では無視)。
# Unicode(-W): Cwstring には transcode(UInt16, "...") 等で UTF-16 を渡す。local ffi = require("ffi")
ffi.cdef[[
int32_t JetGetTableColumnInfoW(
uintptr_t sesid,
uintptr_t tableid,
uint16_t* szColumnName,
void* pvResult,
uint32_t cbMax,
uint32_t InfoLevel);
]]
local esent = ffi.load("esent")
-- esent.JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)
-- sesid : JET_SESID
-- tableid : JET_TABLEID
-- szColumnName : WORD* optional
-- pvResult : void* out
-- cbMax : DWORD
-- InfoLevel : DWORD
-- 構造体/GUIDへのポインタは cdef が通るよう void* で表記(実型は各引数コメント参照)。値渡し構造体・enum は対応する typedef を cdef に追加すること。
-- Unicode(-W): uint16_t* には UTF-16LE のバッファ(ffi.new("uint16_t[?]", ...))を渡す。const koffi = require('koffi');
const lib = koffi.load('ESENT.dll');
const JetGetTableColumnInfoW = lib.func('__stdcall', 'JetGetTableColumnInfoW', 'int32_t', ['uintptr_t', 'uintptr_t', 'uint16_t *', 'void *', 'uint32_t', 'uint32_t']);
// JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)
// sesid : JET_SESID -> 'uintptr_t'
// tableid : JET_TABLEID -> 'uintptr_t'
// szColumnName : WORD* optional -> 'uint16_t *'
// pvResult : void* out -> 'void *'
// cbMax : DWORD -> 'uint32_t'
// InfoLevel : DWORD -> 'uint32_t'
// 出力ポインタは koffi.out(...) で包む。構造体は koffi.struct で定義。const lib = Deno.dlopen("ESENT.dll", {
JetGetTableColumnInfoW: { parameters: ["usize", "usize", "pointer", "pointer", "u32", "u32"], result: "i32" },
});
// lib.symbols.JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel)
// sesid : JET_SESID -> "usize"
// tableid : JET_TABLEID -> "usize"
// szColumnName : WORD* optional -> "pointer"
// pvResult : void* out -> "pointer"
// cbMax : DWORD -> "u32"
// InfoLevel : DWORD -> "u32"
// 文字列は "buffer"。Unicode(-W) は new TextEncoder() ではなく UTF-16LE のバイト列(末尾に \x00\x00)を Uint8Array で渡す。
// 値渡し構造体は { struct: [ ...field types... ] } を使用。<?php
$ffi = FFI::cdef(<<<C
int32_t JetGetTableColumnInfoW(
size_t sesid,
size_t tableid,
uint16_t* szColumnName,
void* pvResult,
uint32_t cbMax,
uint32_t InfoLevel);
C, "ESENT.dll");
// $ffi->JetGetTableColumnInfoW(sesid, tableid, szColumnName, pvResult, cbMax, InfoLevel);
// sesid : JET_SESID
// tableid : JET_TABLEID
// szColumnName : WORD* optional
// pvResult : void* out
// cbMax : DWORD
// InfoLevel : DWORD
// 構造体/GUIDへのポインタは cdef が通るよう void* で表記(実型は各引数コメント参照)。値渡し構造体・enum は対応する typedef を cdef に追加すること。
// WINAPI(stdcall): x64 では呼出規約が統一されるため問題なし。x86 では __stdcall 対応のラッパが必要な場合あり。import com.sun.jna.*;
import com.sun.jna.ptr.*;
import com.sun.jna.win32.StdCallLibrary;
import com.sun.jna.win32.W32APIOptions;
public interface Esent extends StdCallLibrary {
Esent INSTANCE = Native.load("esent", Esent.class, W32APIOptions.UNICODE_OPTIONS);
int JetGetTableColumnInfoW(
long sesid, // JET_SESID
long tableid, // JET_TABLEID
ShortByReference szColumnName, // WORD* optional
Pointer pvResult, // void* out
int cbMax, // DWORD
int InfoLevel // DWORD
);
}
// Unicode(-W): WString(入力)/char[](出力)で UTF-16 をマーシャリング。@[Link("esent")]
lib LibESENT
fun JetGetTableColumnInfoW = JetGetTableColumnInfoW(
sesid : LibC::SizeT, # JET_SESID
tableid : LibC::SizeT, # JET_TABLEID
szColumnName : UInt16*, # WORD* optional
pvResult : Void*, # void* out
cbMax : UInt32, # DWORD
InfoLevel : UInt32 # DWORD
) : Int32
end
# 構造体/GUID/enum は lib 内に対応する型定義が必要。
# 呼出規約: x64 は規約統一のため OK。x86(32bit)は WINAPI=stdcall だが Crystal の fun に stdcall 付与構文がなく非対応。import 'dart:ffi';
import 'package:ffi/ffi.dart';
typedef JetGetTableColumnInfoWNative = Int32 Function(UintPtr, UintPtr, Pointer<Uint16>, Pointer<Void>, Uint32, Uint32);
typedef JetGetTableColumnInfoWDart = int Function(int, int, Pointer<Uint16>, Pointer<Void>, int, int);
final JetGetTableColumnInfoW = DynamicLibrary.open('ESENT.dll')
.lookupFunction<JetGetTableColumnInfoWNative, JetGetTableColumnInfoWDart>('JetGetTableColumnInfoW');
// sesid : JET_SESID -> UintPtr
// tableid : JET_TABLEID -> UintPtr
// szColumnName : WORD* optional -> Pointer<Uint16>
// pvResult : void* out -> Pointer<Void>
// cbMax : DWORD -> Uint32
// InfoLevel : DWORD -> Uint32
// 文字列は package:ffi の "...".toNativeUtf16()/toNativeUtf8() で変換。{$mode objfpc}{$H+}
function JetGetTableColumnInfoW(
sesid: NativeUInt; // JET_SESID
tableid: NativeUInt; // JET_TABLEID
szColumnName: Pointer; // WORD* optional
pvResult: Pointer; // void* out
cbMax: DWORD; // DWORD
InfoLevel: DWORD // DWORD
): Integer; stdcall;
external 'ESENT.dll' name 'JetGetTableColumnInfoW';import Foreign
import Foreign.C.Types
import Foreign.C.String
foreign import stdcall safe "JetGetTableColumnInfoW"
c_JetGetTableColumnInfoW :: CUIntPtr -> CUIntPtr -> Ptr Word16 -> Ptr () -> Word32 -> Word32 -> IO Int32
-- sesid : JET_SESID -> CUIntPtr
-- tableid : JET_TABLEID -> CUIntPtr
-- szColumnName : WORD* optional -> Ptr Word16
-- pvResult : void* out -> Ptr ()
-- cbMax : DWORD -> Word32
-- InfoLevel : DWORD -> Word32
-- 要 GHC(Windows)。stdcall は x64 では ccall として扱われる。ブロックする API は safe 呼び出し推奨。open Ctypes
open Foreign
let jetgettablecolumninfow =
foreign "JetGetTableColumnInfoW"
(size_t @-> size_t @-> (ptr uint16_t) @-> (ptr void) @-> uint32_t @-> uint32_t @-> returning int32_t)
(* sesid : JET_SESID -> size_t *)
(* tableid : JET_TABLEID -> size_t *)
(* szColumnName : WORD* optional -> (ptr uint16_t) *)
(* pvResult : void* out -> (ptr void) *)
(* cbMax : DWORD -> uint32_t *)
(* InfoLevel : DWORD -> uint32_t *)
(* foreign は cdecl 前提。x64 Windows では WINAPI と一致。構造体は ctypes structure を定義のこと。 *)(cffi:define-foreign-library esent (t "ESENT.dll"))
(cffi:use-foreign-library esent)
(cffi:defcfun ("JetGetTableColumnInfoW" jet-get-table-column-info-w :convention :stdcall) :int32
(sesid :uint64) ; JET_SESID
(tableid :uint64) ; JET_TABLEID
(sz-column-name :pointer) ; WORD* optional
(pv-result :pointer) ; void* out
(cb-max :uint32) ; DWORD
(info-level :uint32)) ; DWORD
; isize/usize(INT_PTR/SIZE_T)は x64 前提で :int64/:uint64。x86 では :int32/:uint32。use Win32::API;
my $JetGetTableColumnInfoW = Win32::API::More->new('ESENT',
'int JetGetTableColumnInfoW(WPARAM sesid, WPARAM tableid, LPVOID szColumnName, LPVOID pvResult, DWORD cbMax, DWORD InfoLevel)');
# my $ret = $JetGetTableColumnInfoW->Call($sesid, $tableid, $szColumnName, $pvResult, $cbMax, $InfoLevel);
# sesid : JET_SESID -> WPARAM
# tableid : JET_TABLEID -> WPARAM
# szColumnName : WORD* optional -> LPVOID
# pvResult : void* out -> LPVOID
# cbMax : DWORD -> DWORD
# InfoLevel : DWORD -> DWORD
# 値渡し構造体は pack() した文字列、または Win32::API::Struct を使用。
# Unicode(-W): LPCWSTR/LPWSTR は Win32::API が UTF-16 変換を行う。関連項目
文字セット違い
- f JetGetTableColumnInfoA (ANSI版) — テーブルIDで指定したテーブルの列情報を取得する(ANSI版)。