Win32 API 日本語リファレンス
ホームSystem.Search › bcp_bind

bcp_bind

関数
一括コピーでプログラム変数を表の列に結び付ける。
DLLodbcbcp.dll呼出規約winapi

シグネチャ

// odbcbcp.dll
#include <windows.h>

SHORT bcp_bind(
    void* param0,
    BYTE* param1,
    INT param2,
    INT param3,
    BYTE* param4,
    INT param5,
    INT param6,
    INT param7
);

パラメーター

名前方向
param0void*inout
param1BYTE*inout
param2INTin
param3INTin
param4BYTE*inout
param5INTin
param6INTin
param7INTin

戻り値の型: SHORT

各言語での呼び出し定義

// odbcbcp.dll
#include <windows.h>

SHORT bcp_bind(
    void* param0,
    BYTE* param1,
    INT param2,
    INT param3,
    BYTE* param4,
    INT param5,
    INT param6,
    INT param7
);
[DllImport("odbcbcp.dll", ExactSpelling = true)]
static extern short bcp_bind(
    IntPtr param0,   // void* in/out
    IntPtr param1,   // BYTE* in/out
    int param2,   // INT
    int param3,   // INT
    IntPtr param4,   // BYTE* in/out
    int param5,   // INT
    int param6,   // INT
    int param7   // INT
);
<DllImport("odbcbcp.dll", ExactSpelling:=True)>
Public Shared Function bcp_bind(
    param0 As IntPtr,   ' void* in/out
    param1 As IntPtr,   ' BYTE* in/out
    param2 As Integer,   ' INT
    param3 As Integer,   ' INT
    param4 As IntPtr,   ' BYTE* in/out
    param5 As Integer,   ' INT
    param6 As Integer,   ' INT
    param7 As Integer   ' INT
) As Short
End Function
' param0 : void* in/out
' param1 : BYTE* in/out
' param2 : INT
' param3 : INT
' param4 : BYTE* in/out
' param5 : INT
' param6 : INT
' param7 : INT
Declare PtrSafe Function bcp_bind Lib "odbcbcp" ( _
    ByVal param0 As LongPtr, _
    ByVal param1 As LongPtr, _
    ByVal param2 As Long, _
    ByVal param3 As Long, _
    ByVal param4 As LongPtr, _
    ByVal param5 As Long, _
    ByVal param6 As Long, _
    ByVal param7 As Long) As Integer
' VBA7前提(PtrSafe)。32bit Office では LongPtr→Long。Integer=16bit / Long=32bit / LongLong=64bit。
import ctypes
from ctypes import wintypes

bcp_bind = ctypes.windll.odbcbcp.bcp_bind
bcp_bind.restype = ctypes.c_short
bcp_bind.argtypes = [
    ctypes.POINTER(None),  # param0 : void* in/out
    ctypes.POINTER(ctypes.c_ubyte),  # param1 : BYTE* in/out
    ctypes.c_int,  # param2 : INT
    ctypes.c_int,  # param3 : INT
    ctypes.POINTER(ctypes.c_ubyte),  # param4 : BYTE* in/out
    ctypes.c_int,  # param5 : INT
    ctypes.c_int,  # param6 : INT
    ctypes.c_int,  # param7 : INT
]
require 'fiddle'
require 'fiddle/import'

lib = Fiddle.dlopen('odbcbcp.dll')
bcp_bind = Fiddle::Function.new(
  lib['bcp_bind'],
  [
    Fiddle::TYPE_VOIDP,  # param0 : void* in/out
    Fiddle::TYPE_VOIDP,  # param1 : BYTE* in/out
    Fiddle::TYPE_INT,  # param2 : INT
    Fiddle::TYPE_INT,  # param3 : INT
    Fiddle::TYPE_VOIDP,  # param4 : BYTE* in/out
    Fiddle::TYPE_INT,  # param5 : INT
    Fiddle::TYPE_INT,  # param6 : INT
    Fiddle::TYPE_INT,  # param7 : INT
  ],
  Fiddle::TYPE_SHORT)
