Tuto WEBDEV 25

4 Summary Saving the data in a data file............................................................................................................................... 51 Creating the data file............................................................................................................................. 51 Saving data............................................................................................................................................53 Page test................................................................................................................................................54 Viewing the data typed..........................................................................................................................54 Adding input checks............................................................................................................................................ 55 Mandatory input....................................................................................................................................55 Checking the password.........................................................................................................................56 Simple search in a database............................................................................................................................... 57 Creating the page..................................................................................................................................57 Creating controls....................................................................................................................................58 Page test................................................................................................................................................61 Conclusion............................................................................................................................................................ 61 P art 2 - M y first database Lesson 2.1. Overview Overview of the project developed in this part.................................................................................................. 66 Lesson 2.2. WEBDEV and the databases Overview............................................................................................................................................................... 68 HFSQL................................................................................................................................................................... 69 The different modes for accessing the databases............................................................................................ 69 Native Connector (Native Access).........................................................................................................69 Direct ODBC access...............................................................................................................................70 OLE DB access.......................................................................................................................................70 ODBC access via OLE DB.......................................................................................................................70 Lesson 2.3. Project and analysis Overview............................................................................................................................................................... 72 Creating the project............................................................................................................................................. 72 Creating the analysis............................................................................................................................................74 Creating the description of data files................................................................................................................. 75 Creating a data file: using a preset data file.........................................................................................75 Creating a data file: creating the data file and items...........................................................................77 Importing a CSV file................................................................................................................................82 Direct import of existing data files........................................................................................................85 Creating the links................................................................................................................................................. 86 Generating the analysis....................................................................................................................................... 92