Microsoft KB Archive/103703

= 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:

Dataindx.exe

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 (&quot;) 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.