Microsoft KB Archive/103703

From BetaArchive Wiki
Knowledge Base


DOC: Data Access Guide Index in VB 3.0 - Mo through Z

PSS ID Number: 103703

Article Last Modified on 12/22/2001



The information in this article applies to:

  • Microsoft Visual Basic Standard Edition for Windows 3.0



This article was previously published under Q103703

SUMMARY

Dataindx.exe is a Word document that contains the Mo through Z Index for the Data Access Guide in the Professional Features Book 2 of Visual Basic version 3.0. The index was omitted from the book. The index in the very back of the manual is for the Crystal Reports section of the manual only.

For the A through Me portion of the index, please see the following article in the Microsoft Knowledge Base:

103702 DOC: Data Access Guide Index -- A through Me


MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services


Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on secure servers that prevent any unauthorized changes to the file.

Move method  71
   QueryDef object  6
   Recordset objects  5
   recordsets  57 - 59
   Refresh method  30
   Seek method  74
   Snapshot object  5
   Table object  5
   TableDef object  6
   TableDefs collection  6
   Update method  82
   using SQL methods  100 - 102
Microsoft Access
   creating databases  24
   database engine, described  1
   databases in Visual Basic  3
   TableDef attributes  20
Microsoft Access databases
   accessing OLE graphics  109
   changing version  42
   combining data with external format databases  30
   compacting  42 - 44
   creating  25
   See also CreateDatabase function
   database readable by version 1.0  27
   DLLs  119
   errors opening  13
   exclusive access  12
   implementation differences vs. Visual Basic  119
   initialization statements  41 - 42
   locking  54
   locale, setting  25, 42
   login names  13
   making readonly  12
   opening  11
   passwords  13
   permissions, setting or modifying  42
   repairing  45
   security  120
   sharing  12
   using the Visual Basic database engine  119
   versions 1.0 and 1.1  44, 119
Microsoft Access SQL
   See also SQL; Microsoft SQL Server
   compared to ANSI SQL
   ANSI SQL data types  126
   BETWEEN  126
   INSERT  129
   LIKE  126
   wildcard characters  126
   enhanced features  126
   overview  125
   reserved words table  127
   syntax  128
Microsoft FoxPro databases
   See also External databases; VB.INI
   accessing  133
   data-type conversions  142
   deleting records  137
   indexes  142
Microsoft Access security  120
   opening databases  11
   opening files  140
   primary keys  136
   support in Visual Basic  3
Microsoft LAN Manager  154
Microsoft SQL Server
   See file DRVSSRVR.HLP
   See also External databases; SQL; Microsoft Access SQL
   accessing
   ODBC data sources  149
   SQL Server databases  133, 154
   connections  154
   connection timeout  See file PERFORM.TXT
   default database  154
   ExecuteSQL method  59
   INSTCAT.48 (Sybase)  154
   INSTCAT.SQL (SQL)  154
   locking  87
   login ID  154
Memo fields  35
Microsoft LAN Manager  154
   network location  154
   opening databases  11
   opening tables  49, 50
   permissions  154
   security  154
   SQLPassThrough option  59
   SQLSRVR.HLP  154
   See also file DRVSSRVR.HLP
   support in Visual Basic  3
   TableDef attributes  20
Microsoft Windows for Workgroups  122
Min function (SQL)  132
MKDIR  27
Modifying
   databases  28 - 40
   existing queries  94
Move methods
   current record, positioning  71
   deleting records  86
   positioning methods compared  69
   positioning the current record  68
MoveFirst method  69
MoveLast method
   positioning methods compared  69
   recordsets  63
MoveNext method
   positioning methods compared  69
   recordsets  63
MovePrevious method  69
Multiple databases, transaction processing  106
Multitasking, managing idle time  45
Multiuser considerations
   Dynasets  53
multiuser databases, locking  87 - 91
   SHARE.EXE  121, 122
   sharing SYSTEM.MDA  123

Name field, ListTables snapshot  23
Name property  39
   Field object  34
   Fields collection  22
   mapping object properties  19
   recordsets  61
   TableDef object  19
National language as an ODBC connect parameter  15
Native databases  See Microsoft Access databases
Nested transactions  106
Networks, accessing external tables  135
NoMatch property
   Find methods  72
   positioning the current record  68
   recordsets  61
   Seek method  74
Nordic rules (locale constant)  37, 44
Norwegian rules (locale constant)  26, 37, 44
NOT statement (SQL)  131
Novell Btrieve for Windows  144
Novell Netware SQL  144
NULL statement (SQL)  131, 132
Null values  54, 73, 80, 117
Number data type  35
NUMBER statement (SQL)  128
NUMERIC statement (SQL)  128

Object names, determining  18
Object properties, determining  18
Object variables, creating  25
Objects
   Database  5
   default form  77
   default names  77
   default property  77
   Dynaset  5
   Field  6
   Index  6
   (list)  23
   names
   ! syntax  79
   brackets ([ ])  79
   embedded spaces  79
   QueryDef  6
   Recordset  5
   Snapshot  5
   summarized  5
   syntax for addressing objects  77
   Table  5
   TableDef  6
ODBC API libraries, support in Visual Basic  3
ODBC databases
   Search Help for SQL Server ODBC driver; ODBC
   See also External databases
   accessing  54, 133
   accessing ODBC data sources  149 - 153
   achieving optimal performance  147
   connect parameters  15
   connect string  14
   creating  27
   creating database variables  49
   default database  15
   deleting  28
   DSN (Data Source Name)  14
   ExecuteSQL method  102
   locking  54, 87 - 91
   LOGINTIMEOUT  152
   LoginTimeout parameter  17
ODBC control panel  151
ODBC keywords  151
ODBC.INI  14, 15, 27, 151, 154
opening  11, 14
Oracle databases  153
   See also file DRVORACL.HLP
   passwords  15, 135
   primary keys  136
   QUERYTIMEOUT  152
   QueryTimeout property  16
   RegisterDatabase function  151
   setting
   default database  15
   password  15
   timeout values  152
   user ID  15
   SQL Server databases  154
   See also file DRVSSRVR.HLP
   SQL PassThrough  59, 100 - 102, 106
   support in Visual Basic  3
   Table objects  149
   TableDef attributes  20
   TableName  19
   transaction control  106
   user ID  15
   using  14 - 17
   workstation ID  15
ODBC libraries, support in Visual Basic  3
ODBC servers, SQLPassThrough option  59
ODBC.INI  14, 15, 27, 151, 154
OLE graphics, implementation differences vs. Microsoft Access  119
One-to-many joins  84
One-to-one joins  84
OpenDatabase function
   connect argument  138
   connect part  11
   connect string  149
   creating external databases  27
   databasename part  11
   example  10
   exclusive mode  12
   exclusive part  12, 88
   initializing the database engine  41
   login timeout  152
   LoginTimeout parameter  17
ODBC databases  151
   opening
   Btrieve tables  143
   databases  10
   dBASE tables  140
   external tables  137, 138
   Microsoft FoxPro tables  140
   overview  10
   passwords  135
   readonly part  13, 88
   shared mode  12
   special conditions  13
   syntax  10
   using with the data control  14
Opening
   Btrieve tables  143 - 145
   databases  10
   as exclusive  12
   as read-only  13
   as shared  12
   different types of databases  14
   initialization statements  41 - 42
   possible problems  13
   programmatically  10 - 14
   special conditions  13
   with the data control  10
   dBASE tables  140
   external tables  137 - 138
   Microsoft FoxPro tables  140
   Paradox tables  138 - 140
OpenTable method
   against ODBC tables  49, 50
   append only constant (DB_APPENDONLY)  58
   consistent updates  58
   creating table variables  49
   deny read constant (DB_DENYREAD)  58
   deny write constant (DB_DENYWRITE)  58
   inconsistent updates  58
opening
   Btrieve tables  143
   dBASE tables  140
   external tables  138
   Microsoft FoxPro tables  140
   read only constant (DB_READONLY)  58
   recordsets  58
   SQLPassThrough option  59
Optimistic locking
   handling errors  83
   locking the Dynaset  54
   pages  91
   recordset properties  61
OPTION statement (SQL)  127
Options, compacting database  44
Options argument, create recordset methods  58 - 59
Options constants  59
Options part, CreateDatabase function  27
Options property, Refresh method  30
OR statement (SQL)  132
ORA6WIN.DLL (Oracle)  153
Oracle databases
   See also External databases; VB.INI
   See also file DRVORACL.HLP
   accessing  133, 153
   accessing ODBC data sources  149
   AUTOEXEC.BAT  153
   CONFIG.ORA (Oracle)  153
   locking  88
   Microsoft Access security  120
ODBC driver  153
   opening
   databases  11
   tables  49, 50
