Delphi for Windows

READER TIPS......Page 0
FIGURES......Page 224
The InterBase Documentation Set......Page 1
Syntax Conventions......Page 2
InterBase Features......Page 11
CHAPTER 3: Working With Transactions......Page 21
Specifying SET TRANSACTION Behavior......Page 22
3.3 SET TRANSACTION Parameters......Page 23
3.4 ISOLATION LEVEL Options......Page 25
Comparing Isolation Levels......Page 26
Lock Resolution......Page 30
3.7 Table Reservation Options for the RESERVING Clause......Page 32
4.1 Order of Metadata Extraction......Page 46
Basic ISQL Settings......Page 48
Displaying Database Information and Metadata......Page 51
ISQL SET Statements......Page 55
Creating Tables......Page 75
6.2 DEPARTMENT Table......Page 76
Overview of SELECT......Page 103
Using the WHERE Clause......Page 106
Comparison Operators......Page 107
Conditions for Subqueries......Page 113
Using Aggregate Functions......Page 115
Using CAST( ) to Convert Data Types......Page 122
APPENDIX A: Error Messages......Page 171
Client Workstation Requirements......Page 175
Installation Changes......Page 176
TCP/IP Interface......Page 177
Borland Language Drivers for InterBase......Page 181
Working With InterBase Servers......Page 182
InterBase Data Type Translations......Page 183
B.10 dBASE to InterBase and Paradox Data Type Translations......Page 184
B.11 Paradox to BDE Logical to dBASE Data Type Translations......Page 185
InterBase Equivalents to Standard SQL Data Types......Page 186
InterBase System Relations/Tables......Page 187
InterBase Field-naming Rules......Page 188
Domains......Page 189
C.3 Complex Example Domains......Page 190
Example Database Tables......Page 193
C.5 DEPARTMENT Table......Page 194
C.6 JOB Table......Page 195
C.7 SALES Table......Page 196
C.9 CUSTOMER Table......Page 197
C.11 PROJ_DEPT_BUDGET Table......Page 198
C.13 SALARY_HISTORY Table......Page 199
Connecting to a Data Source Using a Connection String......Page 204
Isolation and Lock Levels Supported......Page 205
ODBC Conformance Level......Page 206
D.6 ODBC Statement Options......Page 208
Installation......Page 10
Columns......Page 16
Troubleshooting Common Connection Problems......Page 179
C.1 EMPLOYEE Database......Page 191
Database Object-naming Conventions......Page 3
Primary File Specifications......Page 4
Secondary File Specifications......Page 5
PART I: Overview......Page 7
What is the Borland Local InterBase Server?......Page 9
Multi-generational Architecture......Page 12
Performing Database Backup and Recovery......Page 13
Viewing Statistics......Page 14
Building Databases......Page 15
Date Data Types......Page 17
Referential Integrity Constraints......Page 18
Stored Procedures......Page 19
Triggers......Page 20
Isolation Level......Page 24
Choosing Between SNAPSHOT and READ COMMITTED......Page 27
Starting a Transaction With READ COMMITTED Isolation Level......Page 28
Starting a Transaction With SNAPSHOT TABLE STABILITY Isolation Level......Page 29
RESERVING Clause......Page 31
Using COMMIT......Page 33
Using ROLLBACK......Page 34
PART II: Windows ISQL......Page 35
Starting and Exiting Windows ISQL......Page 37
Getting Help......Page 38
Connecting to a Database......Page 39
Creating a Database......Page 40
Disconnecting From a Database......Page 41
Executing SQL Interactively......Page 42
Executing an ISQL Script File......Page 43
Saving ISQL Output......Page 44
Extracting Database Metadata......Page 45
Extracting View Metadata......Page 47
Advanced ISQL Settings......Page 49
Displaying Settings......Page 50
Creating an ISQL Script File......Page 53
Committing and Rolling Back Work......Page 54
PART III: Tutorial......Page 69
CHAPTER 6: Getting Started With Windows ISQL......Page 71
An Overview of SQL......Page 72
Creating a Database......Page 73
Conceptual Database Design......Page 74
Primary Keys and Foreign Keys......Page 77
Adding Data to Tables......Page 78
Testing Referential Integrity......Page 79
Viewing Data......Page 80
Modifying Data......Page 82
Ending the ISQL Session......Page 83
More Conceptual Design......Page 85
Normalization......Page 86
Defining Domains......Page 87
Using Data Definition Files......Page 88
Starting Over......Page 90
Creating More Tables......Page 91
Creating Indexes......Page 92
Modifying Indexes......Page 93
Moving On......Page 94
Inserting Data Using Column Values......Page 95
Inserting Data From an External File......Page 96
Updating Data......Page 99
Deleting Data......Page 100
Deleting Data Using a Subquery......Page 101
Selecting From a View......Page 104
Removing Duplicate Rows With DISTINCT......Page 105
STARTING WITH Operator......Page 108
Comparing Against a Range or List of Values......Page 109
Logical Operators......Page 110
Controlling the Order of Evaluation......Page 111
Using Subqueries......Page 112
Using ANY, EXISTS, and SINGULAR......Page 114
Grouping Query Results......Page 116
Using the ORDER BY Clause......Page 118
Joining Tables......Page 119
Inner Joins......Page 120
Outer Joins......Page 121
Converting to Uppercase......Page 123
Triggers......Page 125
Generating Unique Column Values With Triggers......Page 126
Posting an Event With a Trigger......Page 128
Stored Procedures......Page 129
A Simple Select Procedure......Page 130
A Recursive Procedure......Page 131
PART IV: Server Manager......Page 135
CHAPTER 11: Introduction to Server Manager......Page 137
Server Manager Menus......Page 138
Server/Database Tree......Page 139
Summary Information Area......Page 140
The Database Maintenance Window......Page 141
Standard Text Display Window......Page 142
Database Backup and Restoration......Page 143
Using Online Help......Page 144
Connecting to a Database......Page 145
The Database Maintenance Window......Page 147
Configuring Database Properties......Page 148
Overview of Sweeping......Page 149
Two-phase Commit and Transaction Recovery......Page 150
Recovering Transactions......Page 151
Validating and Repairing a Database......Page 153
Handling Checksum Errors......Page 155
Repairing a Corrupt Database......Page 156
Using the Backup and Restore Utilities......Page 159
Backing Up a Database......Page 160
Transportable Format......Page 161
Ignore Transactions in Limbo......Page 162
Verbose Output......Page 163
Restoring a Database......Page 164
Restore Options......Page 165
Replace Existing Database......Page 166
Do Not Restore Validity Conditions......Page 167
Upgrading to a New On-disk Structure......Page 168
Testing the InterBase Connection......Page 178
Stored Procedures......Page 192
ODBC Files......Page 201
Configuring Data Sources......Page 202
Connecting to a Data Source Using a Logon Dialog Box......Page 203
Symbols - C......Page 209
D......Page 210
E - F......Page 211
G - M......Page 212
N - P......Page 213
Q - S......Page 214
T - V......Page 216
W......Page 217