PRSQL9107008: Using CHARBIND to Bind a CHAR(1) Column

ID Number: Q75807

1.10

OS/2

buglist1.10 fixlist1.11

Summary:

Problem ID: PRSQL9107008

SYMPTOMS

When binding a CHAR(1) column in a DB-LIBRARY application in the

following manner, dbnextrow() returns FAIL after the first row is

retrieved:

dbbind(dbproc, 1, CHARBIND, (DBINT) 0, (BYTE *) &one_char);

Programs that only test for NO_MORE_ROWS result in an endless loop.

CAUSE

DB-LIBRARY incorrectly handles this situation when the C variable

is defined as a one-character DBCHAR variable.

WORKAROUND

Bind the CHAR(1) column as follows:

dbbind(dbproc, 1, CHARBIND, (DBINT) 1, (BYTE *) &one_char);

RESOLUTION

Microsoft has confirmed this to be a problem in DB-LIBRARY (db-lib)

version 1.1. This problem has been corrected in DB-LIBRARY version

1.11, which is available from Microsoft Product Support Services.

For more information, contact your primary support provider.