Microsoft KB Archive/100369: Difference between revisions

From BetaArchive Wiki
m (Text replacement - ">" to ">")
m (Text replacement - "&" to "&")
 
Line 101: Line 101:
'''Attributes Property'''<br />
'''Attributes Property'''<br />
<br />
<br />
The Help topic for the attributes property and the DATACONS.TXT file incorrectly list DB_SYSTEMOBJECT as having a value of &amp;H80000002. The correct value is H80000000.<br />
The Help topic for the attributes property and the DATACONS.TXT file incorrectly list DB_SYSTEMOBJECT as having a value of &H80000002. The correct value is H80000000.<br />
<br />
<br />
'''Index Property (Data Access)'''<br />
'''Index Property (Data Access)'''<br />
Line 212: Line 212:


       The constant values shown are in hexidecimal and should be preceded
       The constant values shown are in hexidecimal and should be preceded
       with the &amp;H notation.  For example, DB_SQLPASSTHROUGH = &amp;H40, not
       with the &H notation.  For example, DB_SQLPASSTHROUGH = &H40, not
       decimal 40. See online Help (Options Property) or the file
       decimal 40. See online Help (Options Property) or the file
       DATACONS.TXT for the correct values.
       DATACONS.TXT for the correct values.

Latest revision as of 11:24, 21 July 2020

Article ID: 100369

Article Last Modified on 7/11/2006



APPLIES TO

  • Microsoft Visual Basic 3.0 Professional Edition
  • Microsoft Visual Basic 3.0 Professional Edition



This article was previously published under Q100369

SUMMARY

These articles are a master list of corrections for documentation errors in the Microsoft Visual Basic version 3.0 for Windows manuals.

Included are corrections to version 3.0 of the following manuals and files that ship with both the Standard and Professional Editions:

  • Online Help file VB.HLP
  • "Microsoft Visual Basic for Windows Programmer's Guide"
  • "Microsoft Visual Basic for Windows Language Reference"

Also included are corrections to version 3.0 of the following manuals that ship with the Professional Edition only:

  • "Microsoft Visual Basic for Windows Professional Features Book 1"
    • Custom Control Reference
    • Control Development Guide
    • Help Compiler Guide
  • "Microsoft Visual Basic for Windows Professional Features Book 2"
    • Data Access Guide
    • Appendixes
    • Crystal Reports for Visual Basic User's Manual

This master list of corrections includes and adds to the correction list found in "Part 4: Notes for Microsoft Visual Basic Online Help" and "Part 5: Notes for Microsoft Visual Basic Programmer's Guide" of the README.TXT file shipped with the product. Please use Part 1 and Part 2 of this article as your master list for making corrections to the manuals and help file.

MORE INFORMATION

Corrections to the Online Help File VB.HLP

Rediminsioning an Array

Help says that you can rediminsion an array from -32768 to 32767. This is incorrect. You can, however, redimension an array as follows:

Sub Form_Load ()
   Redim x%(-32767 To -1)
End Sub
                

-or-

Sub Form_Load ()
   Redim x%(1 To 32767)
End Sub
                

NOTE: The manual and online Help do not state this but the number of indexes for an array seems to be limited to 32K elements. Therefore, you can do a Redim x%(-32767 To -1) or Redim x%(1 To 32767), both of which stay within 32K elements. You cannot do a Redim x%(-32767 To 32767) because this is 64K elements, which will cause a subscript out-of-range error.

Error Message Help

Online Help is not available for dialogs or error messages that occur at design time. For ISAM errors, use the Search dialog in Help.

"Couldn't find installable ISAM"

An external file dynamic link library (DLL) file could not be found. This file is required for operations such as attaching or accessing external tables.

Possible causes:

  1. An entry in the [Installable ISAM] section in VB.INI or <APPNAME>.INI is incorrect. For example, this error occurs if you're accessing a Paradox external table, and the Paradox entry of the .INI file points to a nonexistent directory. Exit Visual Basic, make necessary corrections in VB.INI or <APPNAME>.INI using Microsoft Windows Notepad or another text editor, restart Visual Basic, and try the operation again.One of the entries in the [Installable ISAM] section in VB.INI points to a network drive, and that drive isn't connected. Check to make sure the network is available and the proper drive letter is established, and try the operation again.
  2. One of the entries in the [Installable ISAM] section in VB.INI points to a network drive, and that drive isn't connected. Check to make sure the network is available and the proper drive letter is established, and try the operation again.

