## BUG: Function dbcursorfetch Fails with Error 221

Q108685

The information in this article applies to:

- Microsoft SQL Server Programmer's Toolkit, version 4.2

BUG# 9696 (4.20.50)

## SYMPTOMS

When calling DB-Library function dbcursorfetch with the FETCH_NEXT option in a medium-model MS-DOS application, the function call fails, generating error 221:

> Column of type (%s) does not allow nulls. It may not be compared with null.

## CAUSE

When building the query to perform the cursor fetch, DB-Library is incorrectly attempting to compare a NOT NULL column with the value NULL.

## WORKAROUND

For MS-DOS programs, use the large-model DB-Library. The function dbcursorfetch behaves correctly on other operating systems.

## STATUS

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

Additional query words: db-lib dblib cursors

Keywords : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420

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