10
11-6-5 Generation of Text Files ..................................................................................................... 177
11-7 Data Logging ................................................................................................................................... 177
11-7-1 Add Database Link Dialog..................................................................................................177
11-7-2 Add Field Link Dialog.......................................................................................................... 178
SECTION 12
Databases.....................................................................................181
12-1 Database Connection Editor............................................................................................................ 181
12-2 Configuring a Connection ................................................................................................................ 182
12-2-1 Add/Modify Database connection dialog box .................................................................... 182
12-2-2 Testing Connections in the Development Environment...................................................... 183
12-2-3 Database Errors ................................................................................................................. 183
12-2-4 Database Connection String dialog box ............................................................................. 183
12-2-5 Creating a Data Source Name file ..................................................................................... 185
12-2-6 Creating a Read/Write connection to an Excel file ............................................................. 186
12-2-7 Creating a Read/Write connection to CSV/Text file............................................................ 187
12-3 Configuring Recordsets ................................................................................................................... 187
12-3-1 Name.................................................................................................................................. 187
12-3-2 Recordset Type .................................................................................................................. 187
12-3-3 Source ................................................................................................................................ 188
12-3-4 Lock.................................................................................................................................... 188
12-4 Configuring Field Associations......................................................................................................... 189
12-4-1 Name.................................................................................................................................. 189
12-4-2 Point ................................................................................................................................... 189
12-4-3 Field.................................................................................................................................... 189
12-4-4 Field Property ..................................................................................................................... 189
12-5 Configuring Parameter Associations................................................................................................ 190
12-5-1 Name.................................................................................................................................. 191
12-5-2 Index................................................................................................................................... 191
12-5-3 Data Type ........................................................................................................................... 191
12-5-4 Use point to hold parameter value...................................................................................... 191
12-5-5 Point ................................................................................................................................... 191
12-5-6 Value .................................................................................................................................. 191
12-6 Configuring Schemas....................................................................................................................... 192
12-6-1 Name.................................................................................................................................. 192
12-6-2 Point ................................................................................................................................... 192
12-6-3 Type.................................................................................................................................... 192
12-6-4 Criteria................................................................................................................................ 192
12-6-5 Filter.................................................................................................................................... 192
12-6-6 Read on Connection........................................................................................................... 192
12-6-7 Preview............................................................................................................................... 192
12-6-8 Database Schema Types ................................................................................................... 193
12-7 Using Transactions .......................................................................................................................... 195
12-7-1 Nested Transactions........................................................................................................... 196
12-8 Saving Recordsets as XML.............................................................................................................. 196
12-9 Datashaping..................................................................................................................................... 197
12-10 Examples......................................................................................................................................... 198
12-10-1 Simple Relation Hierarchy example: .................................................................................. 198
To Next Page
Loading...
