Updating bool column problems

From: lothar(dot)behrens(at)lollisoft(dot)de
To: pgsql-odbc(at)postgresql(dot)org
Subject: Updating bool column problems
Date: 2005-04-30 10:06:22
Message-ID: 427374BE.10264.7971DC@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Typing80wpm 2005-04-30 12:00:17 Adventures with P2P and Scripts in Windows
Previous Message Marko Ristola 2005-04-30 06:02:51 Re: Official ODBC announcement