PRSQL9108015: Dbnextrow Returns Unexpected Row After Dbgetrow

ID Number: Q75806

1.10

OS/2

buglist1.16 buglist1.17

Summary:

Problem ID: PRSQL9108015

SYMPTOMS

Calling dbnextrow() after dbgetrow() when using row buffering does

not return the expected row. After calling dbgetrow(), it is

expected that dbnextrow() will return the next row contained in the

linked list of buffered rows. Instead, a new row from the result

set is returned; that is, the row just after the last dbnextrow().

WORKAROUND

The expected rows are returned if dbnextrow() is called until the

BUF_FULL message is received.

STATUS

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

versions 1.16 and 1.17. We are researching this problem and will

post new information here as it becomes available.