Re: ODBC SQLBindParameter for string array

[Andre]

On Monday, 27 January 2014 at 14:18:17 UTC, Regan Heath wrote:

Try this:

// SQLCHAR is defined as ubyte
SQLCHAR*[] charArr = new SQLCHAR*[](stringArr.length);

foreach(i, str;stringArr){

charArr[i] = cast(SQLCHAR*) toStringz(str); // import std.string

    lengIndArr[i] = SQL_NTS; // Null terminated string
}

The SQL API is expecting an array of (C) char* pointers, not an array of D's ubyte[] (which is actually twice the size).

SQLBindParameter(

hStmt, cast(SQLUSMALLINT) 1, cast(SQLSMALLINT) SQL_PARAM_INPUT,

 cast(SQLSMALLINT) SQL_C_CHAR,
 cast(SQLSMALLINT)SQL_VARCHAR,
 maxLength,  0,
 charArr[0].ptr,

    maxLength + 1,   // I don't think the +1 is necessary..

 lengIndArr.ptr);

Regan

Thanks a lot for your help!

Kind regards
André