ホーム › Storage.Jet › JetOpenTempTable2
JetOpenTempTable2
関数ロケール指定付きで一時テーブルを開く。
シグネチャ
// ESENT.dll
#include <windows.h>
INT JetOpenTempTable2(
JET_SESID sesid,
const JET_COLUMNDEF* prgcolumndef,
DWORD ccolumn,
DWORD lcid,
DWORD grbit,
JET_TABLEID* ptableid,
DWORD* prgcolumnid
);パラメーター
| 名前 | 型 | 方向 | 説明 |
|---|---|---|---|
| sesid | JET_SESID | in | 一時テーブル作成を行うセッションのJET_SESIDハンドル。 |
| prgcolumndef | JET_COLUMNDEF* | in | 一時テーブルの列定義を保持するJET_COLUMNDEF配列のポインタ。 |
| ccolumn | DWORD | in | prgcolumndef配列の列数を指定する値。 |
| lcid | DWORD | in | 並べ替えに用いるロケールID(LCID)。文字列照合順序を決定する。 |
| grbit | DWORD | in | 一時テーブル動作を制御するビットフラグ。並べ替えや一意性などを指定する。 |
| ptableid | JET_TABLEID* | out | 作成された一時テーブルのカーソルを受け取る出力ポインタ(JET_TABLEID)。 |
| prgcolumnid | DWORD* | out | 各列に割り当てられた列IDを受け取るDWORD配列の出力ポインタ。 |
戻り値の型: INT
各言語での呼び出し定義
// ESENT.dll
#include <windows.h>
INT JetOpenTempTable2(
JET_SESID sesid,
const JET_COLUMNDEF* prgcolumndef,
DWORD ccolumn,
DWORD lcid,
DWORD grbit,
JET_TABLEID* ptableid,
DWORD* prgcolumnid
);[DllImport("ESENT.dll", ExactSpelling = true)]
static extern int JetOpenTempTable2(
UIntPtr sesid, // JET_SESID
IntPtr prgcolumndef, // JET_COLUMNDEF*
uint ccolumn, // DWORD
uint lcid, // DWORD
uint grbit, // DWORD
out UIntPtr ptableid, // JET_TABLEID* out
out uint prgcolumnid // DWORD* out
);<DllImport("ESENT.dll", ExactSpelling:=True)>
Public Shared Function JetOpenTempTable2(
sesid As UIntPtr, ' JET_SESID
prgcolumndef As IntPtr, ' JET_COLUMNDEF*
ccolumn As UInteger, ' DWORD
lcid As UInteger, ' DWORD
grbit As UInteger, ' DWORD
<Out> ByRef ptableid As UIntPtr, ' JET_TABLEID* out
<Out> ByRef prgcolumnid As UInteger ' DWORD* out
) As Integer
End Function' sesid : JET_SESID
' prgcolumndef : JET_COLUMNDEF*
' ccolumn : DWORD
' lcid : DWORD
' grbit : DWORD
' ptableid : JET_TABLEID* out
' prgcolumnid : DWORD* out
Declare PtrSafe Function JetOpenTempTable2 Lib "esent" ( _
ByVal sesid As LongPtr, _
ByVal prgcolumndef As LongPtr, _
ByVal ccolumn As Long, _
ByVal lcid As Long, _
ByVal grbit As Long, _
ByRef ptableid As LongPtr, _
ByRef prgcolumnid As Long) As Long
' VBA7前提(PtrSafe)。32bit Office では LongPtr→Long。Integer=16bit / Long=32bit / LongLong=64bit。import ctypes
from ctypes import wintypes
JetOpenTempTable2 = ctypes.windll.esent.JetOpenTempTable2
JetOpenTempTable2.restype = ctypes.c_int
JetOpenTempTable2.argtypes = [
ctypes.c_size_t, # sesid : JET_SESID
ctypes.c_void_p, # prgcolumndef : JET_COLUMNDEF*
wintypes.DWORD, # ccolumn : DWORD
wintypes.DWORD, # lcid : DWORD
wintypes.DWORD, # grbit : DWORD
ctypes.c_void_p, # ptableid : JET_TABLEID* out
ctypes.POINTER(wintypes.DWORD), # prgcolumnid : DWORD* out
]require 'fiddle'
require 'fiddle/import'
lib = Fiddle.dlopen('ESENT.dll')
JetOpenTempTable2 = Fiddle::Function.new(
lib['JetOpenTempTable2'],
[
Fiddle::TYPE_UINTPTR_T, # sesid : JET_SESID
Fiddle::TYPE_VOIDP, # prgcolumndef : JET_COLUMNDEF*
-Fiddle::TYPE_INT, # ccolumn : DWORD
-Fiddle::TYPE_INT, # lcid : DWORD
-Fiddle::TYPE_INT, # grbit : DWORD
Fiddle::TYPE_VOIDP, # ptableid : JET_TABLEID* out
Fiddle::TYPE_VOIDP, # prgcolumnid : DWORD* out
],
Fiddle::TYPE_INT)#[link(name = "esent")]
extern "system" {
fn JetOpenTempTable2(
sesid: usize, // JET_SESID
prgcolumndef: *const JET_COLUMNDEF, // JET_COLUMNDEF*
ccolumn: u32, // DWORD
lcid: u32, // DWORD
grbit: u32, // DWORD
ptableid: *mut usize, // JET_TABLEID* out
prgcolumnid: *mut u32 // DWORD* out
) -> i32;
}
// crates: windows-sys provides ready-made bindings for this API.$sig = @"
[DllImport("ESENT.dll")]
public static extern int JetOpenTempTable2(UIntPtr sesid, IntPtr prgcolumndef, uint ccolumn, uint lcid, uint grbit, out UIntPtr ptableid, out uint prgcolumnid);
"@
$api = Add-Type -MemberDefinition $sig -Name 'ESENT_JetOpenTempTable2' -Namespace Win32 -PassThru
# $api::JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)#uselib "ESENT.dll"
#func global JetOpenTempTable2 "JetOpenTempTable2" sptr, sptr, sptr, sptr, sptr, sptr, sptr
; JetOpenTempTable2 sesid, varptr(prgcolumndef), ccolumn, lcid, grbit, varptr(ptableid), varptr(prgcolumnid) ; 戻り値は stat
; sesid : JET_SESID -> "sptr"
; prgcolumndef : JET_COLUMNDEF* -> "sptr"
; ccolumn : DWORD -> "sptr"
; lcid : DWORD -> "sptr"
; grbit : DWORD -> "sptr"
; ptableid : JET_TABLEID* out -> "sptr"
; prgcolumnid : DWORD* out -> "sptr"
; ※HSP3.7は #func のため戻り値はシステム変数 stat に格納されます。出力引数:
#uselib "ESENT.dll" #cfunc global JetOpenTempTable2 "JetOpenTempTable2" sptr, var, int, int, int, var, var ; res = JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid) ; sesid : JET_SESID -> "sptr" ; prgcolumndef : JET_COLUMNDEF* -> "var" ; ccolumn : DWORD -> "int" ; lcid : DWORD -> "int" ; grbit : DWORD -> "int" ; ptableid : JET_TABLEID* out -> "var" ; prgcolumnid : DWORD* out -> "var" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。#uselib "ESENT.dll" #cfunc global JetOpenTempTable2 "JetOpenTempTable2" sptr, sptr, int, int, int, sptr, sptr ; res = JetOpenTempTable2(sesid, varptr(prgcolumndef), ccolumn, lcid, grbit, varptr(ptableid), varptr(prgcolumnid)) ; sesid : JET_SESID -> "sptr" ; prgcolumndef : JET_COLUMNDEF* -> "sptr" ; ccolumn : DWORD -> "int" ; lcid : DWORD -> "int" ; grbit : DWORD -> "int" ; ptableid : JET_TABLEID* out -> "sptr" ; prgcolumnid : DWORD* out -> "sptr" ; ※出力/バッファ引数はポインタ方式(token=sptr / 呼び出しは varptr(変数))。
出力引数:
; INT JetOpenTempTable2(JET_SESID sesid, JET_COLUMNDEF* prgcolumndef, DWORD ccolumn, DWORD lcid, DWORD grbit, JET_TABLEID* ptableid, DWORD* prgcolumnid) #uselib "ESENT.dll" #cfunc global JetOpenTempTable2 "JetOpenTempTable2" intptr, var, int, int, int, var, var ; res = JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid) ; sesid : JET_SESID -> "intptr" ; prgcolumndef : JET_COLUMNDEF* -> "var" ; ccolumn : DWORD -> "int" ; lcid : DWORD -> "int" ; grbit : DWORD -> "int" ; ptableid : JET_TABLEID* out -> "var" ; prgcolumnid : DWORD* out -> "var" ; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。; INT JetOpenTempTable2(JET_SESID sesid, JET_COLUMNDEF* prgcolumndef, DWORD ccolumn, DWORD lcid, DWORD grbit, JET_TABLEID* ptableid, DWORD* prgcolumnid) #uselib "ESENT.dll" #cfunc global JetOpenTempTable2 "JetOpenTempTable2" intptr, intptr, int, int, int, intptr, intptr ; res = JetOpenTempTable2(sesid, varptr(prgcolumndef), ccolumn, lcid, grbit, varptr(ptableid), varptr(prgcolumnid)) ; sesid : JET_SESID -> "intptr" ; prgcolumndef : JET_COLUMNDEF* -> "intptr" ; ccolumn : DWORD -> "int" ; lcid : DWORD -> "int" ; grbit : DWORD -> "int" ; ptableid : JET_TABLEID* out -> "intptr" ; prgcolumnid : DWORD* out -> "intptr" ; ※出力/バッファ引数はポインタ方式(token=intptr / 呼び出しは varptr(変数))。
import (
"golang.org/x/sys/windows"
"unsafe"
)
var (
esent = windows.NewLazySystemDLL("ESENT.dll")
procJetOpenTempTable2 = esent.NewProc("JetOpenTempTable2")
)
// sesid (JET_SESID), prgcolumndef (JET_COLUMNDEF*), ccolumn (DWORD), lcid (DWORD), grbit (DWORD), ptableid (JET_TABLEID* out), prgcolumnid (DWORD* out)
r1, _, err := procJetOpenTempTable2.Call(
uintptr(sesid),
uintptr(prgcolumndef),
uintptr(ccolumn),
uintptr(lcid),
uintptr(grbit),
uintptr(ptableid),
uintptr(prgcolumnid),
)
_ = err // syscall.Errno (valid when the call sets last-error)
_ = r1 // INTfunction JetOpenTempTable2(
sesid: NativeUInt; // JET_SESID
prgcolumndef: Pointer; // JET_COLUMNDEF*
ccolumn: DWORD; // DWORD
lcid: DWORD; // DWORD
grbit: DWORD; // DWORD
ptableid: Pointer; // JET_TABLEID* out
prgcolumnid: Pointer // DWORD* out
): Integer; stdcall;
external 'ESENT.dll' name 'JetOpenTempTable2';result := DllCall("ESENT\JetOpenTempTable2"
, "UPtr", sesid ; JET_SESID
, "Ptr", prgcolumndef ; JET_COLUMNDEF*
, "UInt", ccolumn ; DWORD
, "UInt", lcid ; DWORD
, "UInt", grbit ; DWORD
, "Ptr", ptableid ; JET_TABLEID* out
, "Ptr", prgcolumnid ; DWORD* out
, "Int") ; return: INT●JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid) = DLL("ESENT.dll", "int JetOpenTempTable2(int, void*, dword, dword, dword, void*, void*)")
# 呼び出し: JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)
# sesid : JET_SESID -> "int"
# prgcolumndef : JET_COLUMNDEF* -> "void*"
# ccolumn : DWORD -> "dword"
# lcid : DWORD -> "dword"
# grbit : DWORD -> "dword"
# ptableid : JET_TABLEID* out -> "void*"
# prgcolumnid : DWORD* out -> "void*"
# なでしこ1は32bit・ANSI(Shift_JIS)。文字列=char*(ANSI)、ポインタ/ハンドル=void*(4byte)。const std = @import("std");
extern "esent" fn JetOpenTempTable2(
sesid: usize, // JET_SESID
prgcolumndef: [*c]JET_COLUMNDEF, // JET_COLUMNDEF*
ccolumn: u32, // DWORD
lcid: u32, // DWORD
grbit: u32, // DWORD
ptableid: [*c]usize, // JET_TABLEID* out
prgcolumnid: [*c]u32 // DWORD* out
) callconv(std.os.windows.WINAPI) i32;proc JetOpenTempTable2(
sesid: uint, # JET_SESID
prgcolumndef: ptr JET_COLUMNDEF, # JET_COLUMNDEF*
ccolumn: uint32, # DWORD
lcid: uint32, # DWORD
grbit: uint32, # DWORD
ptableid: ptr uint, # JET_TABLEID* out
prgcolumnid: ptr uint32 # DWORD* out
): int32 {.importc: "JetOpenTempTable2", stdcall, dynlib: "ESENT.dll".}pragma(lib, "esent");
extern(Windows)
int JetOpenTempTable2(
size_t sesid, // JET_SESID
JET_COLUMNDEF* prgcolumndef, // JET_COLUMNDEF*
uint ccolumn, // DWORD
uint lcid, // DWORD
uint grbit, // DWORD
size_t* ptableid, // JET_TABLEID* out
uint* prgcolumnid // DWORD* out
);ccall((:JetOpenTempTable2, "ESENT.dll"), stdcall, Int32,
(Csize_t, Ptr{JET_COLUMNDEF}, UInt32, UInt32, UInt32, Ptr{Csize_t}, Ptr{UInt32}),
sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)
# sesid : JET_SESID -> Csize_t
# prgcolumndef : JET_COLUMNDEF* -> Ptr{JET_COLUMNDEF}
# ccolumn : DWORD -> UInt32
# lcid : DWORD -> UInt32
# grbit : DWORD -> UInt32
# ptableid : JET_TABLEID* out -> Ptr{Csize_t}
# prgcolumnid : DWORD* out -> Ptr{UInt32}
# stdcall は 32bit のみ意味を持つ(x64 では無視)。local ffi = require("ffi")
ffi.cdef[[
int32_t JetOpenTempTable2(
uintptr_t sesid,
void* prgcolumndef,
uint32_t ccolumn,
uint32_t lcid,
uint32_t grbit,
uintptr_t* ptableid,
uint32_t* prgcolumnid);
]]
local esent = ffi.load("esent")
-- esent.JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)
-- sesid : JET_SESID
-- prgcolumndef : JET_COLUMNDEF*
-- ccolumn : DWORD
-- lcid : DWORD
-- grbit : DWORD
-- ptableid : JET_TABLEID* out
-- prgcolumnid : DWORD* out
-- 構造体/GUIDへのポインタは cdef が通るよう void* で表記(実型は各引数コメント参照)。値渡し構造体・enum は対応する typedef を cdef に追加すること。const koffi = require('koffi');
const lib = koffi.load('ESENT.dll');
const JetOpenTempTable2 = lib.func('__stdcall', 'JetOpenTempTable2', 'int32_t', ['uintptr_t', 'void *', 'uint32_t', 'uint32_t', 'uint32_t', 'uintptr_t *', 'uint32_t *']);
// JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)
// sesid : JET_SESID -> 'uintptr_t'
// prgcolumndef : JET_COLUMNDEF* -> 'void *'
// ccolumn : DWORD -> 'uint32_t'
// lcid : DWORD -> 'uint32_t'
// grbit : DWORD -> 'uint32_t'
// ptableid : JET_TABLEID* out -> 'uintptr_t *'
// prgcolumnid : DWORD* out -> 'uint32_t *'
// 出力ポインタは koffi.out(...) で包む。構造体は koffi.struct で定義。const lib = Deno.dlopen("ESENT.dll", {
JetOpenTempTable2: { parameters: ["usize", "pointer", "u32", "u32", "u32", "pointer", "pointer"], result: "i32" },
});
// lib.symbols.JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid)
// sesid : JET_SESID -> "usize"
// prgcolumndef : JET_COLUMNDEF* -> "pointer"
// ccolumn : DWORD -> "u32"
// lcid : DWORD -> "u32"
// grbit : DWORD -> "u32"
// ptableid : JET_TABLEID* out -> "pointer"
// prgcolumnid : DWORD* out -> "pointer"
// 文字列引数は "buffer"(NUL 終端のバイト列を Uint8Array で渡す)。
// 値渡し構造体は { struct: [ ...field types... ] } を使用。<?php
$ffi = FFI::cdef(<<<C
int32_t JetOpenTempTable2(
size_t sesid,
void* prgcolumndef,
uint32_t ccolumn,
uint32_t lcid,
uint32_t grbit,
size_t* ptableid,
uint32_t* prgcolumnid);
C, "ESENT.dll");
// $ffi->JetOpenTempTable2(sesid, prgcolumndef, ccolumn, lcid, grbit, ptableid, prgcolumnid);
// sesid : JET_SESID
// prgcolumndef : JET_COLUMNDEF*
// ccolumn : DWORD
// lcid : DWORD
// grbit : DWORD
// ptableid : JET_TABLEID* out
// prgcolumnid : DWORD* out
// 構造体/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);
int JetOpenTempTable2(
long sesid, // JET_SESID
Pointer prgcolumndef, // JET_COLUMNDEF*
int ccolumn, // DWORD
int lcid, // DWORD
int grbit, // DWORD
LongByReference ptableid, // JET_TABLEID* out
IntByReference prgcolumnid // DWORD* out
);
}@[Link("esent")]
lib LibESENT
fun JetOpenTempTable2 = JetOpenTempTable2(
sesid : LibC::SizeT, # JET_SESID
prgcolumndef : JET_COLUMNDEF*, # JET_COLUMNDEF*
ccolumn : UInt32, # DWORD
lcid : UInt32, # DWORD
grbit : UInt32, # DWORD
ptableid : LibC::SizeT*, # JET_TABLEID* out
prgcolumnid : UInt32* # DWORD* out
) : Int32
end
# 構造体/GUID/enum は lib 内に対応する型定義が必要。
# 呼出規約: x64 は規約統一のため OK。x86(32bit)は WINAPI=stdcall だが Crystal の fun に stdcall 付与構文がなく非対応。import 'dart:ffi';
import 'package:ffi/ffi.dart';
typedef JetOpenTempTable2Native = Int32 Function(UintPtr, Pointer<Void>, Uint32, Uint32, Uint32, Pointer<UintPtr>, Pointer<Uint32>);
typedef JetOpenTempTable2Dart = int Function(int, Pointer<Void>, int, int, int, Pointer<UintPtr>, Pointer<Uint32>);
final JetOpenTempTable2 = DynamicLibrary.open('ESENT.dll')
.lookupFunction<JetOpenTempTable2Native, JetOpenTempTable2Dart>('JetOpenTempTable2');
// sesid : JET_SESID -> UintPtr
// prgcolumndef : JET_COLUMNDEF* -> Pointer<Void>
// ccolumn : DWORD -> Uint32
// lcid : DWORD -> Uint32
// grbit : DWORD -> Uint32
// ptableid : JET_TABLEID* out -> Pointer<UintPtr>
// prgcolumnid : DWORD* out -> Pointer<Uint32>
// 文字列は package:ffi の "...".toNativeUtf16()/toNativeUtf8() で変換。{$mode objfpc}{$H+}
function JetOpenTempTable2(
sesid: NativeUInt; // JET_SESID
prgcolumndef: Pointer; // JET_COLUMNDEF*
ccolumn: DWORD; // DWORD
lcid: DWORD; // DWORD
grbit: DWORD; // DWORD
ptableid: Pointer; // JET_TABLEID* out
prgcolumnid: Pointer // DWORD* out
): Integer; stdcall;
external 'ESENT.dll' name 'JetOpenTempTable2';import Foreign
import Foreign.C.Types
import Foreign.C.String
foreign import stdcall safe "JetOpenTempTable2"
c_JetOpenTempTable2 :: CUIntPtr -> Ptr () -> Word32 -> Word32 -> Word32 -> Ptr CUIntPtr -> Ptr Word32 -> IO Int32
-- sesid : JET_SESID -> CUIntPtr
-- prgcolumndef : JET_COLUMNDEF* -> Ptr ()
-- ccolumn : DWORD -> Word32
-- lcid : DWORD -> Word32
-- grbit : DWORD -> Word32
-- ptableid : JET_TABLEID* out -> Ptr CUIntPtr
-- prgcolumnid : DWORD* out -> Ptr Word32
-- 要 GHC(Windows)。stdcall は x64 では ccall として扱われる。ブロックする API は safe 呼び出し推奨。open Ctypes
open Foreign
let jetopentemptable2 =
foreign "JetOpenTempTable2"
(size_t @-> (ptr void) @-> uint32_t @-> uint32_t @-> uint32_t @-> (ptr size_t) @-> (ptr uint32_t) @-> returning int32_t)
(* sesid : JET_SESID -> size_t *)
(* prgcolumndef : JET_COLUMNDEF* -> (ptr void) *)
(* ccolumn : DWORD -> uint32_t *)
(* lcid : DWORD -> uint32_t *)
(* grbit : DWORD -> uint32_t *)
(* ptableid : JET_TABLEID* out -> (ptr size_t) *)
(* prgcolumnid : DWORD* out -> (ptr uint32_t) *)
(* foreign は cdecl 前提。x64 Windows では WINAPI と一致。構造体は ctypes structure を定義のこと。 *)(cffi:define-foreign-library esent (t "ESENT.dll"))
(cffi:use-foreign-library esent)
(cffi:defcfun ("JetOpenTempTable2" jet-open-temp-table2 :convention :stdcall) :int32
(sesid :uint64) ; JET_SESID
(prgcolumndef :pointer) ; JET_COLUMNDEF*
(ccolumn :uint32) ; DWORD
(lcid :uint32) ; DWORD
(grbit :uint32) ; DWORD
(ptableid :pointer) ; JET_TABLEID* out
(prgcolumnid :pointer)) ; DWORD* out
; isize/usize(INT_PTR/SIZE_T)は x64 前提で :int64/:uint64。x86 では :int32/:uint32。use Win32::API;
my $JetOpenTempTable2 = Win32::API::More->new('ESENT',
'int JetOpenTempTable2(WPARAM sesid, LPVOID prgcolumndef, DWORD ccolumn, DWORD lcid, DWORD grbit, LPVOID ptableid, LPVOID prgcolumnid)');
# my $ret = $JetOpenTempTable2->Call($sesid, $prgcolumndef, $ccolumn, $lcid, $grbit, $ptableid, $prgcolumnid);
# sesid : JET_SESID -> WPARAM
# prgcolumndef : JET_COLUMNDEF* -> LPVOID
# ccolumn : DWORD -> DWORD
# lcid : DWORD -> DWORD
# grbit : DWORD -> DWORD
# ptableid : JET_TABLEID* out -> LPVOID
# prgcolumnid : DWORD* out -> LPVOID
# 値渡し構造体は pack() した文字列、または Win32::API::Struct を使用。関連項目
類似 API
- f JetOpenTempTable — 列定義を指定して一時テーブルを開く。
- f JetOpenTempTable3 — Unicodeインデックス指定付きで一時テーブルを開く。
使用する型