Symbols

Online Data Entry Jobs

Online Data Entry Jobs

Get Instant Access

" (quotation mark), naming conventions 175, 176 * operator 177

  • plus) sign in property lists 103 + operator 177 / operator 177
  • colon) in SQL statements 117, 176

< operator 177 <> operator 177 = operator 177 > operator 177 ? (question mark) in SQL statements 176 II operator 177

  • minus) sign in property lists 104
  • operator 177
  • apostrophe), naming conventions 175, 176

abandoning changes 64, 101, 107 Abort procedure 68 AbortOnKeyViol property 92 AbortOnProblem property 92 accessing data 79, 89, 100, 115, 116 at run time 87-88 field values 30, 32 optimizing access 119 remote servers 127, 141 data sources 5, 99 networks and 5 property values 40, 86 Active property datasets 59, 101 queries 50, 119 Add command (Database

Desktop) 165 Add Fields window 81 Add method 118 Add New Alias dialog box 172 ADD operations 181 adding See creating AfterCancel event 68 AfterClose event 68 AfterDelete event 68

AfterEdit event 68 AfterInsert event 68 AfterOpen event 68 AfterPost event 68 aggregate functions 141,

176-177, 179 Alias Manager 172 Alias Manager dialog box (Database Desktop) 149 aliases 5, 149, 171-174 changing 173 defined 149 deleting 174 local SQL and 175 predefined 20 queries 168

