## BUG: Repeated Fetch With Dynamic Cursors and OR Clause

Q119107

The information in this article applies to:

- Microsoft SQL Server Programmer's Toolkit, version 4.2

BUG# 10103 (4.2)

## SYMPTOMS

Opening a dynamic or forward cursor with a query involving an OR clause may cause an inability to retrieve rows past the row set returned by the first fetch.

## WORKAROUND

Placing the WHERE clause of the query in parentheses, for example,

        "select au_id from authors where (state > 'K' OR city > 'G'")

will cause the cursor to function as expected. Keyset driven cursors do not display this problem and can also be used as a workaround provided the result set is not prohibitively large.

## STATUS

Microsoft has confirmed this to be a problem in Microsoft DB-Library 4.20. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: dblib

Keywords : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420

Last Reviewed: March 21, 1999 © 2001 Microsoft Corporation. All rights reserved. Terms of Use.