https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103702&feed=atom&action=history
Microsoft KB Archive/103702 - Revision history
2024-03-28T13:19:44Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103702&diff=281845&oldid=prev
X010: Text replacement - ">" to ">"
2020-07-20T16:42:36Z
<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-l55">Line 55:</td>
<td colspan="2" class="diff-lineno">Line 55:</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>.INI (initialization) files</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>.INI (initialization) files</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>See also VB.INI</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>See also VB.INI</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><Appname<del style="font-weight: bold; text-decoration: none;">&gt;</del>.INI 148</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><Appname<ins style="font-weight: bold; text-decoration: none;">></ins>.INI 148</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>external databases 134</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>external databases 134</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>ODBC.INI 14, 15, 27, 151, 154</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>ODBC.INI 14, 15, 27, 151, 154</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103702&diff=264394&oldid=prev
X010: Text replacement - "<" to "<"
2020-07-20T09:18:31Z
<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:18, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l55">Line 55:</td>
<td colspan="2" class="diff-lineno">Line 55:</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>.INI (initialization) files</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>.INI (initialization) files</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>See also VB.INI</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>See also VB.INI</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><del style="font-weight: bold; text-decoration: none;">&lt;</del>Appname&gt;.INI 148</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><ins style="font-weight: bold; text-decoration: none;"><</ins>Appname&gt;.INI 148</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>external databases 134</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>external databases 134</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>ODBC.INI 14, 15, 27, 151, 154</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>ODBC.INI 14, 15, 27, 151, 154</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103702&diff=262350&oldid=prev
X010: Text replacement - """ to """
2020-07-20T08:27:03Z
<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 08:27, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l22">Line 22:</td>
<td colspan="2" class="diff-lineno">Line 22:</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>== SUMMARY ==</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>== SUMMARY ==</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>Below is the A-Me index for the Data Access Guide in the Microsoft Visual Basic version 3.0 for Windows <del style="font-weight: bold; text-decoration: none;">&quot;</del>Professional Features Book 2<del style="font-weight: bold; text-decoration: none;">&quot; </del>manual. This index was not included in the manual. The index in the very back of the manual is for the Crystal Reports section of the manual only.<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>Below is the A-Me index for the Data Access Guide in the Microsoft Visual Basic version 3.0 for Windows <ins style="font-weight: bold; text-decoration: none;">"</ins>Professional Features Book 2<ins style="font-weight: bold; text-decoration: none;">" </ins>manual. This index was not included in the manual. The index in the very back of the manual is for the Crystal Reports section of the manual only.<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>For the Mo through Z portion of the index, please see the following article in the Microsoft Knowledge Base:<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>For the Mo through Z portion of the index, please see the following article in the Microsoft Knowledge Base:<br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l45">Line 45:</td>
<td colspan="2" class="diff-lineno">Line 45:</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><pre class="FIXEDTEXT"><del style="font-weight: bold; text-decoration: none;">&quot; </del>(double quotes) 66</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><pre class="FIXEDTEXT"><ins style="font-weight: bold; text-decoration: none;">" </ins>(double quotes) 66</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>' (single quotes) 66</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>' (single quotes) 66</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>! symbol 66, 78, 79, 97</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>! symbol 66, 78, 79, 97</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103702&diff=47903&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:03:21Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>{|<br />
|width="100%"|<br />
{|<br />
|width="100%"|<br />
= DOC: Data Access Guide Index - A through Me =<br />
<br />
'''ID: Q103702'''<br />
|}<br />
<br />
<br />
-----<br />
<br />
The information in this article applies to:<br /><br />
<br />
* Microsoft Visual Basic programming system for Windows, version 3.0<br />
<br />
<br />
-----<br />
<br />
<br /><br />
<br />
== SUMMARY ==<br />
<br />
Below is the A-Me index for the Data Access Guide in the Microsoft Visual Basic version 3.0 for Windows &quot;Professional Features Book 2&quot; manual. This index was not included in the manual. The index in the very back of the manual is for the Crystal Reports section of the manual only.<br /><br />
<br /><br />
For the Mo through Z portion of the index, please see the following article in the Microsoft Knowledge Base:<br /><br />
<br />
<br />
<blockquote>'''[[../103703|Q103703]]''' : DOC: Data Access Guide Index -- Mo through Z</blockquote><br />
<br /><br />
The entire index is also available as one, single file.<br />
<br /><br />
<br />
== MORE INFORMATION ==<br />
<br />
The following file is available for download from the Microsoft Software Library:<br /><br />
<br /><br />
~ [[../URJump|Dataindex.exe]]<br /><br />
<br /><br />
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:<br /><br />
<br />
<br />
<blockquote>'''[[../119591|Q119591]]''' : How to Obtain Microsoft Support Files from Online Services</blockquote><br />
<br /><br />
<br /><br />
<br />
<pre class="FIXEDTEXT">&quot; (double quotes) 66<br />
' (single quotes) 66<br />
! symbol 66, 78, 79, 97<br />
.CDX (FoxPro) index files 140, 142<br />
.DBF (dBASE) files 140<br />
.DDF (Btrieve) files 12<br />
.IDX (FoxPro) index files 140, 142<br />
.INF (information) files 140, 142<br />
.INI (initialization) files<br />
See also VB.INI<br />
&lt;Appname&gt;.INI 148<br />
external databases 134<br />
ODBC.INI 14, 15, 27, 151, 154<br />
purpose 40<br />
setting name and location 41<br />
WIN.INI 144, 149<br />
.LDB (Visual Basic) locking support files 121<br />
.MDA Access (database) files 120<br />
.MDB Access (dBASE) index files 12, 14, 28<br />
.MDX files 140, 142<br />
.NDX files 140, 142<br />
.PX (Paradox) files 139<br />
.386 files 123<br />
3D check box control 117<br />
3D panel control 117<br />
<br />
Access See Microsoft Access<br />
Access engine 1, 41<br />
Action part See Programmer's Guide, Chapter 20<br />
Action queries<br />
Execute method 101<br />
ExecuteSQL method 102<br />
making bulk changes 70<br />
passing to ODBC server 59<br />
Adding<br />
Field objects 28, 33<br />
Index objects 28, 37 - 38<br />
records 54, 86<br />
TableDef objects 28, 29, 33<br />
tables 33<br />
AddNew method<br />
adding records 86<br />
cloning recordset variables 102<br />
AddNew method (continued)<br />
Dynaset 53<br />
Snapshot 57<br />
Admin username 120<br />
Administrative privileges 120<br />
Aggregate functions 126, 132, 147<br />
Alias names 147<br />
ALL statement (SQL) 127<br />
ALTER statement (SQL) 127<br />
Alternatives to data objects 3<br />
AND statement (SQL) 132<br />
ANSI SQL<br />
compared to Microsoft Access SQL 126<br />
data types 126<br />
features not supported 127<br />
APP (application name) 15<br />
Append method 29<br />
collections 29<br />
example 32<br />
Field object 31, 33<br />
Fields collection 33<br />
Index object 31<br />
TableDef object 31<br />
TableDefs collection 31<br />
Append only constant (DB_APPENDONLY) 58<br />
AppendChunk method<br />
handling large fields 98, 100<br />
large fields 35<br />
Application name as a connect parameter 15<br />
AS statement (SQL) 127<br />
ASC statement (SQL) 127, 131<br />
Ascending sorts 39, 64<br />
ASCII files, support in Visual Basic 3,134<br />
Attached tables<br />
bookmarks 76<br />
connect string 19, 61<br />
indicating data sources 37<br />
source table name 61<br />
using 50<br />
Attaching tables<br />
See also Tables: External databases; specific database<br />
formats<br />
from external databases 30, 133<br />
from Microsoft Access databases 146 - 147<br />
from ODBC tables 149 - 150<br />
Attributes field, ListTables snapshot 23<br />
Attributes options, setting 21<br />
Attributes property 36<br />
Fields collection 22<br />
system tables 21<br />
TableDef object 19, 20, 135, 149<br />
AUTOEXEC.BAT 122<br />
<br />
Background processing 45<br />
Beginning a transaction 104<br />
BeginTrans method 54<br />
BeginTrans statement<br />
multiple transactions 106<br />
transaction logging 108<br />
using transactions 104<br />
BETWEEN statement (SQL) 126<br />
BIBLIO.MDB 9<br />
Binary data type 35<br />
Binary file-access, support in Visual Basic 3<br />
Binary object data type 35<br />
BINARY statement (SQL) 127, 128, 129<br />
BIT statement (SQL) 127<br />
BOF property<br />
defined 62<br />
Move methods 71<br />
positioning the current record 68<br />
Bookmark property<br />
defined 62<br />
positioning methods compared 69<br />
recordsets 61<br />
using 76<br />
Bookmarkable property 61<br />
Bookmarks<br />
current record, positioning 76<br />
defined 62<br />
external databases 76<br />
multiple transactions 106<br />
sharing in cloned Dynasets 102<br />
BOOLEAN statement (SQL) 129<br />
Bound controls<br />
See also Data control; Programmer's Guide, Chapter 20<br />
events, methods, and properties (list) 7<br />
using 116 - 117<br />
Btrieve databases<br />
See also External databases; VB.INI; WIN.INI<br />
accessing 133<br />
Btrieve driver 144<br />
BTRIEVE.TXT 143<br />
data-type conversions 145<br />
FIELD.DDF 143<br />
FILE.DDF 143<br />
ISAM 149<br />
Microsoft Access security 120<br />
Novell Btrieve for Windows 144<br />
Novell Netware SQL 144<br />
opening databases 11<br />
opening files 143 - 145<br />
passwords 135<br />
primary keys 136<br />
support in Visual Basic 3<br />
WBTRCALL.DLL 144<br />
WIN.INI file settings 144<br />
Xtrieve 143<br />
Bulk operations<br />
Execute method 101<br />
ExecuteSQL method 102<br />
transaction logging 108<br />
using action queries 70<br />
BY statement (SQL) 127<br />
BYTE statement (SQL) 128, 129<br />
<br />
Cannot find installable ISAM 134<br />
Changing records 54, 82 - 84<br />
CHAR[ACTER] statement (SQL) 127, 128, 129<br />
Character data type 35<br />
Check box control 116<br />
Client/server databases, support in Visual Basic 3<br />
Clone method 50, 114<br />
Cloning recordset variables 102<br />
Close method<br />
databases 27<br />
recordsets 68<br />
Closing<br />
databases 17, 27<br />
queries 93<br />
recordsets 68<br />
Code page information 26<br />
Coding rules for SQL queries 102, 125 - 132<br />
Collating order 22, 36<br />
Collating sequences 26, 37<br />
CollatingOrder property<br />
Field object 36<br />
Fields collection 22<br />
mapping object properties 19<br />
CollatingSequence 148<br />
Collections<br />
Fields 6<br />
Indexes 6<br />
methods 28 - 29<br />
members 28<br />
names 77<br />
summarized 5<br />
Tabledefs 6<br />
types supported 28<br />
CommitLockRetry 148<br />
Committing transactions 104<br />
CommitTrans method 54<br />
CommitTrans statement<br />
transaction logging 108<br />
using transactions 104<br />
CompactDatabase statement<br />
Access version 44<br />
destinationname part 43<br />
locale part 44<br />
options part 44<br />
overview 42<br />
packing .DBF files 141<br />
sourcename part 43<br />
when repairing databases 45<br />
Compacting a database 42 - 44<br />
Comparison strings, Seek method 74<br />
CONFIG.ORA (Oracle) 153<br />
Connect parameters 15<br />
Connect part 11<br />
Connect property<br />
attaching external tables 145<br />
login timeout 152<br />
mapping object properties 19<br />
ODBC parameters 15<br />
OpenDatabase function 11 - 15<br />
recordsets 61<br />
Refresh method 30<br />
TableDef object 19<br />
Connect strings 135, 61<br />
Connections, managing See file PERFORM.TXT<br />
Consistent updates 58<br />
Contents overview 2<br />
Control, yielding 45<br />
Controls<br />
See also individual controls<br />
Bound controls 118<br />
Corruption, data 121<br />
Count property, TableDefs collection 19<br />
Count function (SQL) 132<br />
Count(*) function (SQL) 132<br />
Counter data type 36<br />
Counter fields 36<br />
CREATE statement (SQL) 127<br />
CreateDatabase function 25 - 27<br />
CreateDynaset method<br />
append only constant (DB_APPENDONLY) 58<br />
consistent updates 58<br />
creating Dynaset variables 50<br />
deny read constant (DB_DENYREAD) 58<br />
deny write constant (DB_DENYWRITE) 58<br />
in SQL queries 100<br />
inconsistent updates 58<br />
read only constant (DB_READONLY) 58<br />
recordsets 57, 58<br />
sorting records 64<br />
SQL PassThrough 58, 59<br />
CreateQueryDef method<br />
in SQL queries 100<br />
recordsets 58<br />
SQLPassThrough option 59<br />
CreateSnapshot method<br />
append only constant 58<br />
consistent updates 58<br />
creating Snapshot variables 56<br />
deny read constant 58<br />
deny write constant 58<br />
in SQL queries 100<br />
inconsistent updates 58<br />
read only constant 58<br />
recordsets 57, 58<br />
sorting records 64<br />
SQL PassThrough 58<br />
SQLPassThrough option 59<br />
Creating<br />
data object variables 113<br />
Database object 10<br />
Database object variable 25<br />
database variables 49<br />
databases 24 - 28<br />
databases with Data Manager 24<br />
Dynaset variables 50 - 55<br />
Dynasets 48 - 68<br />
external databases 27<br />
indexes 31, 37 - 38<br />
new query 92<br />
new table 31<br />
ODBC-accessible database 27<br />
programs 47 - 108<br />
recordsets 48 - 68<br />
Snapshots 48 - 68<br />
table variables 49<br />
TableDef object 31<br />
Tables 48 - 68<br />
Crosstab queries 126<br />
Currency data type 35<br />
CURRENCY statement (SQL) 127, 128, 129<br />
Current record<br />
positioning 68 - 76<br />
undefined 68<br />
Custom controls, support in Visual Basic 3<br />
<br />
Danish rules (locale constant) 26, 37, 44<br />
Data control<br />
See also Programmer's Guide, Chapter 20<br />
accessing fields 82<br />
bookmarks 76<br />
bound controls 116<br />
Connect property 151<br />
creating Dynaset variables 50<br />
current record 68<br />
DatabaseName property 151<br />
events (list) 6<br />
exclusive access 88<br />
general tips and techniques 112 - 114<br />
methods (list) 6<br />
opening databases 10<br />
opening external tables 137<br />
overview 10<br />
properties (list) 6<br />
Recordset property 82<br />
refreshing 30<br />
unbound controls 118<br />
using in the Professional edition 110 - 114<br />
with the OpenDatabase function 14<br />
Data corruption 45<br />
Data Definition Language (DDL) 127<br />
Data Manager application 25<br />
See also DATAMGR.HLP<br />
Data Manipulation Language (DML) 47<br />
Data object variables 113<br />
Data source as a connect parameter 15<br />
Data Source Name (DSN) 15, 27<br />
Data types<br />
Btrieve data-type conversions 145<br />
dBASE data-type conversions 142<br />
Field object 35<br />
Microsoft FoxPro data-type conversions 142<br />
Paradox data-type conversions 140<br />
DATA_ACTIONUNLOAD 68<br />
Data1.Recordset in SQL queries 100<br />
Database as a connect parameter 15<br />
Database engine<br />
described 1<br />
initializing 41<br />
Database formats supported in Visual Basic 3<br />
Database object<br />
creating 10<br />
creating database variables 25, 49<br />
default collection 77<br />
default property 77<br />
properties and methods (list) 5<br />
DATABASE (ODBC parameter) 15<br />
Database property, using in the Professional edition 110<br />
DATABASE statement (SQL) 127<br />
Database structure, modifying 28 - 40<br />
Database variables<br />
creating 25, 49<br />
creating a Dynaset 50<br />
Global 17<br />
Static 17<br />
Databasename part<br />
See also Programmer's Guide, Chapter 20<br />
CreateDatabase function 26<br />
OpenDatabase function 11<br />
DatabaseName property 30<br />
Databases<br />
accessing external databases 133 - 154<br />
adding tables 33<br />
changing locale 42<br />
changing version 42<br />
closing 17, 27<br />
compacting 42 - 44<br />
creating 24 - 28<br />
decrypting 44<br />
deleting 28<br />
encrypting 27, 44<br />
external, accessing 133 - 154<br />
initializing 40 - 45<br />
locking 87 - 91<br />
management 9 - 45<br />
mapping 18 - 24<br />
modifying 28 - 40<br />
opening<br />
as exclusive 12<br />
as read-only 13<br />
as shared 12<br />
Microsoft Access databases 41, 42<br />
possible problems 13<br />
special conditions 13<br />
types of databases 14<br />
repairing 45<br />
sharing 121, 122<br />
validating 45<br />
DataChanged property 116<br />
DATACONS.TXT See specific constants<br />
DataField property 116<br />
DataSource property 116<br />
Datasource type 15<br />
Date/Time data type 35<br />
DateCreated field, ListTables snapshot 23<br />
DateCreated property<br />
recordsets 61<br />
TableDef object 19<br />
DATETIME statement (SQL) 127, 128, 129<br />
DB-Library, support in Visual Basic 3<br />
DB_APPENDONLY 58<br />
DB_ATTACHEDODBC 20<br />
DB_ATTACHEDTABLE 20<br />
DB_ATTACHEXCLUSIVE 20<br />
DB_ATTACHSAVEPWD 20, 30, 135, 149<br />
DB_AUTOINCRFIELD 36<br />
DB_BINARY 35<br />
DB_BOOLEAN 35<br />
DB_BYTE 35<br />
DB_CONSISTENT 58, 59<br />
DB_CURRENCY 35<br />
DB_DATE 35<br />
DB_DECRYPT 44<br />
DB_DENYREAD 58, 59, 89<br />
DB_DENYWRITE 58, 59, 89<br />
DB_DOUBLE 35<br />
DB_ENCRYPT 27, 44<br />
DB_FIXEDFIELD 36<br />
DB_INCONSISTENT 58, 59<br />
DB_INTEGER 35<br />
DB_LANG_DUTCH 26, 44<br />
DB_LANG_GENERAL 26, 44<br />
DB_LANG_ICELANDIC 26, 44<br />
DB_LANG_NORDIC 44<br />
DB_LANG_NORWDAN 26, 44<br />
DB_LANG_SPANISH 26, 44<br />
DB_LANG_SWEDFIN 26, 44<br />
DB_LONG 35<br />
DB_LONGBINARY 35<br />
DB_MEMO 35<br />
DB_OPTIONINITPATH 41<br />
DB_READONLY 58, 59<br />
DB_SINGLE 35<br />
DB_SQLPASSTHROUGH 58, 59, 101<br />
DB_SYSTEMOBJECT 20<br />
DB_TEXT 35<br />
DB_UPDATABLEFIELD 36<br />
DB_VERSION10 27, 44<br />
dBASE III, IV databases<br />
See also External databases; VB.INI<br />
.MDX files 140<br />
.NDX files 140<br />
accessing 133<br />
creating 25<br />
data-type conversions 142<br />
deleting records 137, 148<br />
driver 148<br />
files 140<br />
indexes 140, 142<br />
Microsoft Access security 120<br />
opening databases 11, 12, 14<br />
opening files 11, 12, 14, 140<br />
primary keys 136, 140, 142<br />
support in Visual Basic 3<br />
versions supported 11<br />
dBASE ISAM 148<br />
DDL (Data Definition Language) 127<br />
DECIMAL statement (SQL) 128<br />
Default collections, names, and properties 77<br />
Default database as an ODBC connect parameter 15<br />
Delete method<br />
collections 29<br />
deleting records 86<br />
tables 34<br />
DELETE statement (SQL) 127, 129<br />
Deleting<br />
.MDB files 28<br />
databases 28<br />
fields 34<br />
Index objects 28<br />
indexes 38<br />
queries 93<br />
records 54, 86<br />
TableDef objects 28<br />
tables 34<br />
Deny read constant (DB_DENYREAD) 58<br />
Deny write constant (DB_DENYWRITE) 58<br />
DESC statement (SQL) 127, 131<br />
Descending sorts 39, 64<br />
Destinationname (CompactDatabase statement) 43<br />
Dim statement 113<br />
Directories, making<br />
Search Help for MKDIR<br />
See also External databases<br />
DISTINCT statement (SQL) 127, 129<br />
DISTINCTROW statement (SQL) 127<br />
DLLs (Dynamic link libraries)<br />
in Visual Basic and Microsoft Access 120<br />
required See Programmer's Guide pages 579 - 582<br />
support in Visual Basic 3<br />
DML (Data Manipulation Language) 47<br />
DoEvents function 45<br />
Domain functions 120<br />
Double data type 35<br />
DOUBLE statement (SQL) 128, 129<br />
DOUBLE PRECISION statement (SQL) 128<br />
DROP statement (SQL) 127<br />
DSN (Data Source Name)<br />
ODBC databases 15<br />
registering 27<br />
Dutch rules (locale constant) 26, 37, 44<br />
Dynaset object<br />
default collection 77<br />
default property 77<br />
properties and methods (list) 5<br />
Dynaset variables<br />
creating 50 - 55<br />
creating a subset 50<br />
updating multiple tables 84<br />
using 53<br />
Dynasets<br />
See also Recordsets; Snapshots; Tables;<br />
Programmer's Guide, Chapter 20<br />
accessing fields 80 - 82<br />
adding records 54<br />
AddNew method 53<br />
changing records 54<br />
cloning 102<br />
creating 48 - 68<br />
deleting records 54<br />
Edit method 53, 54<br />
editing 53<br />
Filter property 50, 66<br />
inconsistent 84<br />
locking 54, 89<br />
management approaches 55<br />
membership 48, 53<br />
Microsoft Access SQL 125<br />
multiuser considerations 53<br />
options 58<br />
overview 48<br />
rebuilding 55<br />
screening data 53<br />
Sort property 50<br />
sorting 64<br />
SQL PassThrough 59<br />
Transactions property 104<br />
Update method 54<br />
<br />
Edit method<br />
deleting records 86<br />
Dynaset 53<br />
editing records 82<br />
handling errors 83, 86<br />
locking dynasets 54<br />
pessimistic locking 90<br />
Snapshot 56<br />
Editing records 82 - 84<br />
EFGPI rules (English, French, German, Portuguese, Italian) 37<br />
Embedded functions in queries 119<br />
Encryption<br />
changing 42, 44<br />
external databases 135<br />
setting 27<br />
English rules (locale constant) 26, 37, 44<br />
EOF property<br />
Move methods 71<br />
positioning the current record 68<br />
recordsets 61<br />
Errors<br />
See also Help files DRVORACL.HLP, DRVSSRVR.HLP<br />
'Cannot find installable ISAM' 134<br />
Edit method 83<br />
handling 83<br />
optimistic locking 84<br />
pessimistic locking 84<br />
too many pending transactions 106<br />
trappable errors<br />
# 2004 108<br />
# 7745 154<br />
when adding records 86<br />
when deleting records 86<br />
Events 6<br />
Exclusive mode 12, 30<br />
Exclusive part 12<br />
Exclusive property 30<br />
Execute method<br />
append only constant 58<br />
consistent updates 58<br />
deleting records 86<br />
deny read constant 58<br />
deny write constant 58<br />
described 100, 101<br />
in SQL queries 100, 101<br />
inconsistent updates 58<br />
ODBC 58, 59<br />
read only constant (DB_READONLY) 58<br />
recordsets 58<br />
SQL PassThrough 58, 59<br />
ExecuteSQL method, described 100, 102<br />
External databases<br />
accessing 54, 134 - 154<br />
achieving optimal performance 147<br />
alias names 147<br />
attaching tables 30<br />
attaching tables from Microsoft Access<br />
databases 146 - 147<br />
Btrieve tables, accessing 143 - 145<br />
'Cannot find installable ISAM' 134<br />
combining data with Visual Basic tables 30<br />
connect parameters 15<br />
creating 27<br />
creating database variables 49<br />
creating databases 24<br />
dBASE tables, accessing 140 - 142<br />
deleting records 137<br />
encrypting 135<br />
exclusive mode 30<br />
general tips 134 - 137<br />
initialization parameters 134<br />
initialization statements 41 - 42<br />
locking 54<br />
Microsoft FoxPro tables, accessing 140 - 142<br />
opening databases 11<br />
opening tables 137 - 138<br />
Paradox tables, accessing 138 - 140<br />
passwords 135<br />
performance See file PERFORM.TXT<br />
primary keys 136<br />
SourceField property 37, 145<br />
SourceTableName property 37, 145<br />
support in Visual Basic 3<br />
TableDef attributes 20<br />
<br />
Features (data control)<br />
ANSI SQL 126, 127<br />
database types supported 3<br />
file types supported 3<br />
Microsoft Access SQL 126<br />
overview 2<br />
Professional Edition vs. Standard Edition 4<br />
Field collating order 22<br />
Field names 34<br />
Field objects<br />
adding 28, 31<br />
append order 37<br />
bytes used 35<br />
data types 35<br />
default collection 77<br />
default property 77<br />
deleting 34<br />
methods (list) 6<br />
Name property 34<br />
Ordinal property 81<br />
properties 6, 34 - 37<br />
properties within Field collections 34 - 37<br />
Size property 35<br />
Type property 35<br />
FIELD.DDF (Btrieve) 143<br />
Fields<br />
See also Field object; Fields collection<br />
accessing 80 - 82<br />
adding to a table 33<br />
changing 34<br />
data types 35<br />
handling large fields 98 - 100<br />
LargeBinary fields 98<br />
(list) 23<br />
Memo fields 98, 99, 100<br />
Null value 80<br />
Value property 80 - 82<br />
Fields collection<br />
adding a field 33<br />
addressing Field object properties 34 - 37<br />
deleting Field members 34<br />
mapping definitions 22<br />
members 28<br />
methods (list) 6<br />
Name property 34<br />
properties (list) 6<br />
Fields property 39<br />
FieldSize method<br />
handling large fields 98, 99<br />
large fields 35<br />
File types supported 3<br />
FILE.DDF (Btrieve) 143<br />
Files<br />
See also Tables<br />
manipulating<br />
Get statement 3<br />
Input statement 3<br />
Print statement 3<br />
Put statement 3<br />
required See Programmer's Guide, Chapter 25, 579 - 582<br />
Filter property<br />
Dynaset 50, 53<br />
recordsets 61, 66<br />
Find methods, current record, positioning 68, 72<br />
FindLast method, positioning methods compared 69<br />
Finnish rules (locale constant) 26, 37, 44<br />
First function (SQL) 132<br />
FLOAT statement (SQL) 127, 128, 129<br />
Forms, default 77<br />
FreeLocks statement 45<br />
French rules (locale constant) 26, 37, 44<br />
FROM statement (SQL) 127<br />
Functions (data access)<br />
aggregate functions 126<br />
domain functions 132<br />
embedded functions in queries 120<br />
usable for data access 7<br />
<br />
German rules (locale constant) 26, 37, 44<br />
Get statement, manipulating files 3<br />
GetChunk method<br />
handling large fields 98, 99<br />
large fields 35<br />
Global recordset variables 68<br />
Graphics, implementation differences vs.<br />
Microsoft Access 119<br />
GROUP statement (SQL) 127<br />
GROUP BY statement (SQL) 130<br />
<br />
Handling errors 83<br />
Handling large fields 98 - 100<br />
HAVING statement (SQL) 127, 130<br />
Host servers, sharing tables 30<br />
<br />
Icelandic rules (locale constant) 26, 37, 44<br />
Idle time, managing 45<br />
IEEESINGLE statement (SQL) 127<br />
Image control (bound control)<br />
described 116<br />
using with Microsoft Access databases 119<br />
Importing data into Visual Basic database 133<br />
IN statement (SQL) 127, 131<br />
Inconsistent Dynaset 84<br />
Inconsistent updates 58<br />
Index objects<br />
adding 28<br />
adding new 31<br />
creating indexes 37 - 38<br />
default collection 77<br />
default property 77<br />
deleting 28<br />
listing properties 40<br />
methods (list) 6<br />
properties 6, 39<br />
properties within Index collections 34 - 37<br />
secondary indexes 39<br />
Index property<br />
recordsets 61<br />
Seek method 74<br />
Tables 63<br />
Indexes<br />
See also Index object; Indexes collection<br />
creating 31, 37 - 38<br />
dBASE tables 142<br />
deleting 38<br />
external databases 136, 139, 142<br />
(list) 23<br />
(list) properties 40<br />
Microsoft FoxPro tables 142<br />
Paradox databases 139<br />
primary key 54<br />
properties 39<br />
secondary indexes 39<br />
unique indexes 54<br />
Indexes collections<br />
addressing Index object properties 34 - 37<br />
addressing index properties 39<br />
creating indexes 37 - 38<br />
Delete method 29<br />
(list) properties 40<br />
members 28<br />
methods (list) 6<br />
properties (list) 6<br />
secondary indexes 39<br />
Tables 63<br />
Initialization files<br />
general tips for external databases 134<br />
ODBC.INI 151<br />
VB.INI 148<br />
WIN.INI 144, 149<br />
Initialization parameters 134<br />
Initializing<br />
database engine 41, 42<br />
Database variable 10<br />
databases 40 - 45<br />
INNER statement (SQL) 127, 130<br />
Input # statement, importing ASCII data 134<br />
Input statement, manipulating files 3<br />
INSERT statement (SQL) 127, 129<br />
INSERT INTO statement (SQL) 129<br />
Installable ISAMs 148<br />
INSTCAT.48 (Sybase) 154<br />
INSTCAT.SQL (SQL) 154<br />
InStr function, mapping Field properties 22<br />
Integer data type 35<br />
INT[EGER] statement (SQL) 127, 129<br />
INTO statement (SQL) 127, 129<br />
IS statement (SQL) 131<br />
ISAM databases See specific database formats<br />
ISAM files, support in Visual Basic 3<br />
Italian rules (locale constant) 26, 37, 44<br />
<br />
JOIN statement (SQL) 127, 130<br />
Joins<br />
coding 126, 130<br />
inner 130<br />
Microsoft Access SQL vs. ANSI SQL 126<br />
many-to-many 84<br />
one-to-many 84<br />
one-to-one 84<br />
outer 130<br />
relational 84<br />
<br />
Language<br />
See also Locale<br />
as a connect parameter 15<br />
CreateDatabase function 26<br />
language and code page information 26<br />
LargeBinary fields 98<br />
Last function (SQL) 132<br />
LastModified property<br />
bookmarks 76<br />
recordsets 61<br />
LastUpdated field, ListTables snapshot 23<br />
LastUpdated property<br />
recordsets 61<br />
TableDef object 19<br />
LEFT statement (SQL) 127, 130<br />
LEVEL statement (SQL) 127<br />
LIKE statement (SQL) 126, 131<br />
ListFields method 23<br />
ListIndexes method 23<br />
Listing<br />
fields 23<br />
indexes 23<br />
parameters 23<br />
queries 23<br />
tables 23<br />
ListParameters method<br />
List methods 23<br />
parameter queries 96<br />
using 24<br />
ListTables method<br />
List methods 23<br />
system tables 21<br />
Locale<br />
changing 42<br />
CollatingOrder property 36<br />
CompactDatabase statement 44<br />
converting 44<br />
CreateDatabase function 25<br />
setting 25<br />
LockEdits property<br />
optimistic locking 91<br />
pessimistic locking 90<br />
with other recordset properties 61<br />
Locking<br />
data 87 - 91<br />
databases 88<br />
Dynasets 54, 89<br />
Edit method 90<br />
Microsoft SQL Server 87<br />
ODBC databases 87<br />
OpenDatabase function 88<br />
optimistic 91<br />
Oracle databases 87<br />
pages 90<br />
pessimistic 90<br />
recordset properties 61<br />
support file 121<br />
Tables 89<br />
Update method 83, 90<br />
LockRetry 148<br />
Logging transactions 104, 108<br />
Login names 13, 15<br />
Login timeout 15, 152<br />
LOGINTIMEOUT 15, 152<br />
LoginTimeout parameter 15, 17<br />
Long data type 35<br />
LONG statement (SQL) 127, 128, 129<br />
LONGBINARY statement (SQL) 127, 128, 129<br />
LONGTEXT statement (SQL) 127, 128, 129<br />
<br />
Manipulating data 47 - 108<br />
Many-to-many joins 84<br />
Mapping databases<br />
Field properties 22<br />
List methods 23<br />
object properties 19<br />
overview 18<br />
system tables 21<br />
table definitions 19<br />
TableDef object 21<br />
Masked edit control 117<br />
Max function (SQL) 132<br />
MaxBufferSize 148<br />
Members, collections 28<br />
Membership<br />
Dynaset 53<br />
recordsets 48<br />
Memo fields<br />
data type 35<br />
handling large fields 98, 99, 100<br />
Microsoft SQL Server 35<br />
Methods<br />
See also Quick Reference chart on back cover<br />
AddNew method 86<br />
Append method 29<br />
AppendChunk method 98, 99, 100<br />
Clone method 102<br />
Close method 17, 27, 68<br />
CreateDynaset method 50<br />
CreateQueryDef method 70, 92<br />
CreateSnapshot method 56<br />
Data control 6<br />
Database object 5<br />
Delete method 29<br />
Dynaset object 5<br />
Edit method 83<br />
Execute method 101<br />
ExecuteSQL method 102<br />
Field object 6<br />
Fields collection 6<br />
Find method 72<br />
GetChunk method 98, 99<br />
Index object 6<br />
Indexes collection 6<br />
ListFields method 23<br />
ListIndexes method 23 </pre><br />
Keywords : kbdocerr APrgDataAcc<br /><br />
Version : 3.00<br /><br />
Platform : WINDOWS<br /><br />
Issue type :<br />
|}<br />
<br />
{|<br />
|width="100%"| <br /><br />
Last Reviewed: May 14, 1999<br /><br />
<span>© 2000 Microsoft Corporation. All rights reserved. Terms of Use.</span><br /><br />
|}</div>
3155ffGd