Microsoft KB Archive/105364

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

FIX: dbcursorcolinfo() Will Not Return Usertype for Column

PSS ID Number: Q105364 Article last modified on 01-24-1995

4.20 | 4.20 | 4.20

MS-DOS | OS/2 | WINDOWS

The information in this article applies to:
- Microsoft SQL Server Programmer’s Toolkit, version 4.2

BUG# 9497 (4.20.00)

SYMPTOMS

The value -1 will be always be returned when using dbcursorcolinfo() to determine the usertype of a column in a cursored result set. This behavior is not consistent with dbucoltype() which will return the value -1 for system datatypes and the user type for user-defined datatypes.

CAUSE

The DB-Library function dbcursorcolinfo() returns -1 as the usertype for any column in a cursored results set.

STATUS

Microsoft has confirmed this to be a problem in DB-Library version 4.20.00. This problem was corrected in DB-Library version 4.21.00. For more information, contact your primary support provider.

Additional reference words: 4.20 DB-Library DB-Lib cursor cursors datatype KBCategory: kbprg KBSubCategory: SSrvDB_Lib SSrvProg

=================================================================

Copyright Microsoft Corporation 1995.