Delphi Database Application Developer's Guide

READER TIPS......Page 0 TABLES......Page 206 Overview of Delphi's database features and capabilities......Page 2 What is a database?......Page 4 Understanding Delphi database architecture......Page 6 Understanding TTable......Page 8 Overview of the Database Forms Expert......Page 11 Language drivers......Page 17 2.3 A single-table form......Page 22 2.4 Important TDBNavigator properties for a single-table form......Page 23 2.5 A master-detail form......Page 26 2.6 One-many-many form......Page 29 2.9 TField component properties......Page 33 Formatting field values at run time......Page 40 Using lists and lookups......Page 44 2.11 Important TDBComboBox properties......Page 45 Printing reports and forms......Page 52 Using datasets......Page 57 Dataset states......Page 58 The First and Last methods......Page 60 Editing records......Page 63 Working with entire records......Page 64 Using OnCalcFields......Page 68 Editing Display properties......Page 83 Handling TField events......Page 85 Accessing TField properties programmatically......Page 86 Incorporating reports in an application......Page 88 Batch move modes......Page 89 Data type mappings......Page 90 3.15 Physical data type translations from InterBase tables to tables of other driver types......Page 91 CHAPTER 4: Using Data Controls......Page 99 Editing in the grid......Page 104 Using events to control grid behavior......Page 105 Navigating and manipulating records with TDBNavigator......Page 106 TDBComboBox......Page 109 Syntax requirements for live result sets......Page 120 Input and output parameters......Page 138 Sybase and Microsoft SQL servers......Page 142 InterBase......Page 143 Other communication protocols......Page 144 Specifying validity checks......Page 154 Using CREATE TABLE......Page 180 Using ALTER TABLE......Page 181 APPENDIX D: The MAST database......Page 183 FIGURES......Page 207 Overview of the Data Access page......Page 7 Overview of the Data Controls page......Page 10 Design phase......Page 14 MASTAPP aliases......Page 20 Building a single-table form......Page 21 2.4 Linking fields in a master-detail form......Page 25 2.8 Adding fields to a data set......Page 31 2.10 Defining a calculated field......Page 38 2.12 Setting a TQuery's SQL property......Page 48 2.13 Defining a query parameter......Page 49 Controlling database connections......Page 56 Opening and closing datasets......Page 59 The Field Link Designer......Page 76 Starting the Fields Editor......Page 80 Deleting a TField component......Page 81 Programming a calculated field......Page 82 Using the Input Mask Editor......Page 84 3.8 Sample form......Page 94 Displaying multiple views of a table......Page 95 Editing a field......Page 102 Setting grid options......Page 103 Displaying BLOB graphics with TDBImage......Page 108 TDBListBox......Page 110 TDBLookupCombo......Page 111 TDBCheckBox......Page 113 TDBRadioGroup......Page 114 Creating the query text......Page 117 Using the Visual Query Builder......Page 118 The UniDirectional property......Page 119 Preparing a query......Page 121 Using the DataSource property......Page 123 Handling server security......Page 132 Using the TDatabase component......Page 133 Creating application-specific aliases......Page 134 Executing a stored procedure......Page 139 Opening files......Page 148 Planning tables......Page 150 Creating a new table......Page 151 Creating indexes on SQL tables......Page 155 Naming SQL indexes......Page 156 Procedure......Page 157 Creating table lookup......Page 158 Prefixing the index name with the table name......Page 160 Viewing tables......Page 161 Customizing a table view......Page 162 Saving a custom view......Page 163 Using Edit mode......Page 164 What is the SQL Editor?......Page 167 Specifying an alias......Page 168 Querying table data with QBE......Page 169 A.21 A query and its results......Page 170 Creating and managing aliases......Page 171 Adding a new alias......Page 172 Modifying an existing alias......Page 173 What you should know first......Page 1 What is data access?......Page 5 Understanding TQuery......Page 9 Developing applications for desktop and remote servers......Page 12 Database application development cycle......Page 13 Deployment phase......Page 15 Deploying BDE support......Page 16 ODBC Socket......Page 18 Building forms......Page 19 Building a master-detail form......Page 24 Building a one-many-many form......Page 27 Creating Tfield components......Page 30 Setting Tfield properties at design time......Page 32 Reading field values......Page 34 Assigning values to fields......Page 35 Defining a calculated field......Page 37 Formatting field values at design time......Page 39 Searching for field values......Page 42 Validating data entry......Page 43 Writing code to check field values......Page 46 Using queries and ranges......Page 47 Setting a range......Page 50 Database components hierarchy......Page 55 The BOF and EOF properties......Page 61 The MoveBy function......Page 62 Setting the update mode......Page 65 Bookmarking data......Page 66 Disabling, enabling, and refreshing data-aware controls......Page 67 The TableType property......Page 69 Using Goto functions......Page 70 Limiting records retrieved by an application......Page 72 Using partial keys......Page 73 Indexes......Page 74 The ReadOnly and CanModify properties......Page 75 The AutoEdit property......Page 77 The OnStateChange event......Page 78 What are TField components?......Page 79 Using the FieldByName method......Page 87 Accessing the BDE directly......Page 92 Creating a master-detail form......Page 93 Data Control component basics......Page 100 Displaying data as labels with TDBText......Page 101 Displaying and editing BLOB text with TDBMemo......Page 107 TDBLookupList......Page 112 Using TQuery......Page 115 How to use TQuery......Page 116 Using the ParamByName method......Page 122 Creating heterogenous queries......Page 124 Portability versus optimization......Page 127 Client/server communication portability......Page 128 Building an application to access any server......Page 129 Connecting to a database server......Page 130 Connection parameters......Page 131 Handling transactions in applications......Page 135 Setting the SQL passthrough mode......Page 136 Transaction isolation levels......Page 137 Upsizing the database......Page 140 Upsizing the application......Page 141 Deploying ReportSmith support......Page 145 Starting Database Desktop......Page 147 Creating tables......Page 149 Keys in Paradox tables......Page 152 An SQL table's index......Page 153 Restructuring tables......Page 159 Adding, subtracting, and emptying records......Page 165 Deleting objects......Page 166 Deleting an alias......Page 174 Naming conventions for tables......Page 175 Supported set (aggregate) functions......Page 176 Supported operators......Page 177 Using the WHERE clause......Page 178 Using DELETE......Page 179 Using DROP INDEX......Page 182 Symbols - A......Page 187 B - C......Page 188 D......Page 189 E - F......Page 191 G - I......Page 192 J - M......Page 193 N - P......Page 194 Q - R......Page 195 S......Page 196 T......Page 197 U - V......Page 198 W......Page 199