FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> I am having a problem updating binary fields using 
> SQLBindParameter. I use
> the following code
> 
> char buf[6] = "\x12\x34\x56\x78\x90"
> 
> SQLPrepare(stmtHandle, ³UPDATE P_SIMPLE SET P_BINARY = ? 
> WHERE P__URN = 1²,
> SQL_NTS)
> SQLBindParameter(stmtHandle, 1, SQL_PARAM_INPUT, 
> SQL_C_BINARY, SQL_BINARY,
> 5, 0, buf, 0, NULL)
> SQLExecute(stmtHandle)
> 
> Only the first byte of the value at buf gets stored, the 
> remaining 4 get set
> to 0.
> 
> Again any ideas. I have tried using the BufferLength and 
> StrLen_or_IndPtr
> parameters to no avail.
> 
> Thanks in advance,
> Ian
> 

Try to use StrLen_or_IndPtr (last SQLBindParameter parameters) and set it to 
5. Note that you can't use a column of 5 bytes to insert 6 bytes...

So it should be

SQLINTEGER ind = 6;
char buf[6] = "\x12\x34\x56\x78\x90";

SQLPrepare(stmtHandle, "UPDATE P_SIMPLE SET P_BINARY = ? WHERE P__URN = 1", 
SQL_NTS);
SQLBindParameter(stmtHandle, 1, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_BINARY, 6, 
0, buf, 0, &ind);
SQLExecute(stmtHandle);

freddy77