MS VB6 CheckBox with PostgreSQL ODBC

Поиск

Список

Период

Сортировка

От	Secrétariat
Тема	MS VB6 CheckBox with PostgreSQL ODBC
Дата	13 августа 2004 г. 12:26:06
Msg-id	026401c47fc5$7dcedb90$0a00a8c0@lrp43008 обсуждение
Ответы	Re: MS VB6 CheckBox with PostgreSQL ODBC
Список	pgsql-odbc

Hello !

I use MS VB6 SP5 with pgsqlodbc 7.03.02.00 on a PostgreSQL 7.4.3 Database on Linux.

The PostgreSQL table 'tests' contain :

- a boolean field 'testbool',

- an integer field testint,

- a numeric field testnum.

In MS VB6 I create a Form with :

- an ADOdc control 'adodc1',

- a CheckBox control 'chkTest' with :

DataSource = adodc1,
Datafield = testbool.

The display is correct in the 'chkTest' control but

trying to update change on that control generate an error -2147217842 (aborted operation) !?

If I change the Datafield with testint or testnum it works !?

It seem like a bad interpretation of the boolean value between then CheckBox control and the ODBC driver ...

How can I workaround ? I can't change all my boolean values in the database !

Regards.

Luc

В списке pgsql-odbc по дате отправления: