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

- Microsoft Visual Basic programming system for Windows, version 3.0

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:

   ARTICLE-ID: Q103702
   TITLE     : DOC: Data Access Guide Index -- A through Me

MORE INFORMATION

The following file is available for download from the Microsoft Software Library:

 ~ Dataindx.exe (size: 36588 bytes) 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from
               Online Services

   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

   creating databases  24
   database engine, described  1
   databases in Visual Basic  3
   TableDef attributes  20

   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

   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

   See also External databases; VB.INI
   accessing  133
   data-type conversions  142
   deleting records  137
   indexes  142

   opening databases  11
   opening files  140
   primary keys  136
   support in Visual Basic  3

   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

   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

   databases  28 - 40
   existing queries  94

   current record, positioning  71
   deleting records  86
   positioning methods compared  69
   positioning the current record  68

   positioning methods compared  69
   recordsets  63

   positioning methods compared  69
   recordsets  63

   Dynasets  53

   SHARE.EXE  121, 122
   sharing SYSTEM.MDA  123

   Field object  34
   Fields collection  22
   mapping object properties  19
   recordsets  61
   TableDef object  19

   Find methods  72
   positioning the current record  68
   recordsets  61
   Seek method  74

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

   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

   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

   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

   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

   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

   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

   Btrieve tables  143
   dBASE tables  140
   external tables  138
   Microsoft FoxPro tables  140
   read only constant (DB_READONLY)  58
   recordsets  58
   SQLPassThrough option  59

   handling errors  83
   locking the Dynaset  54
   pages  91
   recordset properties  61

   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

   opening
   databases  11
   tables  49, 50

   SQLPassThrough option  59
   support in Visual Basic  3
   TableDef attributes  20

   Fields collection  22
   Field object  37

Packing .DBF files 140 Pages

   locking  54, 90
   removing  42 - 44

   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

   Admin username  120
   as a connect parameter  15
   external databases  135
   initialization statements  41, 42
   opening databases  13

   saving  20, 135
   saving in link information  30
   SetDefaultWorkspace statement  135

   implementation differences vs. Microsoft Access  120
   setting or modifying  42

   handling errors  83
   locking the Dynaset  54
   pages  90
   recordset properties  61

   described  116
   using with Microsoft Access databases  119

   features  4
   using the data control  110 - 114

   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

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

   creating Dynaset variables  50
   default collection  77
   default property  77
   methods (list)  6
   properties (list)  6

   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

   mapping object properties  19
   ODBC databases  152
   ODBC queries  16

   double (")  66
   single (')  66

   dynasets  55
   recordsets  30

   Dynasets  61
   ODBC queries  61
   recordsets  61
   Snapshots  61

   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

   properties and methods (list)  5
   rebuilding  30

   See also Dynasets
   creating Dynaset variables  50
   data control  82
   using in the Professional edition  111

   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

   implementation differences vs. Microsoft Access  119
   system tables  21
   using multiple tables 85

   DSN  (Data Source Name) argument  27, 151
   Microsoft SQL Server databases  154
   ODBC databases  151
   ODBC driver  151
   ODBC driver dialogs  151

   Dynaset  54
   pessimistic locking  90

   transaction logging  108
   using transactions  104

Secondary indexes 39 Security settings, implementation differences vs. Microsoft

   Access  119

   comparison strings  74
   current record, positioning  74
   deleting records  86
   key arguments  74
   positioning methods compared  69
   positioning the current record  68

   ExecuteSQL method  102
   ODBC server accounts  149
   'Server cannot be found' error  17
   server name as a connect parameter  15
   sharing tables  30

   initializing the engine  41
   initialization parameters  134
   specifying location of SYSTEM.MDA  120

   opening a secured database  42
   password-protected files  135
   setting UserID and password  120

   See also file README.TXT
   data corruption  121
   Microsoft Windows for Workgroups  122

   databases  121
   shared mode  12
   sharing SYSTEM.MDA  123

   default collection  77
   default property  77
   properties and methods (list)  5
   system tables  21

   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

   Dynaset  50, 53
   recordsets  61, 66

   Field object  37
   Fields collection  22

   alias names  147
   attaching external tables  145
   Field properties  37
   Fields collection  22
   recordsets  61
   TableDef object  19

   See also SQL Statements; Microsoft Access SQL; ANSI

   ! 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

   support in Visual Basic  3
   using QueryDef variables  91 - 96
   using SQL methods  100 - 102
   wildcard characters  126

   multiple transactions  106
   recordset methods  58

   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

   See also file DRVSSRVR.HLP

   modifying  28 - 40
   mapping
   object properties  19
   overview  18
   table definitions  19

   See SQL; Microsoft Access SQL; ANSI SQL;
   individual SQL functions and statements

   ! 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

Table object

   default collection  77
   default property  77
   properties and methods (list)  5

   adding records  86
   creating  49
   selecting records  66
   using  50

   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

   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

   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

   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

   mapping object properties  19
   recordsets  61

   Field object  35
   Fields collection  22

   mapping object properties  19
   recordsets  61
   TableDef object  19

   adding records  86
   editing records  82
   handling errors  83
   locking dynasets  54
   pessimistic locking  90
   Snapshot  56

   implementation differences vs. Microsoft Access  120
   including in SQL statements  126

Validating a database 45 Value property

   Fields collection  22
   fields  80 - 82

   bookmarks  76
   handling large fields  98
   Null values  80

   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

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

Keywords          : APrgDataAcc
Version           : 3.00
Platform          : WINDOWS
Issue type        : kbdocerr
Solution Type     : kbfile