https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&feed=atom&action=history
Microsoft KB Archive/100369 - Revision history
2024-03-28T14:21:12Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=349271&oldid=prev
X010: Text replacement - "&" to "&"
2020-07-21T11:24:58Z
<p>Text replacement - "&" to "&"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:24, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l101">Line 101:</td>
<td colspan="2" class="diff-lineno">Line 101:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Attributes Property'''<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Attributes Property'''<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The Help topic for the attributes property and the DATACONS.TXT file incorrectly list DB_SYSTEMOBJECT as having a value of &<del style="font-weight: bold; text-decoration: none;">amp;</del>H80000002. The correct value is H80000000.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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 /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Index Property (Data Access)'''<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Index Property (Data Access)'''<br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l212">Line 212:</td>
<td colspan="2" class="diff-lineno">Line 212:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> The constant values shown are in hexidecimal and should be preceded</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> The constant values shown are in hexidecimal and should be preceded</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> with the &<del style="font-weight: bold; text-decoration: none;">amp;</del>H notation. For example, DB_SQLPASSTHROUGH = &<del style="font-weight: bold; text-decoration: none;">amp;</del>H40, not</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> with the &H notation. For example, DB_SQLPASSTHROUGH = &H40, not</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> decimal 40. See online Help (Options Property) or the file</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> decimal 40. See online Help (Options Property) or the file</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> DATACONS.TXT for the correct values.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> DATACONS.TXT for the correct values.</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=281852&oldid=prev
X010: Text replacement - ">" to ">"
2020-07-20T16:42:37Z
<p>Text replacement - ">" to ">"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:42, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l96">Line 96:</td>
<td colspan="2" class="diff-lineno">Line 96:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># An entry in the [Installable ISAM] section in VB.INI or <APPNAME<del style="font-weight: bold; text-decoration: none;">&gt;</del>.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<del style="font-weight: bold; text-decoration: none;">&gt;</del>.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.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># An entry in the [Installable ISAM] section in VB.INI or <APPNAME<ins style="font-weight: bold; text-decoration: none;">></ins>.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<ins style="font-weight: bold; text-decoration: none;">></ins>.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.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 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.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 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.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=263364&oldid=prev
X010: Text replacement - "<" to "<"
2020-07-20T09:02:09Z
<p>Text replacement - "<" to "<"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 09:02, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l96">Line 96:</td>
<td colspan="2" class="diff-lineno">Line 96:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># An entry in the [Installable ISAM] section in VB.INI or <del style="font-weight: bold; text-decoration: none;">&lt;</del>APPNAME&gt;.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 <del style="font-weight: bold; text-decoration: none;">&lt;</del>APPNAME&gt;.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.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># An entry in the [Installable ISAM] section in VB.INI or <ins style="font-weight: bold; text-decoration: none;"><</ins>APPNAME&gt;.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 <ins style="font-weight: bold; text-decoration: none;"><</ins>APPNAME&gt;.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.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 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.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 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.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=253044&oldid=prev
X010: Text replacement - """ to """
2020-07-19T11:50:30Z
<p>Text replacement - """ to """</p>
<a href="https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=253044&oldid=45933">Show changes</a>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/100369&diff=45933&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:01:53Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB100369"></span>INFO: Part 1: Corrections for Errors in VB Version 3.0 Manuals =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 100369<br />
<br />
Article Last Modified on 7/11/2006<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Visual Basic 3.0 Professional Edition<br />
* Microsoft Visual Basic 3.0 Professional Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q100369<br />
<br />
</div><br />
<div class="summary_section"><br />
<br />
== SUMMARY ==<br />
<br />
These articles are a master list of corrections for documentation errors in the Microsoft Visual Basic version 3.0 for Windows manuals.<br /><br />
<br /><br />
Included are corrections to version 3.0 of the following manuals and files that ship with both the Standard and Professional Editions:<br />
* Online Help file VB.HLP<br />
* &quot;Microsoft Visual Basic for Windows Programmer's Guide&quot;<br />
* &quot;Microsoft Visual Basic for Windows Language Reference&quot;<br />
<br />
Also included are corrections to version 3.0 of the following manuals that ship with the Professional Edition only:<br />
* &quot;Microsoft Visual Basic for Windows Professional Features Book 1&quot;<br />
** Custom Control Reference<br />
** Control Development Guide<br />
** Help Compiler Guide<br />
* &quot;Microsoft Visual Basic for Windows Professional Features Book 2&quot;<br />
** Data Access Guide<br />
** Appendixes<br />
** Crystal Reports for Visual Basic User's Manual<br />
<br />
This master list of corrections includes and adds to the correction list found in &quot;Part 4: Notes for Microsoft Visual Basic Online Help&quot; and &quot;Part 5: Notes for Microsoft Visual Basic Programmer's Guide&quot; 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.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
=== Corrections to the Online Help File VB.HLP ===<br />
<br />
'''Rediminsioning an Array'''<br /><br />
<br /><br />
Help says that you can rediminsion an array from -32768 to 32767. This is incorrect. You can, however, redimension an array as follows:<br />
<pre class="codesample">Sub Form_Load ()<br />
Redim x%(-32767 To -1)<br />
End Sub<br />
</pre><br />
-or-<br />
<pre class="codesample">Sub Form_Load ()<br />
Redim x%(1 To 32767)<br />
End Sub<br />
</pre><br />
'''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.<br /><br />
<br /><br />
'''Error Message Help'''<br /><br />
<br /><br />
Online Help is not available for dialogs or error messages that occur at design time. For ISAM errors, use the Search dialog in Help.<br /><br />
<br /><br />
'''&quot;Couldn't find installable ISAM&quot;'''<br /><br />
<br /><br />
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.<br /><br />
<br /><br />
Possible causes:<br /><br />
<br /><br />
<br />
# An entry in the [Installable ISAM] section in VB.INI or &lt;APPNAME&gt;.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 &lt;APPNAME&gt;.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.<br />
# 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.<br />
<br />
'''Attributes Property'''<br /><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 /><br />
<br /><br />
'''Index Property (Data Access)'''<br /><br />
<br /><br />
The information listed in the Index Property (Data Access) Help topic is not correct. Here is the correct information for this topic:<br />
<pre class="fixed_text">Applies To<br />
Table object<br />
<br />
Description<br />
With data access, determines which existing index is the current index<br />
used to sort records in a Table and in recordsets created from that<br />
Table. The default is blank. Not available at design time; read/write at<br />
run time.<br />
<br />
Syntax<br />
table.Index [ = indexname ]<br />
<br />
Remarks<br />
The order of the data in a table is determined by the order in which the<br />
data is added to the table. To alter the order of records fetched from<br />
the table when using a Table object, set the Index property to the name<br />
of an index in the Indexes collection of the Table's TableDef object. For<br />
example, to set the index to be used on a Seek against the Titles table:<br />
<br />
Dim Tb as Table, Db as Database<br />
Set Db = OpenDatabase(&quot;Biblio.MDB&quot;)<br />
Set Tb = Db.OpenTable(&quot;Titles&quot;)<br />
Tb.Index = &quot;PubID&quot;<br />
Tb.Seek &quot;=&quot;, 3<br />
<br />
The specified index must already be defined. If you set the Index<br />
property to an index that doesn't exist, or if the index isn't set when<br />
you use the Seek method, an error occurs.<br />
<br />
In the Professional Edition, you can create a new Index in a Table by<br />
creating a new Index object, setting its properties, then appending it to<br />
the Indexes collection of the Table's TableDef.<br />
<br />
The records in a Table can be ordered only according to the indexes<br />
defined for it. To sort the Table records in some other order, create a<br />
new Index for the table and append it to the Table's Index Collection, or<br />
create a Dynaset or Snapshot that has a different sort order. To specify<br />
the sort order for Dynasets and Snapshots, use the Sort property after<br />
the Dynaset or Snapshot has been created. You can also set the order of a<br />
Dynaset or Snapshot by including an Order By clause in a SQL statement<br />
used to define the Dynaset or Snapshot.<br />
<br />
The Index property of a control array element is not the same as the<br />
Index property of a data access object.<br />
<br />
Data Type<br />
String<br />
</pre><br />
'''OpenQueryDef Example Code'''<br /><br />
<br /><br />
In the example, the name of the parameter is &quot;Enter State&quot; not &quot;State Wanted,&quot; and the name of the existing query is &quot;By State&quot; not &quot;Get State.&quot;<br /><br />
<br /><br />
'''Click Event'''<br /><br />
<br /><br />
Change the following two bullet items:<br />
* Selects an item in a combo box or list box, either by pressing the arrow keys or by clicking the mouse button.<br />
* Presses the Spacebar when a command button, option button, or check box has the focus.<br />
<br />
to:<br />
* Selects an option button or an item in a combo or list box, pressing the arrow keys or by clicking the mouse button.<br />
* Presses the Spacebar when a command button or check box has the focus.<br />
<br />
'''Scrollbar Property'''<br /><br />
<br /><br />
The following statement from the Help is incorrect:<br />
<div class="indent"><br />
<br />
&quot;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.&quot;<br />
<br />
<br />
</div><br />
The WordWrap property applies only to Labels.<br />
=== Corrections to &quot;Programmer's Guide&quot; ===<br />
<br />
<pre class="fixed_text">(Page 160) Numeric Values Stored in Variants -- IsNumeric() Function<br />
<br />
The first line of code on the page indicates that the following<br />
would return True.<br />
<br />
IsNumeric(&quot;$100&quot;)<br />
<br />
In fact, it and all currency figures used with the IsNumeric()<br />
function return False.<br />
<br />
(Page 188) The New Keyword<br />
<br />
In the example at the top of the page, the local form<br />
variable F is declared with the New keyword using the<br />
Dim statement. To make the form variable and the<br />
loaded form instance persist, use a Static or Global<br />
variable instead.<br />
<br />
(Page 194) Determining the Type of an Object Variable<br />
<br />
You can use the If...TypeOf statement to determine the<br />
control type of a custom control:<br />
<br />
If TypeOf object Is objecttype<br />
<br />
The identifier you use for 'object' is the class name of the custom<br />
control. See the section &quot;Specific Control Object Types&quot; (P. 186)<br />
for more information.<br />
<br />
(Page 461) The Options Property<br />
<br />
The constant values shown are in hexidecimal and should be preceded<br />
with the &amp;H notation. For example, DB_SQLPASSTHROUGH = &amp;H40, not<br />
decimal 40. See online Help (Options Property) or the file<br />
DATACONS.TXT for the correct values.<br />
<br />
(Page 454) BIBLIO.MAK and DATAMGR.EXE<br />
<br />
The second sentence of the first paragraph should read:<br />
<br />
If you installed the sample applications, you will find this<br />
application in the \DATACTRL subdirectory of the Visual Basic<br />
SAMPLES subdirectory (\VB\SAMPLES\DATACTRL).<br />
<br />
The third sentence of the second paragraph shoul read:<br />
<br />
You will find DATAMGR.EXE in the main Visual Basic directory<br />
(\VB).<br />
<br />
(Page 456) Getting a Quick Start. Item 6.<br />
<br />
Delete the second sentence which begins &quot;Set the DataSource<br />
property for Label1 ...&quot; under item 6.<br />
<br />
(Page 458) Setting Database Properties at Design Time<br />
<br />
This section incorrectly states that at design time the RecordSource<br />
property of the Data Control lists all tables and queries. The<br />
RecordSource property lists the tables in a database, not the<br />
queries.<br />
<br />
At design time, if the DatabaseName or Connect property of the Data<br />
Control is set, the RecordSource property will retrieve a list of<br />
all available tables. If the user knows of a valid SQL query for the<br />
database, the RecordSource property will allow the query to be typed<br />
in, but it does not list the queries.<br />
<br />
(Page 459) The Connect Property<br />
<br />
In the table for the Connect property setting, change the Connect<br />
setting for Paradox from the following:<br />
<br />
paradox;pwd=password;<br />
<br />
to:<br />
<br />
paradox 3.x;pwd=password;<br />
<br />
NOTE: The database name in the Connect setting must match (except<br />
for case) the database name in the VB.INI file. See page 148<br />
of &quot;Professional Features Book 2.&quot;<br />
<br />
(Page 460) The DatabaseName Property<br />
<br />
The first paragraph on this page incorrectly says the RecordSource<br />
property of the Data Control lists all tables and queries. The<br />
RecordSource property lists the tables, not the queries.<br />
<br />
At design time, if the DatabaseName or Connect property of the Data<br />
Control is set, the RecordSource property will retrieve a list of<br />
all available tables. If the user knows of a valid SQL query for the<br />
database, the RecordSource property will allow the query to be typed<br />
in, but it does not list the queries.<br />
<br />
(Page 462) The RecordSource Property<br />
<br />
The first sentence in the second paragraph should be changed to<br />
remove the reference to queries. Queries are not returned by the<br />
RecordSource Property. In other words, change the following:<br />
<br />
At design time you can choose from a list of database<br />
tables and queries by first ...<br />
<br />
to:<br />
<br />
At design time you can choose from a list of database<br />
tables by first ...<br />
<br />
In addition, the following text and example should be changed:<br />
<br />
For example, the following SQL query returns all of the columns<br />
in the bibliography for authors who live in New York:<br />
<br />
Data1.DatabaseName = &quot;BIBLIO.MDB&quot;<br />
Data1.RecordSource = &quot;Select * from Titles where state = 'NY'&quot;<br />
Data1.Refresh<br />
<br />
The above should read:<br />
<br />
For example, the following SQL query returns all of the columns<br />
in the bibliography for publishers based in New York:<br />
<br />
Data1.DatabaseName = &quot;BIBLIO.MDB&quot;<br />
Data1.RecordSource = &quot;Select * from Publishers where<br />
state ='NY'&quot;<br />
Data1.Refresh<br />
<br />
(Page 465) Adding a New Record<br />
<br />
In the second paragraph in this section, the last sentence<br />
should read, &quot;Notice that using the buttons on the data<br />
control or one of the Move methods to move to another record<br />
will automatically save your added record.&quot;<br />
<br />
(Page 530) Determining How an Object Is Displayed<br />
<br />
In the first paragraph, the second sentence should read,<br />
&quot;the Icon check box,&quot; not &quot;th eIcon check box.&quot;<br />
<br />
(Page 550) Creating Invisible Objects<br />
<br />
In the sample code, the following line has incorrect syntax:<br />
<br />
MyWord = ObjVar.SuggestWord MyWord<br />
<br />
The code should look like this:<br />
<br />
MyWord = ObjVar.SuggestWord (MyWord)<br />
<br />
(Page 552) Limitations in Visual Basic<br />
<br />
Under the discussion &quot;Arrays and User-Defined Types,&quot; the third<br />
bulleted item should read: &quot;You cannot assign the return value<br />
of a property or method to an array variable or a variable of a<br />
user-defined type.&quot;<br />
<br />
(Page 554) Closing an Object<br />
<br />
In the paragraph after the sample code, second sentence: It is<br />
not true that invoking a Close method on an object sets<br />
variables that refer to the object to Nothing.<br />
<br />
(Page 582) Determining the Files You Need to Distribute<br />
<br />
The following additional files are required for distributing<br />
your Visual Basic applications:<br />
<br />
DLL Name Required by (Professional Edition Only)<br />
------------------------------------------------------<br />
PDIRJET.DLL Crystal Reports for Visual Basic<br />
PDBJET.DLL Crystal Reports for Visual Basic<br />
MSAJT110.DLL Crystal Reports for Visual Basic<br />
MSAES110.DLL Crystal Reports for Visual Basic<br />
PDSODBC.DLL ODBC and Crystal Reports for Visual Basic<br />
<br />
(Page 588) Example<br />
<br />
All three references to CopyFile should end with a &quot;)&quot;, not &quot;,0)&quot;.<br />
<br />
(Page 643) Symbol Tables<br />
<br />
<br />
The first bullet item under Module Symbol Table should be under<br />
Global Symbol Table:<br />
<br />
- The actual text of the names of Sub and Function procedures<br />
</pre><br />
<br />
</div><br />
<div class="references_section"><br />
<br />
== REFERENCES ==<br />
<br />
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:<br />
<div class="indent"><br />
<br />
[[../243520|243520]] Part 2: Corrections for Errors in VB Version 3.0 Manuals<br />
<br />
<br />
</div><br />
<br />
</div><br />
Keywords: kbinfo kbref kbdocs KB100369<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd