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
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 |