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




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org