ORA6WIN.DLL  153
ORACLE.HLP  153
ORACLE.TXT  153
   SQLPassThrough option  59
   support in Visual Basic  3
   TableDef attributes  20
ORACLE.HLP  153
ORACLE.TXT  153
ORDER statement (SQL)  127
ORDER BY statement (SQL)  131
ORDER BY clause  61, 64
Ordering records  50
Ordering recordsets  63 - 64
Ordinal property, accessing fields  81
OrdinalPosition property
   Fields collection  22
   Field object  37
OWNERACCESS statement (SQL)  127

Packing .DBF files  140
Pages
   locking  54, 90
   removing  42 - 44
PageTimeout  148
Paradox databases
   See also External databases; VB.INI
   accessing  133, 138 - 140
   bookmarks  76
   data-type conversions  140
   indexes  139
   Microsoft Access security  120
   opening databases  11
   passwords  135
   primary keys  136, 139
   support in Visual Basic  3
   TableDef attributes  20
ParadoxNetPath  148
ParadoxUserName  148
Parameter queries  96
Parameters, (list)  23
PARAMETERS statement (SQL)  126, 127, 128
Passing action queries to ODBC server  59
Passwords
   Admin username  120
   as a connect parameter  15
   external databases  135
   initialization statements  41, 42
   opening databases  13
Paradox databases  135
PWD (password)  15, 135
   saving  20, 135
   saving in link information  30
   SetDefaultWorkspace statement  135
Performance tuning  See file PERFORM.TXT
Permissions
   implementation differences vs. Microsoft Access  120
   setting or modifying  42
Pessimistic locking
   handling errors  83
   locking the Dynaset  54
   pages  90
   recordset properties  61
Picture box control (bound control)
   described  116
   using with Microsoft Access databases  119
PICTURE statement (SQL)  128
PIVOT statement (SQL)  127, 129
Portuguese rules (locale constant)  36, 37
Positioning methods  69
Positioning the current record  68 - 76
Primary keys  136, 139, 54, 64
Primary property  39
Print statement, manipulating files  3
PROCEDURE statement (SQL)  127
Professional Edition
   features  4
   using the data control  110 - 114
Programs, creating  47 - 108
Properties
   See also individual properties; Quick Reference chart on
   back cover
   Data control  6
   Database object  5
   default  77
   Dynaset object  5
   Field object  6
   Fields collection  6
   Index object  6
   Indexes collection  6
   QueryDef object  6
   Recordset objects  5
   recordsets  61
   Snapshot object  5
   Table object  5
   TableDef object  6
   TableDefs collection  6
Put statement, manipulating files  3
PWD (password)  15, 135

Queries
   action queries  70
   building dynamically  95
   closing  93
   coding rules for SQL queries  102
   creating a new query  92
   crosstab queries  126
   deleting  93
   embedded functions  120
   (list)  23
   modifying existing  94
   overview  48
   parameter queries  93, 96
   parameters  24
   passing action queries to ODBC server  59
   performance issues  147
   RecordCount property  61
   running  93
   saving a predefined query  91
   subqueries  127
   summary value queries  112
   temporary space allocations  137
   using existing  93
   using QueryDef variables  91 - 96
Query timeout  152
QueryDef object
   creating Dynaset variables  50
   default collection  77
   default property  77
   methods (list)  6
   properties (list)  6
QueryDefs
   building queries dynamically  95
   closing  93
   creating  92
   declaring  91
   deleting  93
   manipulating recordsets  95
   Microsoft Access SQL  125
   modifying existing queries  94
   parameter queries  96
   running  93
   SQL property  94
   using  91 - 96
QUERYTIMEOUT  152
QueryTimeout property
   mapping object properties  19
   ODBC databases  152
   ODBC queries  16
