Programming DB-Library for Visual Basic Errata

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

• On page 119, the Remarks text about the SqlWinExit function should be changed. The last sentence in the first Remarks paragraph currently reads:

  "Put the call to SqlWinExit before you call the End function to close an application."

  This sentence should read:

  "Put the call to SqlWinExit before you use the Unload statement to close the main form, which closes the application."

  You should also remove the End function from the sample code in the Remarks section. Instead, you should use the Unload statement to close the main form, which closes the Visual Basic application.

  Note that a number of sample code examples in Programming DB-Library for Visual Basic use the End function; they should use the Unload statement to close the main form instead.

• On page 136, the text describing the SqlCursorFetchEx nfetchrows% parameter should be changed. Remove the following two sentences:

  "The poutlen and pvaradddr arrays specified in calls to dbcursorbind must have at least nfetchrows% elements. If these arrays are not large enough, you must break the existing bindings and then rebind with large enough arrays (at least nfetchrows% elements) before calling SqlCursorFetchEx%."

• On page 177, the Remarks text about the SqlWriteText function should be changed. The first sentence in the third paragraph currently reads:

  "SqlWriteText% can be invoked with or without logging in, according to the value of the log% parameter."

  This sentence should read:

  "SqlWriteText can be invoked with or without logging, according to the value of the log% parameter."

• On page 211, the text describing the SqlBCPColumnFormat ftlen& parameter should be changed. The second sentence currently reads:

  "To avoid using a terminator, set this value to -1."

  This sentence should read:

  "To avoid using a terminator, set this value to 0."

• On page 222, in Appendix A, "DB-Library for Visual Basic Options," under SQLBUFFER, the last sentence in the first paragraph currently reads:

  "The default setting is 0 (no row buffering)."

  This sentence should be deleted.

  The following table reflects this change and replaces the table that is currently on page 222.