DOC: Data Access Guide Index in VB 3.0 - Mo through Z
ID: Q103703
|
The information in this article applies to:
-
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:
Q103702 DOC: Data Access Guide Index -- A through Me
MORE INFORMATION
The following file is available for download from the Microsoft
Download Center. Click the file name below to download the file:
Dataindx.exe
For more information about how to download files from the Microsoft
Download Center, please visit the Download Center at the following Web
address
http://www.microsoft.com/downloads/search.asp
and then click How to use the Microsoft Download Center.
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:
Keywords : kbdocfix kbdocerr kbDSupport APrgDataAcc
Version : WINDOWS:3.0
Platform : WINDOWS
Issue type :