Quotation marks
   double (")  66
   single (')  66

Random file-access, support in Visual Basic  3
Read only constant (DB_READONLY)  58
ReadAheadPages  148
Readonly part  13
ReadOnly property, Refresh method  30
REAL statement (SQL)  127, 128, 129
Rebuilding
   dynasets  55
   recordsets  30
RecordCount field, ListTables snapshot  23
RecordCount property
   Dynasets  61
   ODBC queries  61
   recordsets  61
   Snapshots  61
Records
   See also Dynasets; recordsets; Snapshots, Tables
   adding  54, 86
   changing  54
   deleting  137, 54, 86
   editing  82 - 84
   errors when adding records  86
   ordering  50
   positioning  68 - 76
   selecting  50, 66
   sharing in cloned Dynasets  102
   sorting  63 - 64
Recordset objects
   properties and methods (list)  5
   rebuilding  30
Recordset property
   See also Dynasets
   creating Dynaset variables  50
   data control  82
   using in the Professional edition  111
Recordset variables  48
Recordsets
   See also Dynasets, Snapshots, Tables
   action queries  70
   append only constant  58
   bulk changes  70
   cloned recordsets  76
   cloning recordset variables  102
   closing  68
   creating  48 - 68
   current record, positioning  68 - 76
   data sources and attributes  61
   DATA_ACTIONUNLOAD  68
   deny read constant (DB_DENYREAD)  58
   deny write constant (DB_DENYWRITE)  58
   Filter property  66
   filtering and sorting  61
   locking  61
   managing
   bookmarks  61
   pointer  61
   manipulating data  77 - 91
   manipulating with QueryDef variables  95
   methods, specifying arguments  57 - 59
   multiple recordsets  114
   options argument  58
   options constants  59
   ordering  63 - 64
   positioning methods compared  69
   properties  61
   read only constant (DB_READONLY)  58
   selecting records  66
   sharing bookmarks  76
   source argument  57
   SQLPassThrough option  59
   transaction processing  61
RecordSource property, SQL queries  111
Referential integrity
   implementation differences vs. Microsoft Access  119
   system tables  21
   using multiple tables 85
Refresh method  30, 41, 55
Refreshing the data control  30
RegisterDatabase statement
   DSN  (Data Source Name) argument  27, 151
   Microsoft SQL Server databases  154
   ODBC databases  151
   ODBC driver  151
   ODBC driver dialogs  151
Registering the DSN (Data Source Name)  27
Releasing resources  17
Removing discarded pages  42 - 44
RepairDatabase statement  45
Resources, releasing  17
RIGHT statement (SQL)  127, 130
Rollback method
   Dynaset  54
   pessimistic locking  90
Rollback statement
   transaction logging  108
   using transactions  104
Running queries  93

Secondary indexes  39
Security settings, implementation differences vs. Microsoft
   Access  119
Seek method
   comparison strings  74
   current record, positioning  74
   deleting records  86
   key arguments  74
   positioning methods compared  69
   positioning the current record  68
SELECT statement (SQL)  127, 129
Selecting records  50
Sequential file-access, support in Visual Basic  3
Servers
   ExecuteSQL method  102
   ODBC server accounts  149
   'Server cannot be found' error  17
   server name as a connect parameter  15
   sharing tables  30
Sessions, transaction operations  106
Set statement  25
SET statement (SQL)  127, 129
SetDataAccessOption statement
   initializing the engine  41
   initialization parameters  134
   specifying location of SYSTEM.MDA  120
SetDefaultWorkspace statement
   opening a secured database  42
   password-protected files  135
   setting UserID and password  120
SHARE.EXE
   See also file README.TXT
   data corruption  121
   Microsoft Windows for Workgroups  122
Sharing
   databases  121
   shared mode  12
   sharing SYSTEM.MDA  123
SHORT statement (SQL)  127, 128, 129
Single data type  35
SINGLE statement (SQL)  128, 129
Size property  22, 35
SMALLINT statement (SQL)  127, 128, 129
Snapshot object
   default collection  77
   default property  77
   properties and methods (list)  5
   system tables  21
Snapshots
   See also Dynasets, Recordsets, Tables
   accessing fields  80 - 82
   bookmarks  76
   creating from existing Dynaset  56
   creating  48 - 68
   Filter property  66
   membership  48
   Microsoft Access SQL  125
   options  58
   overview  48
   read/write privileges  56
   sorting  64
   SQL PassThrough  59
   SQL query processing  56
   table update procedures  56
Sort order  22, 36, 39, 53, 63 - 64
Sort property
   Dynaset  50, 53
   recordsets  61, 66
Snapshots  64
Sorting  63 - 64
Source argument  57
SourceField property
   Field object  37
   Fields collection  22
Sourcename  43
SourceTable property  37
SourceTableName property
   alias names  147
   attaching external tables  145
   Field properties  37
   Fields collection  22
   recordsets  61
   TableDef object  19
Spanish rules (locale constant)  26, 37, 44
SQL
   See also SQL Statements; Microsoft Access SQL; ANSI
SQL
   ! symbol  66
   action queries  101
   ANSI SQL  126
   Avg  132
   bulk operations  101
   coding rules for SQL queries  102
   creating Dynaset variables  50
   data types compared, ANSI vs.
   Microsoft Access SQL  128
   domain functions  132
   embedded SQL statements  70
   in queries  48
   in RecordSource property  111
   joins  126
   passing action queries to ODBC server  59
   reserved words table  127
SQL views  149
SQLPassThrough option  59
   support in Visual Basic  3
   using QueryDef variables  91 - 96
   using SQL methods  100 - 102
   wildcard characters  126
SQL PassThrough
   multiple transactions  106
   recordset methods  58
SQL property, modifying existing queries  94
SQL functions and statements
   ALL  127
   ALTER  127
   AND  132
   AS  127
   ASC  127, 131
   BETWEEN  126, 130
   BINARY  127, 128, 129
   BIT  127
   BOOLEAN  129
   BY  127
   BYTE  128, 129
   CHAR[ACTER]  127, 128, 129
   Count  132
   Count(*)  132
   CREATE  127
   CURRENCY  127, 128, 129
   DATABASE  127
   DATETIME  127, 128, 129
   DECIMAL  128
   DELETE  127, 129
   DESC  127, 131
   DISTINCT  127, 129
   DISTINCTROW  127
   DOUBLE  128, 129
   DOUBLE PRECISION  128
   DROP  127
   First  132
   FLOAT  127, 128, 129
   FROM  127
   GROUP  127
   GROUP BY  130
   HAVING  127, 130
   IEEESINGLE  127
   IN  127, 131
   INNER  127, 130
   INSERT  127, 129
   INSERT INTO  129
   INT[EGER]  127, 128, 129
   INTO  127, 129
   IS  131
   JOIN  127, 130
   Last  132
   LEFT  127, 130
   LEVEL  127
   LIKE  126, 131
   LONG  127, 128, 129
   LONGBINARY  127, 128, 129
   LONGTEXT  127, 128, 129
   Max  132
   Min  132
   NOT  131
   NULL  131, 132
   NUMBER  128
   NUMERIC  128
   OPTION  127
   OR  132
   ORDER  127
   ORDER BY  131
   ORDER BY clause  61, 64
   OWNERACCESS  127
   PARAMETERS  126, 127, 128
   PARAMETERS declaration  96
   PICTURE  128
   PIVOT  127, 129
   PROCEDURE  127
   REAL  127, 128, 129
   RIGHT  127, 130
   SELECT  127, 129
   SELECT queries  93
   SET  127, 129
   SHORT  127, 128, 129
   SINGLE  128, 129
   SMALLINT  127, 128, 129
   StDev  132
   StDevP  132
   Sum  132
   TABLEID  127
   TEXT  127, 128, 129
   TIMESTAMP  128
   TRANSFORM  126, 127, 129
   UNION  127
   UPDATE  127, 129
   VALUE  127
   Var  132
   VARCHAR  128, 129
   VarP  132
   WHERE  127, 129, 132
   WHERE clauses  66, 68, 72
   WITH  127
   WITHOWNERACCESS OPTION  129
SQLSRVR.HLP  154
   See also file DRVSSRVR.HLP
Standard Edition features  4
Statements, usable for data access  7
Static recordset variables  68
StDev function (SQL)  126, 132
StDevP function (SQL)  132
StrComp function, mapping Field properties  22
String data types  35
String variables  98
Structure
   modifying  28 - 40
   mapping
   object properties  19
   overview  18
   table definitions  19
Structured Query Language (SQL)
   See SQL; Microsoft Access SQL; ANSI SQL;
   individual SQL functions and statements
Subqueries  127
Sum function (SQL)  132
Swedish rules (locale constant)  26, 37, 44
SYBASE SQL Server, support in Visual Basic  3
Syntax
   ! operator  66, 78, 79, 97
   addressing objects  77
   brackets  77, 80
   coding rules for SQL queries  102
   embedded spaces  77
   Microsoft Access SQL syntax  128
SQL syntax  125
System tables  21
SYSTEM.MDA  42, 120, 123

Table object
   default collection  77
   default property  77
   properties and methods (list)  5
Table variables
   adding records  86
   creating  49
   selecting records  66
   using  50
TableDef object
   adding  28
   adding to TableDefs collection  33
   append order  37
   attributes  20
   Attributes property  19, 149
   Connect property  19
   creating  31
   current settings  20
   DateCreated property  19
   default collection  77
   default property  77
   deleting  28
   LastUpdated property  19
   login timeout  152
   mapping  19, 21
   methods (list)  6
   Name property  19
   properties (list)  6
   SourceTableName property  19
   Updatable property  19
TableDefs collection
   adding new TableDef  33
   Append method  29, 31
   Count property  19
   creating indexes  37 - 38
   mapping  19
   members  28
   methods (list)  6
   properties (list)  6
   system tables  21
TABLEID statement (SQL)  127
TableName  19
Table objects
   See also Dynasets, Recordsets, Snapshots; TableDef
   object; TableDefs collection
   accessing
   fields  80 - 82
   Paradox tables  138 - 140
   adding a field  33
   adding to a database  33
   alias names  147
   attached tables, TableDef properties  19
   attaching
   a table (example)  145
   from external databases  30
   tables from Microsoft Access databases  146 - 147
   creating  48 - 68
   deleting  34
   indexes  63
   (list)  23
   locking  89
   membership  48
   ODBC tables  49, 50
   overview  48
   referential integrity  84
   sorting  63
   SQL PassThrough  49, 50, 59
   updating multiple tables  84
TableType field, ListTables snapshot  23
TEMP environment variable  137
Text box control (bound control)  116
TEXT statement (SQL)  127, 128, 129
Time-out errors  16, 17
Timeout values  152 - 153
TIMESTAMP statement (SQL)  128
TinyInt data type  35
Transactions
   beginning  104
   committing changes  104
   logging  108
   multiple databases  106
   multiple transactions  106
   nested transactions  106
   rolling back changes  104
   supported methods  104
   supported statements  104
   too many pending transactions  106
   transaction logging  108
   trappable error # 2004  108
   using  104 - 108
Transactions property
   mapping object properties  19
   recordsets  61
TRANSFORM statement (SQL)  126, 127, 129
True/False data type  35
Type property
   Field object  35
   Fields collection  22

UID (User ID name)  15
Unbound controls  118
UNC (Universal Naming Convention) file names  26, 135
UNION statement (SQL)  127
Unique indexes  54
Unique property  37, 39
Updatable property
   mapping object properties  19
   recordsets  61
   TableDef object  19
Update method
   adding records  86
   editing records  82
   handling errors  83
   locking dynasets  54
   pessimistic locking  90
   Snapshot  56
UPDATE statement (SQL)  127, 129
Updates, consistent and inconsistent  58
User ID name as a connect parameter  15
User-defined functions
   implementation differences vs. Microsoft Access  120
   including in SQL statements  126
Username  120

Validating a database  45
Value property
   Fields collection  22
   fields  80 - 82
VALUE statement (SQL)  127
Var function (SQL)  132
VARCHAR statement (SQL)  128, 129
Variant variables
   bookmarks  76
   handling large fields  98
   Null values  80
VarP function (SQL)  126
VB.INI
   See also file PERFORM.TXT
   Btrieve  148
   'Cannot find installable ISAM' error  134
   changing name of the system database  120
   CollatingSequence  148
   CommitLockRetry  148
   dBASE III, IV  148
   default settings  148
   DELETED parameter  137
   DELETED setting  140
   initializing the database engine  41
   installable ISAMs  148
   LockRetry  148
   MaxBufferSize  148
   Microsoft FoxPro  148
   PageTimeout  148
   Paradox  148
   ParadoxNetPath  148
   ParadoxUserName  148
   ReadAheadPages  148
VBSQL  See Microsoft SQL Server
Visual Basic format databases  See Microsoft Access databases
Visual Basic SQL Libraries, support in Visual Basic  3
Visual Basic, implementation differences vs. Microsoft Access  119
VSHARE.386 (Enhanced mode)  122

WBTRCALL.DLL  144
WHERE clauses  66, 68, 72, 129, 132
WHERE statement (SQL)  127, 129, 132
Wildcard characters  126
WIN.INI file settings  144, 149
WITH statement (SQL)  127
WITHOWNERACCESS OPTION (SQL)  129
Workstation ID as a connect parameter  15
WSID (Workstation ID)  15

Xtrieve  143

Yielding control  45
                


Additional query words: Dataindx

Keywords: kbdocerr kbdocfix kbDSupport KB103703
Technology: kbAudDeveloper kbVB300 kbVB300Search kbVBSearch