Attributes Property

The Help topic for the attributes property and the DATACONS.TXT file incorrectly list DB_SYSTEMOBJECT as having a value of &H80000002. The correct value is H80000000.

Index Property (Data Access)

The information listed in the Index Property (Data Access) Help topic is not correct. Here is the correct information for this topic:

Applies To
  Table object

Description
  With data access, determines which existing index is the current index
  used to sort records in a Table and in recordsets created from that
  Table. The default is blank. Not available at design time; read/write at
  run time.

Syntax
  table.Index [ = indexname ]

Remarks
  The order of the data in a table is determined by the order in which the
  data is added to the table. To alter the order of records fetched from
  the table when using a Table object, set the Index property to the name
  of an index in the Indexes collection of the Table's TableDef object. For
  example, to set the index to be used on a Seek against the Titles table:

  Dim Tb as Table, Db as Database
  Set Db = OpenDatabase("Biblio.MDB")
  Set Tb = Db.OpenTable("Titles")
  Tb.Index = "PubID"
  Tb.Seek "=", 3

  The specified index must already be defined. If you set the Index
  property to an index that doesn't exist, or if the index isn't set when
  you use the Seek method, an error occurs.

  In the Professional Edition, you can create a new Index in a Table by
  creating a new Index object, setting its properties, then appending it to
  the Indexes collection of the Table's TableDef.

  The records in a Table can be ordered only according to the indexes
  defined for it. To sort the Table records in some other order, create a
  new Index for the table and append it to the Table's Index Collection, or
  create a Dynaset or Snapshot that has a different sort order. To specify
  the sort order for Dynasets and Snapshots, use the Sort property after
  the Dynaset or Snapshot has been created. You can also set the order of a
  Dynaset or Snapshot by including an Order By clause in a SQL statement
  used to define the Dynaset or Snapshot.

  The Index property of a control array element is not the same as the
  Index property of a data access object.

Data Type
  String
                

OpenQueryDef Example Code

In the example, the name of the parameter is "Enter State" not "State Wanted," and the name of the existing query is "By State" not "Get State."

Click Event

Change the following two bullet items:

  • Selects an item in a combo box or list box, either by pressing the arrow keys or by clicking the mouse button.
  • Presses the Spacebar when a command button, option button, or check box has the focus.

to:

  • Selects an option button or an item in a combo or list box, pressing the arrow keys or by clicking the mouse button.
  • Presses the Spacebar when a command button or check box has the focus.

Scrollbar Property

The following statement from the Help is incorrect:

"If no horizontal scroll bar is specified for a text box and MultiLine is True, the text will automatically wrap even if the WordWrap property is False."


The WordWrap property applies only to Labels.

Corrections to "Programmer's Guide"

(Page 160)    Numeric Values Stored in Variants -- IsNumeric() Function

       The first line of code on the page indicates that the following
       would return True.

       IsNumeric("$100")

       In fact, it and all currency figures used with the IsNumeric()
       function return False.

(Page 188)    The New Keyword

       In the example at the top of the page, the local form
       variable F is declared with the New keyword using the
       Dim statement.  To make the form variable and the
       loaded form instance persist, use a Static or Global
       variable instead.

(Page 194)    Determining the Type of an Object Variable

       You can use the If...TypeOf statement to determine the
       control type of a custom control:

       If TypeOf object Is objecttype

       The identifier you use for 'object' is the class name of the custom
       control. See the section "Specific Control Object Types" (P. 186)
       for more information.

(Page 461)    The Options Property

       The constant values shown are in hexidecimal and should be preceded
       with the &H notation.  For example, DB_SQLPASSTHROUGH = &H40, not
       decimal 40. See online Help (Options Property) or the file
       DATACONS.TXT for the correct values.

(Page 454)    BIBLIO.MAK and DATAMGR.EXE

       The second sentence of the first paragraph should read:

       If you installed the sample applications, you will find this
       application in the \DATACTRL subdirectory of the Visual Basic
       SAMPLES subdirectory (\VB\SAMPLES\DATACTRL).

       The third sentence of the second paragraph shoul read:

       You will find DATAMGR.EXE in the main Visual Basic directory
       (\VB).