#[link(name = "odbcbcp")]
extern "system" {
    fn bcp_bind(
        param0: *mut (),  // void* in/out
        param1: *mut u8,  // BYTE* in/out
        param2: i32,  // INT
        param3: i32,  // INT
        param4: *mut u8,  // BYTE* in/out
        param5: i32,  // INT
        param6: i32,  // INT
        param7: i32  // INT
    ) -> i16;
}
// crates: windows-sys provides ready-made bindings for this API.
$sig = @"
[DllImport("odbcbcp.dll")]
public static extern short bcp_bind(IntPtr param0, IntPtr param1, int param2, int param3, IntPtr param4, int param5, int param6, int param7);
"@
$api = Add-Type -MemberDefinition $sig -Name 'odbcbcp_bcp_bind' -Namespace Win32 -PassThru
# $api::bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
#uselib "odbcbcp.dll"
#func global bcp_bind "bcp_bind" sptr, sptr, sptr, sptr, sptr, sptr, sptr, sptr
; bcp_bind param0, varptr(param1), param2, param3, varptr(param4), param5, param6, param7   ; 戻り値は stat
; param0 : void* in/out -> "sptr"
; param1 : BYTE* in/out -> "sptr"
; param2 : INT -> "sptr"
; param3 : INT -> "sptr"
; param4 : BYTE* in/out -> "sptr"
; param5 : INT -> "sptr"
; param6 : INT -> "sptr"
; param7 : INT -> "sptr"
; ※HSP3.7は #func のため戻り値はシステム変数 stat に格納されます。
出力引数:
#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" sptr, var, int, int, var, int, int, int
; res = bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
; param0 : void* in/out -> "sptr"
; param1 : BYTE* in/out -> "var"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "var"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。
出力引数:
; SHORT bcp_bind(void* param0, BYTE* param1, INT param2, INT param3, BYTE* param4, INT param5, INT param6, INT param7)
#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" intptr, var, int, int, var, int, int, int
; res = bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
; param0 : void* in/out -> "intptr"
; param1 : BYTE* in/out -> "var"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "var"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。
import (
	"golang.org/x/sys/windows"
	"unsafe"
)

var (
	odbcbcp = windows.NewLazySystemDLL("odbcbcp.dll")
	procbcp_bind = odbcbcp.NewProc("bcp_bind")
)

// param0 (void* in/out), param1 (BYTE* in/out), param2 (INT), param3 (INT), param4 (BYTE* in/out), param5 (INT), param6 (INT), param7 (INT)
r1, _, err := procbcp_bind.Call(
	uintptr(param0),
	uintptr(param1),
	uintptr(param2),
	uintptr(param3),
	uintptr(param4),
	uintptr(param5),
	uintptr(param6),
	uintptr(param7),
)
_ = err  // syscall.Errno (valid when the call sets last-error)
_ = r1   // SHORT
function bcp_bind(
  param0: Pointer;   // void* in/out
  param1: Pointer;   // BYTE* in/out
  param2: Integer;   // INT
  param3: Integer;   // INT
  param4: Pointer;   // BYTE* in/out
  param5: Integer;   // INT
  param6: Integer;   // INT
  param7: Integer   // INT
): Smallint; stdcall;
  external 'odbcbcp.dll' name 'bcp_bind';
result := DllCall("odbcbcp\bcp_bind"
    , "Ptr", param0   ; void* in/out
    , "Ptr", param1   ; BYTE* in/out
    , "Int", param2   ; INT
    , "Int", param3   ; INT
    , "Ptr", param4   ; BYTE* in/out
    , "Int", param5   ; INT
    , "Int", param6   ; INT
    , "Int", param7   ; INT
    , "Short")   ; return: SHORT
●bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7) = DLL("odbcbcp.dll", "int bcp_bind(void*, void*, int, int, void*, int, int, int)")
# 呼び出し: bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
# param0 : void* in/out -> "void*"
# param1 : BYTE* in/out -> "void*"
# param2 : INT -> "int"
# param3 : INT -> "int"
# param4 : BYTE* in/out -> "void*"
# param5 : INT -> "int"
# param6 : INT -> "int"
# param7 : INT -> "int"
# なでしこ1は32bit・ANSI(Shift_JIS)。文字列=char*(ANSI)、ポインタ/ハンドル=void*(4byte)。