heterogenous 124 retrieving defaults 135 retrieving information 57 saving 172, 173 specifying 134, 172 Aliases command (Files) 149 Aliases page (BDE Configuration

Utility) 172 AliasName property 135 alignment, text 108 Alignment property 33, 83, 108 ALTER TABLE keyword 181 altering See changing ancestor objects 55 AND operator 177 ANSI/OEM conversion 93 ANSI-standard SQL naming conventions 175-176 Answer tables 170 apostrophe ('), naming conventions 175, 176 Append method 64 AppendRecord method 65 applications 79, 93 building 19 client/server 14, 118 deploying 16-18

remote servers 142-145 developing 12-16

client/server 127-129 fundamentals 13 displaying multiple views 95-97 multiuser 5, 135, 147 updating data 65

optimizing 128 sample

LINKQRY 123 MASTAPP 20, 183 TWOFORMS 95 starting 173 upsizing 140-142 ApplyRange method 51, 73 arithmetic operators 177 arrays 65, 72, 73 indexes 74 queries 122 stored procedures 139 AsBoolean property 35 ASCII files 6, 70 AsDateTime property 35 AsFloat property 35 AsInteger property 35 assigning values 37, 154 at run time 87, 88 calculated fields 68-69, 82-83 default 109, 154 names as 122 required 154 run-time 35 to buttons 114 to combo boxes 109 assignment statements 86 AsString property 35 asynchronous communication module 144 attaching to servers 5, 8, 56 remote databases 130-133 Connected property and 134 connection parameters 131-132 login parameters 133 attributes See display attributes;

properties AUTO ODBC setting 132 AutoCalcFields property

OnCalcFields event and 68 AutoDisplay property 108, 109 AutoEdit property 22, 77, 101 automatically translating data 12 AutoSize property 102 AutoUnload property 88 averages 176 AVG function 176

batAppend constant 89 batAppendUpdate constant 89 batch move operations 8, 75, 89-92 error handling 92 BatchMove method 75 batCopy constant 89 batDelete constant 89 batUpdate constant 89 BDE (Borland Database Engine) 2, 16-18, 92 retrieving information 57 BDE Configuration Utility 5, 171-174 starting 171 BDE Configuration Utility

Window 171 BeforeCancel event 68 BeforeClose event 63, 68 BeforeDelete event 68 BeforeEdit event 68 BeforeInsert event 68 BeforeOpen event 68 BeforePost event 68 binary collation sequence 142 binary large objects See BLOBs bitmaps 99, 108, 110 BLOB data 107

type compatibility 181 BLOBs 99, 108 BLROM800.LD 142 BOF property 61 bookmarks 66-67 Boolean properties 84 Boolean types 86 Borland Database Engine See DBE

Borland SQL Links 142, 170 borrowing table structures 155 Browse mode (datasets) 58 BRPARTS.DFM 22 Btrieve databases 132 buffers 60 clearing 107 flushing 67 building applications 19 building databases 12-16, 147 building forms 19-30 multi-table 24-30 single-table 21-24 buttons 78

See also specific type adding 99, 100 assigning values to 114

associating strings with 114 navigator 106-107

enabling/disabling 107

CalcFields mode (datasets) 58, 69

calculated fields 9, 37-39, 58 assigning values 68-69, 82-83 defining 81, 82, 83 ordering 179 updating 38 Calculated property 33, 83 Cancel method 64 Cancel navigator button 107 canceling current operation 64,

101, 107 canceling method calls 68 CancelRange method 51, 73 CanModify property 63, 75, 120 Caption property check boxes 113 case conversions 177 sensitivity 75 centering data 83 ChangedTableName property 92 changing

See also editing aliases 173 component names 23 data 63-66, 100, 101

abandoning changes 64,

101, 107 committing changes 135,

136, 137 edit boxes and 36 rolling back changes 136 single-table queries 48 datasets 78 events 82, 83, 85 property values 82, 83-84 table structures 159-161 tables 181

values See updating values character sets 89 character strings See string lists;

strings check boxes 100, 113 checking for null values 73 child tables 157 Clear method 118 clearing data buffers 107

client platforms 16 client/server applications 14, 118, 127-145 deploying 142-145 developing 127-129 handling security 132-133 transaction control 135-138 client-based SQL 175 Clipboard 108 Close method datasets 60 queries 118, 122 code 23, 87

changing data 36 optimizing 61 collation sequence 142 colon (:) in SQL statements 117, 176

column headings See field names columns

See also field names; fields combo boxes and multiple 111 outlining 104 combo boxes 99, 109-112 assigning values 109 multiple columns 111 sorting items 110 user input and 44-46 Commit method 136 COMMIT statements 135 commiting changes 135, 136, 137 communication protocols 128, 131

comparison operators 177 Component palette 6 components 2

data-aware 10, 87, 100

disabling/enabling 67 database 6, 8, 11, 55-56, 133 dataset 100 field 30-32 referencing 34 renaming 23 composite keys 153 concatenation operator 177 configuration files 171 configuration options 173 configuring drivers 131 confirming deletions 68, 104 Connect method 89 CONNECT.EXE 143 CONNECT.HLP 143 Connected property 134

connections (server) 5, 56 inactive 56

remote databases 8, 130-133 Connected property and 134 connection parameters 131-132 login parameters 133 controls

See also components data 99-114 read-only 101, 108 graphics 109 conversions batch move operations and 91 case 177

numbers to strings 35 strings to date/time 173 strings to numbers 36, 173 Copy command (Database

  1. 166 Copy dialog box (Database
  2. 166 copying data 75, 166 table structures 8, 75 text 108 CopyToClipboard method 108 COREWIN.DLL 142 COUNT function 177 counting function 177 CREATE INDEX keyword 182 Create Table dialog box (Database Desktop) 151-152 SQL tables 155 CREATE TABLE keyword 180 creating forms 19-30

multi-table 24-30, 93-95 single-table 21-24 indexes 182 new tables 89, 151, 155 Paradox tables 151, 158 SQL tables 155 csDropDown constant 110 csDropDownList constant 110 csOwnerDrawFixed constant 110 csOwnerDrawVariable constant 110 csSimple constant 110 Currency property 83 current date and time 46 current field 4, 165 current operation, canceling 101, 107

current record 4, 60, 104, 165 indicator 104 setting 106 current values 34, 102 cursors 60

moving 60-62, 72, 78

flickering screens and 67 CUSTOMER.DB 24, 183 customizing tables 162-164 CUSTORD.DFM 24, 31 cutting graphics 108 cutting text 108 CutToClipboard method 108

data accessing 79, 89, 100, 115, 116 at run time 87-88 field values 30, 32 optimizing access 119 remote servers 127, 141 adding 100-101, 154 automatically 158 predefined values 109 to grids 103 automatically translating 12 changing 63-66, 100, 101 abandoning changes 64,

101, 107 committing changes 135,

136, 137 edit boxes and 36 rolling back changes 136 single-table queries 48 confirming deletions 68, 104 copying 75, 166 defined 5

deleting See deleting displaying 9, 83, 161-164 at run time 87 current values 34, 102 in grids 83, 103, 105 multiple views 95-97 display-only 82, 84, 102, 107

truncated 102 editing 63-64, 83, 99, 102 canceling current operation 64, 101, 107 Database Desktop and 164-165 in grids 104 restrictions 164 filtering 50-51 formatting 39-42, 83, 85

at run time 40-42 invalid, restricting 43 porting 127-129

retrieving 8, 72-74

from multiple tables 178, 179

specific values 179 specifying conditions 178 searching for 42-43, 70-72 in unkeyed fields 47 nearest match 71, 72 sorting 74, 152, 166, 173 typing to replace 164 updating 63, 65-66, 101, 107 batch move operations 89 calculated fields 38 handing events 78 multiuser applications 65 read-only results 120 Refresh method and 67 validating 43-47 Data Access page (Component palette) 7-10 data buffers 60 clearing 107 flushing 67 data controls 99-114 inactive 51, 77 linking to datasets 67, 100, 101

Data Controls page (Component palette) 10-11, 99-100 data definition 13 Data Definition Language 180-182 data entry forms 102, 158, 183 data grids 99, 103-106 adding 103 displaying data 83 editing data 104 inserting records 104 linking to datasets 103 options 103-104 Data Manipulation Language

(DML) 176-179 data masks 84 data sources 2, 77-78 accessing 5, 99

networks and 5 adding 100 changing datasets 78 handling events 78 lists 111 supported 6 data templates 83, 84, 154 data types See types data-aware components 10, 87, 100

disabling/enabling 67

database components 6, 8, 11,

55-56, 133 Database Desktop 147-170 adding tables 149-161 copying data 166 defining fields 152 deleting records 165 editing data 164-165 executing SQL

statements 167-169 inserting records 165 managing files 148-149 opening tables 161 overview 12 password protection 159 saving SQL statements 169 sorting data 152, 166 specifying field types 152 starting 147 viewing data 161-164 Database Desktop window 148 database engines 2, 16, 115, 129 Database Form Expert 21

building multi-table forms 24 Fields Editor vs. 32 opening tables at run time 23 renaming components 23 running forms 21 starting 21 Database Form Expert command (Help) 21 Database Management System

(DBMS) 1 database navigator 99, 106-107 buttons 106-107

enabling/disabling 107 Database Properties Editor 134 database servers 5, 6, 127 aliases and 149 connecting to See connections developing applications See client/server applications database tools 1 DatabaseLogin event 133 DatabaseName property 29, 69, 116, 135 heterogenous queries 124 stored procedures 138 databases 4-6, 89 accessing data 100 architecture 6-12 building 12-16, 147 defined 4 overview 2-4 printing reports 8, 52-53 relational 150

retrieving information 57 sample 183-186 Databases property 56 DataField property 45, 100 check boxes 113 combo boxes 110

dataset components 100 DataSet property 23, 77 datasets 57-69, 113 changing 78 closing 59 current state 59 data sources and 77 defining 32 handling events 68-69 linking to data controls 67, 100, 101 linking to data grids 103 modes 58-59 moving through 60-62 opening 59

rights and privileges 75 DataSource property 100, 123 date functions 177 Date Manager page (BDE

Configuration Utility) 173 dates 40, 85, 173

conversion functions 86 getting current 46 returning 177 DAY constant 177 .DB files 6, 70 DB2 databases 132 dBASE tables 5, 6, 70, 175 batch move operations and 90 deleting 182 indexes 74, 153, 182 memo fields 108 naming 175 retrieving data 73 searching for data 70, 72 setting ranges 50 specifying directories 69, 149 type compatibility 180-181 DBD.EXE 147 DBDEMOS alias 20 .DBF files 6, 70 DBHandle function 93 DBIPROCS.PAS 93 DBITYPES.PAS 93 DBLocale function 93 DBMS 1

DBNMP3.DLL 143 DDL See Data Definition

Language default settings 85, 173

default values 109, 154 DefaultDrawing property 105 Define Field dialog box 38 Define Index dialog box

(Database Desktop) 155, 156 Define Parameters dialog box 49 Delete buttons 23 Delete command (Database

  1. 167 Delete dialog box (Database
  2. 167 DELETE keyword 179 Delete method 64 Delete navigator button 107 DeleteTable method 75 deleting aliases 174

characters from strings 177

fields 81, 181

graphics 108

indexes 182

queries 166

records 64, 75, 104, 165

batch move operations 89 tables 75, 166, 182 text 108 DEPLOY.TXT 142 deploying applications 16-18

remote servers 142-145 designing forms 100 desktop databases 12

upsizing 130, 140-142 destination tables 89-92 detail tables 24, 76-77, 93-95 developing applications 12-16 client/server 127-129 fundamentals 13 dgAlwaysShowEditor constant 104 dgAlwaysShowSelection constant 104 dgColLines constant 104 dgColumnResize constant 104 dgConfirmDelete constant 104 dgEditing constant 104 dgIndicator constant 104 dgRowLines constant 104 dgRowSelect constant 104 dgTabs constant 104 dgTitles constant 104 .DIB files 108 directories private (:PRIV:) 149 specifying paths 57, 69

aliases and 149 working (:WORK:) 149

DisableControls method 50, 51,

61, 67 disabling data-aware components 67 disabling navigator buttons 107 display attributes 30, 83-84 DisplayFormat property 33, 39,

41, 83, 103 displaying data 9, 83, 161-164 at run time 87 current values 34, 102 in grids 83, 103, 105 multiple views 95-97 displaying large images 109 displaying property values 32, 103

DisplayLabel property 33, 83 display-only data 82, 84, 102, 107

truncated 102 DisplayText property 40 DisplayWidth property 33, 83 distributing applications 16-18 distribution rights 16 dmAutomatic constant 105 DML statements See Data Manipulation Language dmManual constant 105 domains 138 double quote ("), naming conventions 175, 176 DragMode property 105 drawing routines 105 Driver Manager page (BDE Configuration Utility) 173 DriverName property 135 drivers configuring 131 language 142, 143 ODBC 132, 138 retrieving information 57 DROP INDEX keyword 182 DROP operations 181 DROP TABLE keyword 182 DropConnections method 57 drop-down lists See combo boxes; lists boxes DropDownCount constant 110 dropping See deleting dsBrowse constant 59 dsCalcFields constant 59 dsEdit constant 59 dsInactive constant 59 dsInsert constant 59 dsSetKey constant 59 DSQL 121-124 defined 117

dynamic queries 48 dynamic SQL statements 121-124 defined 117

edit boxes 99, 102 See also combo boxes changing data 36 Edit Data command (Database

Desktop) 164 Edit method 63 Edit mode 107

Database Desktop 164, 165 datasets 58, 63, 77 CanModify property and 63 Edit navigator button 107 EditFormat property 83, 103 editing

See also changing data 63-64, 83, 99, 102 canceling current operation 64, 101, 107 Database Desktop and 164-165 in grids 104 restrictions 164 graphics 108 text 108 editing methods 108 EditMask property 33, 41, 83, 84 editors

Database Properties 134 Fields See Fields Editor Input Mask 84 Parameters 121, 122, 138 SQL 167-169 String List 109, 117 EditRangeEnd method 73 EditRangeStart method 73 EDORDERS.DFM 38 EMPLOYEE.DB 183 Empty command (Database

Desktop) 165 EmptyTable method 75 EnableControls method 50, 51, 61, 67

Enabled property 77, 101 entering SQL statements 117-119, 120 at run time 118, 122 EOF property 61 errors 92 Esc key 101

events 83, 101

changing 82, 83, 85 data grids 105-106 data sources 78 datasets 68-69 Events tab (Object Inspector window) 85 example applications See sample applications exceptions 51, 101 exclusive locks 75 Exclusive property 75 ExecProc method 139 ExecSQL method 119 Execute method 92 executing SQL statements 116, 117, 119, 169 at run time 118 experts See Database Form

Expert expressions aggregate functions and 177 EXTRACT function 177

fetching data See retrieving data field components 30-32 Field Link Designer 76-77 Field Link Designer dialog box 76 field names 83

ANSI-standards 176 assigning as values 122 disabling 104 resizing columns 163 field properties 32-34

changing 83 field types See types field values See values field view 165

FieldByName method 87-88 FieldName property 33, 83 fields 4, 30-43

adding 31, 79, 181 Fields Editor 81 calculated 9, 37-39, 58 assigning values 68-69,

82-83 defining 81, 82, 83 ordering 179 updating 38 current 4, 165 default settings 85 defining 152 deleting 81, 181 display-only 82, 84

entering data 154

automatically 158 handling events 85 key 83, 152

partial keys and 73 specifying 50 moving 163

at run time 105 numeric 83, 154, 176 displaying values 83 in edit boxes 35, 36 placing scroll locks 162 reordering 31, 103, 163 at run time 105 Fields Editor 80 resizing 104, 163 selecting 104, 165

Tab key and 101, 104 setting display attributes 83-84

updating See updating data Fields Editor 30-32, 80-83, 100 activating 9 adding fields 31, 81 changing property values 82 closing 31

Database Form Expert vs. 32 defining calculated fields 37 deleting fields 81 editing events 82 overview 10 reordering fields 80 setting property values 32 starting 80 Fields Editor window 80 Fields property 87 file servers 5, 127 aliases and 149 connecting to See connections developing applications See client/server applications files

See also applications;

databases configuration 171 distributing 16, 17 opening 148 script 118

temporary 57, 92, 149, 170 text 6, 70 filters 50-51

finding field values 42, 70-72

nearest match 71, 72 FindKey method 72 FindNearest method 72 First method 60 First navigator button 106

flickering screens 67 floating-point numbers 86 flushing data buffers 67 focus, setting 85 FocusControl method 85 Form Expert See Database Form Expert

FormatDateTime routine 85 FormatFloat routine 85 FormatInteger routine 85 formatting data 39-42, 83, 85

at run time 40-42 formatting text 40 forms 19-30

data entry 102, 158, 183 designing 100 multi-table 24-30, 76

creating 93-95 order entry 93, 112 printing 53 running 21 single-table 21-24 FreeBookmark method 67 freeing memory 67 functions

See also methods; routines aggregate 141, 176-177, 179 date 177

mathematical 141 search 70

string manipulation 177

.GDB files 6 GDS.DLL 143 GetAliasNames method 57 GetAliasParams method 57 GetBookmark method 67 GetDatabaseNames method 57 GetDriverNames method 57 GetDriverParams method 57 GetIndexNames method 74 GetTableNames method 57 GoToBookmark method 67 GoToCurrent method 76 GoToKey method 70 GoToNearest method 70, 71, 72 graphics 108

displaying large 109 editing 108 grids See data grids

Handle function 93 handles 93

headings See field names Help Hints 107 heterogeneous joins 179 heterogenous queries 124 hierarchy 7, 55 Hints property 107 horizontal dividing lines, enabling/disabling 104 HOUR constant 177

icons

Data Access page 7 Data Controls page 10 IDAPI.CFG 171 IDAPI.CNF 17 IDAPI01.DLL 17 IDAPICFG.EXE 17, 171 IDAPICFG.HLP 17 IDASCI01.DLL 17 IDBAT01.DLL 17 IDDBAS01.DLL 17 IDODBC01.DLL 17 IDPDX01.DLL 17 IDQRY01.DLL 17 IDR10009.DLL 17 ILD01.DLL 17 image boxes 99 images 108

scrolling through 109 inactive data controls 51, 77 inactive database connections 56 Inactive mode (datasets) 58 Index property 33, 83 indexes 74-75, 152-154, 180 See also key fields creating 182 deleting 182 naming 156 primary 74

secondary 71, 72, 74, 154, 182 SQL tables 153-154, 155-157, 160

IndexFieldCount property 74 IndexFieldNames property 50, 71

IndexFields property 74 IndexName property 71, 74 Informix servers 143 Informix tables 6, 90, 91

transactions 138 inheritance 55 InitialValues property 88 inner joins 178 input focus 85

Input Mask Editor 84 Input Mask Editor window 84 INSERT keyword 179 Insert method 64 Insert mode (datasets) 58, 64, 106

CanModify property and 63 Insert navigator button 106 InsertRecord method 65 instantiating TField 103 integers 86

IntegralHeight property 110 integrity violations 92 interactive SQL 129 INTERBAS.MSG 143 InterBase Server (LIBS) 127,

129-130 InterBase tables 5, 6, 130 accessing 143 batch move operations and 91 transactions 138 InterBase Workgroup Server for

Windows NT 144 International settings 85 invalid data, restricting 43 invoices 44, 113 IS NULL operator 177 ISAM.IEM 143 isolation levels

(transactions) 137-138 ISQL 129

ItemHeight property combo boxes 110 list boxes 111 Items property 45 combo boxes 109 list boxes 110, 113 radio buttons 114 ITEMS.DB 183 iteration 61, 62, 87

joins 178

heterogeneous 179

KeepConnections property 56, 134

key fields 83, 152 See also indexes partial keys and 73 specifying 50 key violations 92

keyboard events 101, 106 KeyExclusive property 72

ranges and 74 KeyFieldCount method 71 KeyViolTableName property 92 keywords

See also SQL keywords naming conventions and 175, 176

labels 101-102 language drivers 142, 143 large images 109 Last method 60 Last navigator button 106 LDLLSQLW.DLL 143 left justifying data 83 LIBS See InterBase Server linking data controls to datasets 67, 100, 101 linking data grids to datasets 103 linking queries 123 linking tables 94, 150

one-many-many links 27 one-to-many links 24, 76 LINKQRY sample application 123 list boxes 99, 100, 109, 110

See also combo boxes lists 111

scrolling through 110, 112 sorting items 110 string See string lists user input and 44-45 live results 48, 120

See also SQL queries LoadFromFile method 118 local buffers 60 clearing 107 flushing 67 Local Interbase Server (LIBS) See

InterBase Server Locale function 93 locating field values 42, 70-72

nearest match 71, 72 locking tables 75 loColLines constant 111 logical operators 177 Login dialog box 132 login parameters 133 LoginPrompt property 133 lookup lists 111 lookup tables 45-46, 158 LookupDisplay property 45, 111

LookupField property 45, 111 LookupSource property 45, 111 loops 61, 62

loRowLines constant 111 loTitles constant 111 LOWER function 177 lowercase conversions 177

M3OPEN.DLL 144 M3OPEN.EXE 144 maintaining database connections 134 Mappings property 91 masks 84

MAST sample database 183-186 MASTAPP sample application 20, 183 master tables 24, 76-77, 93-95 MasterFields property 76 MasterSource property 76, 94 mathematical functions 141 MAX function 177 maximum values 51, 83, 154, 177 MaxLength property 108 MaxValue property 83 MBW.EXE 144 memo boxes 99 memo fields 108 memory, freeing 67 memos 107-108

scrolling through 108 menu items 78 messages 71 metadata 138, 141 methods

See also functions; procedures bookmarks 67 canceling calls 68 editing 108 MFTP.EXE 144 MHPARPA.DLL 144 Microsoft Access databases 132 Microsoft Named Pipes protocol 144 Microsoft SQL servers 6, 142

transactions 138 MIN function 176 minimum values 51, 83, 154, 176 minus (-) sign in property lists 104 MINUTE constant 177 MinValue property 84 MNETONE.EXE 144 MNOVLWP.DLL 144

Mode property 89 modifying See changing monetary values 83, 85 MONTH constant 177 mouse events 101, 105 MoveBy method 62 MoveCount property 92 moving cursors 60-62, 72, 78 fields 163

at run time 105 text 108 moving among fields 104, 165

Tab key and 101, 104 moving through images 109 moving through lists 110, 112 moving through memos 108 moving through tables 60-62, 104

Database Desktop and 162, 165

MPATHWAY.DLL 144 MPCNFS.EXE 144 MPCNFS2.EXE 144 MPCNFS4.DLL 144 MSOCKLIB.DLL 144 multi-line text 107 multiple query statements 118 multi-table forms 24-30, 76 creating 93-95 Paradox tables 157, 158 multi-table queries 124, 178 heterogeneous joins 179 multiuser applications 5, 135, 147

See also client/server applications; networks updating data 65 MVWASYNC.EXE 144 MWINTCP.EXE 144

Name property 32, 33, 84 naming directories 149 fields 176 indexes 156 tables 175 navigator See database navigator nbDelete constant 23 nbNext constant 23 NetFileDir property 57 networks 127, 144, 149 accessing 5

temporary files and 149

Next method 60 Next navigator button 106 Next Record buttons 23 NEXTORD.DB 183 nil values 65 NOT operator 177 NOT SHARED setting 137 Novell SPX/IPX interface 131, 144

Now function 46 null values 65, 121 checking for 73 stored procedures 139 Number Manager page (BDE

Configuration Utility) 173 numbers conversion functions 86 converting strings to 36, 173 to strings 35 numeric fields 83, 154, 176 displaying values 83 in edit boxes 35, 36 NWCALLS.DLL 144 NWIPXSPX.DLL 144

object hierarchy 7, 55 Object Inspector displaying property values 32, 33, 103 ODBC data sources 6 ODBC driver 132, 138 ODBC.NEW 17 ODBCINST.NEW 17 OEM conversion 93 OnCalcFields event 38, 58,

68-69, 82 OnColEnter event 105 OnColExit event 105 OnDataChange event 78 OnDblClick event 105 OnDragDrop event 105 OnDragOver event 105 OnDrawDataCell event 105, 106 one-many-many links 27 OnEndDrag event 106 OnEnter event 106 one-to-many links 24, 76 OnExit event 106 OnGetText event 85 OnKeyDown event 106 OnKeyPress event 106 OnKeyUp event 106 OnLogin event 133

OnNewRecord event 68 OnSetText event 85 OnStateChange event 59, 78 OnUpdateData event 78 OnValidate event 43, 46 Open command (Database

  1. 148, 161 Open method datasets 59 queries 119 Open Table dialog box (Database
  2. 161 opening datasets 59 files 148 queries 168 tables 161

at run time 23 operators (local SQL

statements) 177 optimizing applications 128 optimizing code 61 optimizing queries 121 Options property combo boxes 111 data grids 103 OR operator 177 ORA6WIN.DLL 142 ORA7WIN.DLL 142 Oracle servers 142 Oracle tables 6, 90, 91 stored procedures 140 transactions 138 ORAWE850.LD 142 order entry forms 93, 112 ORDERS.DB 24, 183 OS.IEM 143 outer joins 178

outlining records and fields 104 output 53

Overload property 140 overloading stored procedures 140

Paradox tables 5, 6, 70, 175 batch move operations and 90 creating 151, 158 deleting 182 indexes 74, 152, 154, 182 key fields 152 memo fields 108 multi-table forms 157

lookup tables and 158 naming 175

password protection 159 referential integrity 157-158 restructuring 159 retrieving data 73 searching for data 70, 72 setting ranges 50 specifying directories 69, 149 type compatibility 180-181 validity checks 154 ParamByName method 122 ParamByName property 138 parameterized statements 117 parameters connection 131-132 login 133

retrieving information 57 SQL statements 117, 121, 176 arrays and 122 assigning names 122 null values 121 setting at run time 121 stored procedures 138-139 Parameters Editor 121, 122, 138 Params property 50, 122, 131 parent tables 157 parsing query statements 121 partial keys 73 PARTS.DB 183

passthrough SQL 120, 136, 167 transactions 136, 137 isolation levels 137 passwords 159 PasteFromClipboard method 108 pasting graphics 108 pasting text 108 picture strings 83, 84, 154 placing bookmarks 66-67 placing locks 75 platforms 128

plus (+) sign in property lists 103 pointers 60 porting data 127-129 Post method 63, 64 Edit method and 64 OnCalcFields event and 69 Post navigator button 107 posting records 63, 64, 102 automatically 107 data grids 105 predefined aliases 20 predefined values 109 Prepare method 116, 121-122, 139

Preview property 52

primary indexes 74, 152, 182 Print method 53 printing forms 53 printing reports 8, 52-53 Prior method 60 Prior navigator button 106 private directories (:PRIV:) 149 Private Directory command

(Database Desktop) 149 PrivateDir property 57 privileges 75

ProblemTableName property 92 procedures

See also methods; routines stored 8, 57, 138-140 executing 139 overloading 140 project files 16 projects See applications properties 6, 83 accessing 40, 86 Boolean 84 changing 82, 83-84 field 32-34, 83 values, displaying 32, 103 Properties menu (Database

Desktop) 163 Properties tab (Object Inspector window) 83 protocol (communications) 128, 131

QBE (defined) 169 queries 9, 47-50, 169-170 See also SQL queries deleting 166 dynamic 48 multi-table 124, 178

heterogeneous joins 179 opening 168 renaming 166 single-table 48 specifying table names 9 static 47 query by example (defined) 169 Query component 115, 117 question mark (?) in SQL

statements 176 quotation mark ("), naming conventions 175, 176

radio buttons 100, 114 ranges 50-51, 73 canceling 51 maximum values 51 minimum values 51 RDS.IEM 143 read-only controls 101, 108

graphics 109 read-only privileges 75 ReadOnly property 33, 75, 84

CanModify property and 63 read-only results 48, 120

See also SQL queries ReCalcReport method 89 records adding 64, 65, 106, 165 batch move operations 89 data grids and 104 current 4, 60, 104, 165 indicator, setting 104 setting 106 data grids and 103, 105 deleting 64, 75, 104, 165

batch move operations 89 moving through 60-62 ordering 152, 179 outlining 104 posting 63, 64, 102, 105

automatically 107 resizing 163 selecting 104, 106, 165 specific sets 47, 50 updating See updating data Redistributable BDE 16 redrawing screens 105, 108, 109 referencing components 34 referential integrity 157-158 Referential Integrity dialog box

(Database Desktop) 158 Refresh method 67 Refresh navigator button 107 relational databases 150

See also databases releasing memory 67 remote servers 5, 127 aliases and 149 connecting to 8, 130-133, 134 deploying applications

142-145 developing applications 12, 15

REMOTE.DLL 143 removing See deleting Rename command (Database Desktop) 166

Rename dialog box (Database

Desktop) 166 renaming components 23 queries 166

tables 166 reordering fields 31, 103, 163 at run time 105 Fields Editor 80 repeat. . . until loops 62 ReportDir property 52, 88 ReportName property 52, 88 reports 8, 88-89

printing 52-53 ReportSmith 8, 52, 88

deploying applications 145 printing reports 52-53 ReportSmith Runtime 145 RequestLive property 48, 120 Required property 43 required values 154 reserved words

See also SQL keywords naming conventions and 175, 176 resizing fields 104, 163 resizing records 163 restoring previous values 64, 101, 107

Restructure command (Database

Desktop) 159 Restructure Table dialog box

(Database Desktop) 159, 160 restructuring tables 159-161 retrieving data 8, 72-74

from multiple tables 178, 179 specific values 179 specifying conditions 178 right justifying data 83 Rollback method 136 ROLLBACK statements 135 rolling back changes 136 rounding 86 routines

See also functions; methods;

procedures drawing 105 rows See records RS_RUN directory 52 Run method 52, 88 Run SQL command (Database

Desktop) 169 Run Visual Query Builder command 118 RunMacro method 88

running SQL statements 116, 117, 119, 169 at run time 118

sample applications LINKQRY 123 MASTAPP 20, 183 TWOFORMS 95 sample database 183-186 saving aliases 172, 173 SQL statements 118, 169 screens flickering 67 redrawing 105, 108, 109 script files 118 scroll bars 108 scroll locks 162 ScrollBars property 108 scrolling through images 109 scrolling through lists 110, 112 scrolling through text 108 search conditions (SQL

  1. 178 search functions 70 search mode 70 searching for data 42-43, 70-72 in unkeyed fields 47 nearest match 71, 72 SECOND constant 177 secondary indexes 154 deleting 182 searching on 71, 72, 74 security 132-133 SECURITY.IEM 143 Select Alias command (Database
  2. 168 Select Alias dialog box

(Database Desktop) 168 SELECT keyword 178 SELECT statements 118, 120,

178-179 selecting

See also searching for data fields 104, 165

Tab key and 101, 104 records 104, 106, 165 specific sets 47, 50 selection bars (grids) 104 servers 5, 6, 127 aliases and 149 connecting to See connections developing applications See client/server applications

Session component 56 set functions 176-177, 179 SetFields method 65 SetKey method 70, 71 SetKey mode (datasets) 58, 70 SetRange method 73 SetRangeEnd method 51, 73 SetRangeStart method 51, 73 setting locks 75 setting property values 32 SetVariable method 89 SHARED AUTOCOMMIT

setting 137 SHARED NOAUTOCOMMIT

setting 137 Show SQL command (Database

  1. 168 ShowHint property 107 ShowMessage function 71 single quote ('), naming conventions 175, 176 single-table forms 21-24 single-table queries 48 Size property 84 Sort command (Database
  2. 166 sort order 74

Sort Table dialog box (Database

Desktop) 166 Sorted constant 110 sorting data 74, 152, 166

configuration options 173 sorting items in lists 110 source tables 89-92 specifying aliases 134, 172 spreadsheets 99 SQL database servers 6 SQL Editor (Database Desktop) 167-169 saving statements 169 starting 168 SQL Editor window (Database

Desktop) 167 SQL keywords

ALTER TABLE 181 COMMIT 135 CREATE INDEX 182 CREATE TABLE 180 DELETE 179 DROP INDEX 182 DROP TABLE 182 INSERT 179

naming conventions 175, 176 ROLLBACK 135 SELECT 178 UPDATE 179

SQL Links 142 SQL property 116, 117, 118 SQL queries 9, 115-125 adding new fields 181 creating indexes 182 deleting fields 181 entering statements 117-119, 120

at run time 118, 122 heterogenous 124 linking 123

live vs. read-only results 120 local (client-based) 175-182 data definition 180-182 data manipulation

176-179 naming conventions

175-176 operators 177 multi-table 124, 178

heterogeneous joins 179 optimizing 121 preparing 121-122 retrieving specific values 179 running statements 116, 117, 119, 167-169 at run time 118 saving statements 118, 169 specifying search conditions 178 specifying table names 9 tutorial 47-50 type compatibility 180-181 updating 50 SQL script files 118 SQL Statement command (Database Desktop) 168 SQL tables creating 155 indexes 74, 153-154, 155-157, 160 naming 156 naming 175 restructuring 160 retrieving data 73 searching for data 70, 72 setting ranges 50 sorting data 166 specifying directories 69 updating data 65 validity checks 154 SQL.IEM 143 SQL_IB.CNF 143 SQL_INF.CNF 143 SQL_ORA.CNF 142 SQL_SS.CNF 142 .SQL files 169

SQL13WIN.DLL 142 SQLD_IB.DLL 143 SQLD_IB.HLP 143 SQLD_INF.DLL 143 SQLD_INF.HLP 143 SQLD_ORA.DLL 142 SQLD_ORA.HLP 142 SQLD_SS.DLL 142 SQLD_SS.HLP 142 SQLPASSTHRUMODE

setting 136, 136-137 SQLWIN.DLL 142 starting applications 173 BDE Configuration

Utility 171 Database Form Expert 21 Fields Editor 80 Input Mask Editor 84 Parameters Editor 138 StartTrans method 136 StartTransaction method 136 State property 59 static queries 47 static SQL statement

(defined) 117 stored procedures 8, 57, 138-140 executing 139 overloading 140 parameters 138-139 StoredProcName property 138 String List Editor 109

entering SQL statements 117 string lists 117

associating with buttons 114 sorting items 110 string manipulation functions 177 strings 73

concatenating 177 conversion functions 86 converting case 177 to date/time 173 to numbers 36, 173 picture 83, 84, 154 removing repeating characters 177 returning parts of 177 Structured Query Language See

SQL Style property combo boxes 110 subqueries 178, 179 SUBSTRING function 177

substrings, returning 177 Subtract command (Database

Desktop) 165 SUM function 176 sums 176

supported data sources 6 Sybase servers 121, 142 Sybase tables 6, 90, 91, 156

transactions 138 SYDC437.LD 143 SYDC850.LD 143 System Manager page (BDE Configuration Utility) 173

Tab key 101

tabbing through fields 101, 104 Table Type dialog box (Database

  1. 151 Table window (Database
  2. 161 TableName property 22, 69 tables 4, 180 adding 8

Database Desktop 149-161 Answer 170 changing 181 child 157

configuration options 173 creating new 89, 151, 155 Paradox 151, 158 SQL 155 customizing views 162-164 deleting 75, 166, 182 destination 89-92 detail 24, 76-77, 93-95 linking 94, 150

one-many-many links 27 one-to-many links 24, 76 locking 75 locking columns 162 lookup 45-46, 158 master 24, 76-77, 93-95 moving through 60-62, 104 Database Desktop and 162, 165 multiple views 95-97, 180 naming, ANSI standards 175 opening 161

at run time 23 parent 157

placing bookmarks 66-67 renaming 166 retrieving information 57 source 89-92

specifying for queries 9 structure borrowing 155 changing 159-161 copying 8, 75 types 69-70 TableType property 69 taCenter constant 33 Tag property 84 taRightJustify constant 33 TBatchMove component 8,

89-92 TBCDField type 86 TBlobField type 86 TBookmark type 67 TBooleanField type 86 TBytesField type 86 TCP/IP interface 16, 131, 144 TCurrencyField type 85, 86 TDatabase component 8,

133-135 TDataSet class 8 TDataSource component 6, 8, 10, 77-78, 100 multiple views and 95 TDateField type 85, 86 TDateTimeField type 85, 86 TDBCheckBox component 100, 113

TDBComboBox component 99,

109-110 TDBEdit component 99, 102 TDBGrid component 99, 103-106 adding 101, 103 TDBImage component 99, 108 TDBListBox component 99, 109, 110

TDBLookupCombo component 100, 109, 111-112 TDBLookupList component 100,

109, 112 TDBMemo component 99,

107-108 TDBNavigator component 99, 106-107 adding 101 enabling/disabling buttons 107 TDBRadioGroup component 100, 114 TDBText component 99, 101-102 telephone numbers 40, 41 templates data entry 83, 84, 154 temporary files 57, 92, 149, 170

.TXT files 6 text 108

See also data adding 107 aligning 108 editing 108 formatting 40 scrolling through 108 wordwrapping 108 text files 6, 70

text strings See string lists; strings TField component 30, 33, 40, 79-87, 100 disabling 103 instantiating 103 overview 8 referencing 34 TFloatField type 84, 85, 86 TGraphicField type 86 tiDirtyRead constant 137 time 85, 173

conversion functions 86 returning 177 Time Manager page (BDE

Configuration Utility) 173 timer events 101 timestamps 46

TIMEZONE_HOUR clause 177 TIMEZONE_MINUTE

clause 177 TIntegerField type 85, 86 tiReadCommitted constant 137 tiRepeatableRead constant 137 TMemoField type 86 tool bars 22

Database Desktop windows 148, 161, 168 totaling numeric values 176 TQuery component 57, 100, 115-117 overview 6, 8, 9-10 TDataSource and 10 TTable vs. 116, 120 transactions 100, 128, 135-138 implicit vs. explicit control 136 isolation levels 137-138 TransIsolation property 137 translating data 12 Transliterate property 89 TReport component 8, 52, 88-89 TRIM function 177 truncated data 102 try...except blocks 119 try...finally blocks 51, 61, 67 TSession component 56-57, 134

TSmallIntField type 85, 86 TStoredProc component 8, 57, 138

TStringField type 84, 86 TStrings type 117 TTable component 6, 8-9, 57, 69-77, 100 multiple views and 96 TDataSource and 10 TQuery vs. 116, 120 TTimeField type 85, 86 TUTILITY.DLL 17 tutorial 19-53 TVarBytesField type 86 TWOFORMS.DPR 95 TWordField type 85, 86 .TXT files 70 types 31

batch move operations and 90-91 converting 86 editing 164 specifying 152 SQL-compatible 180-181 typing to replace entries 164

UniDirectional property 119 unique indexes 153, 156 UnPrepare method 122 UPDATE keyword 179 UPDATE statements 120 UpdateMode property 65-66 updating data 63, 65-66, 101, 107

batch move operations 89 calculated fields 38 handling events 78 multiuser applications 65 read-only results 120 Refresh method and 67 updating queries 50 UPPER function 177 uppercase conversions 177 upsizing desktop databases 130,

140-142 Utilities menu (Database Desktop) 165

validity checks 43-47, 154

types 43 Value property 86 ValueChecked property 113

values accessing 30, 32 assigning 37, 154 at run time 87, 88 calculated fields 68-69,

82-83 default 109, 154 names as 122 required 154 run-time 35 to buttons 114 to combo boxes 109 averaging 176 changing edit boxes and 36 changing See updating data converting numbers to strings 35 string to date/time 173 string to numbers 36, 173 counting 177 currency 83, 85 display formats 85 displaying current 34, 102 finding 42, 70-72

nearest match 71, 72 minimum/maximum 83, 154 aggregate functions

176-177 specifying 51 nil 65 null 65, 121

checking for 73 stored procedures 139 predefined 109 property accessing 40, 86 changing 82, 83-84 displaying 32, 103 setting 32 restoring previous 64, 101, 107

retrieving specific 179 rounding 86 totaling 176

typing to replace entries 164 updating See updating data Values property 114 ValueUnchecked property 113 variables local SQL statements 176, 180 VBX controls 16 VENDOR.DB 183 vertical dividing lines, enabling/

disabling 104 viewing See displaying views 95-97, 180 Visible property 33, 84, 103 VisibleButtons property 23, 107 Visual Basic controls 16 Visual Query Builder 10, 118-119 Visual Query Builder window 118 VSL.INI 144

W3DBLIB.DLL 143 WhereAll constant 66 WhereChanged constant 66 WhereKeyOnly constant 66 Windows for Workgroups 144 Windows ISQL 129 Winsock 1.1 compliant TCP/IP

products 144 WINSOCK.DLL 144 WordWrap property 108 wordwrapping text 108 working directories

  • WORK:) 149 Working Directory command
  • Database Desktop) 149 write privileges 75

Database Application Developer's Guide

Borland may have patents and/or pending patent applications covering subject matter in this document. The furnishing of this document does not give you any license to these patents.

Copyright © 1995 Borland International. All rights reserved. All Borland products are trademarks or registered trademarks of Borland International, Inc. Other brand and product names are trademarks or registered trademarks of their respective holders.

Printed in the U.S.A. 1E0R195

9596979899-987654321 W1

Was this article helpful?

0 0

Post a comment