(Page 456)    Getting a Quick Start. Item 6.

       Delete the second sentence which begins "Set the DataSource
       property for Label1 ..." under item 6.

(Page 458)    Setting Database Properties at Design Time

       This section incorrectly states that at design time the RecordSource
       property of the Data Control lists all tables and queries. The
       RecordSource property lists the tables in a database, not the
       queries.

       At design time, if the DatabaseName or Connect property of the Data
       Control is set, the RecordSource property will retrieve a list of
       all available tables. If the user knows of a valid SQL query for the
       database, the RecordSource property will allow the query to be typed
       in, but it does not list the queries.

(Page 459)    The Connect Property

       In the table for the Connect property setting, change the Connect
       setting for Paradox from the following:

          paradox;pwd=password;

       to:

          paradox 3.x;pwd=password;

       NOTE:  The database name in the Connect setting must match (except
              for case) the database name in the VB.INI file. See page 148
              of "Professional Features Book 2."

(Page 460)    The DatabaseName Property

       The first paragraph on this page incorrectly says the RecordSource
       property of the Data Control lists all tables and queries. The
       RecordSource property lists the tables, not the queries.

       At design time, if the DatabaseName or Connect property of the Data
       Control is set, the RecordSource property will retrieve a list of
       all available tables. If the user knows of a valid SQL query for the
       database, the RecordSource property will allow the query to be typed
       in, but it does not list the queries.

(Page 462)    The RecordSource Property

       The first sentence in the second paragraph should be changed to
       remove the reference to queries. Queries are not returned by the
       RecordSource Property. In other words, change the following:

       At design time you can choose from a list of database
       tables and queries by first ...

       to:

       At design time you can choose from a list of database
       tables by first ...

       In addition, the following text and example should be changed:

       For example, the following SQL query returns all of the columns
       in the bibliography for authors who live in New York:

       Data1.DatabaseName = "BIBLIO.MDB"
       Data1.RecordSource = "Select * from Titles where state = 'NY'"
       Data1.Refresh

       The above should read:

       For example, the following SQL query returns all of the columns
       in the bibliography for publishers based in New York:

       Data1.DatabaseName = "BIBLIO.MDB"
       Data1.RecordSource = "Select * from Publishers where
                             state ='NY'"
       Data1.Refresh

(Page 465)    Adding a New Record

       In the second paragraph in this section, the last sentence
       should read, "Notice that using the buttons on the data
       control or one of the Move methods to move to another record
       will automatically save your added record."

(Page 530)    Determining How an Object Is Displayed

       In the first paragraph, the second sentence should read,
       "the Icon check box," not "th eIcon check box."

(Page 550)    Creating Invisible Objects

       In the sample code, the following line has incorrect syntax:

       MyWord = ObjVar.SuggestWord MyWord

       The code should look like this:

       MyWord = ObjVar.SuggestWord (MyWord)

(Page 552)    Limitations in Visual Basic

       Under the discussion "Arrays and User-Defined Types," the third
       bulleted item should read: "You cannot assign the return value
       of a property or method to an array variable or a variable of a
       user-defined type."

(Page 554)    Closing an Object

       In the paragraph after the sample code, second sentence:  It is
       not true that invoking a Close method on an object sets
       variables that refer to the object to Nothing.

(Page 582)    Determining the Files You Need to Distribute

       The following additional files are required for distributing
       your Visual Basic applications:

       DLL Name       Required by (Professional Edition Only)
       ------------------------------------------------------
       PDIRJET.DLL    Crystal Reports for Visual Basic
       PDBJET.DLL     Crystal Reports for Visual Basic
       MSAJT110.DLL   Crystal Reports for Visual Basic
       MSAES110.DLL   Crystal Reports for Visual Basic
       PDSODBC.DLL    ODBC and Crystal Reports for Visual Basic

(Page 588)    Example

       All three references to CopyFile should end with a ")", not ",0)".

(Page 643)    Symbol Tables


       The first bullet item under Module Symbol Table should be under
       Global Symbol Table:

        - The actual text of the names of Sub and Function procedures
                

REFERENCES

For additional information, click the article number on Part 2 of this article below to view the article on Part 2 of this article in the Microsoft Knowledge Base:

243520 Part 2: Corrections for Errors in VB Version 3.0 Manuals


Keywords: kbinfo kbref kbdocs KB100369