Programming DB-Library for C Errata

The following changes should be made to Microsoft SQL Server Programming DB-Library for C for Microsoft SQL Server 6.0.

All references to Chapter 9, "Microsoft SQL Server Cursors" should be removed.
On page 116, in Chapter 4, "Core Functions," the dbfreequal function should be documented in Chapter 8, "Browse Functions."
On page 124, the reference should indicate that you can call dbgetuserdata when dbdead returns TRUE.

On page 133, the if statements in the programming example for the dbmsghandle function should be changed.

The following example correctly shows a typical message-handling function:

#include    <sqlfront.h>
#include    <sqldb.h>

int msg_handler(dbproc, msgno, msgstate, severity, msgtext,
    srvname, procname, line)
DBPROCESS    *dbproc;
DBINT        msgno;
int            msgstate;
int            severity;
char            *msgtext;
char            *srvname;
char            *procname;
DBUSMALLINT    line;

{
    printf("SQL Server message %ld, state %d, "
        "severity %d:\n\t%s\n", msgno, msgstate, severity, msgtext);
if (strlen(srvname) != 0)
        printf ("Server '%s', ", srvname);
    if (strlen(procname) != 0)
        printf ("Procedure '%s', ", procname);
    if (line != 0)
        printf ("Line %d", line);

    return(0);
}

On page 173, in "dbsetmaxprocs," it should be noted that the number of platform-dependent connections for Windows NT and Windows 95 is limited by the amount of available memory.
On page 192, in "dbwinexit (Windows only)", it should be noted that dbwinexit does not close any connections. Use dbclose or dbexit to close connections.
On page 195, in "dbcursor", in the bulleted list for row, CRS_UPDATE should be deleted because a row value of 0 is invalid. An update operation cannot be performed on all rows in the fetch buffer.
On page 328, in Appendix A, "DB-Library Options," and on page 176, in "dbsetopt", a DBBUFFER value of 1 is invalid, and a negative DBBUFFER value will set DBBUFFER to the default of 100 rows.
On page 331, in Appendix A, "DB-Library Options," in the table, the possible parameter values for DBTEXTLIMIT should be 0 to 65,534 for 16-bit DB-Library and 0 to 2,147,483,647 for 32-bit DB-Library.