Updating bool column problems - Mailing list pgsql-odbc

From lothar.behrens@lollisoft.de
Subject Updating bool column problems
Date
Msg-id 427374BE.10264.7971DC@localhost
Whole thread Raw
List pgsql-odbc
Hi,

I have detected that my test application - a console app, crashes when I try to
update a bool column. I haven't realized this with my GUI app.

Here are the code snippets, that may relate to the problem:

Binding the column of type SQL_BIT (rows is 2):

buffer = malloc((sizeof(bool))*rows);
_DataType = DataType;
bound = 1;
memset(buffer, 0, sizeof(bool)*rows);
ret = SQLBindCol(hstmt, column, DataType, buffer, sizeof(bool), &cbBufferLength);
if (ret != SQL_SUCCESS) {
        _LOG << "Error: Binding column '" << colName->charrep() << "' failed!" LOG_

        q->dbError("SQLBindCol()");
}
break;

Set the new data is like this:

bool l = false; // or true depending on input

*((bool*) buffer) = l;
//memcpy(buffer, &l, sizeof(bool));

And this is the simple code to update it, where it crashes inside the psqlodbc.dll
(SQLDummyOrdinal):

retcode = SQLSetPos(hstmt, 1, SQL_UPDATE, SQL_LOCK_NO_CHANGE);

Any ideas ?

Thanks

Lothar

--
Lothar Behrens        www.lollisoft.de
Rosmarinstr 3        My public project:
40235 Düsseldorf      http://sourceforge.net/projects/lbdmf




pgsql-odbc by date:

Previous
From: Marko Ristola
Date:
Subject: Re: Official ODBC announcement
Next
From: Shachar Shemesh
Date:
Subject: Re: Official ODBC announcement