Tuto WEBDEV 25

68 Part 2: My first database Overview You may have to handle data when creating an application. To store the data, you must create a "database". In WEBDEV, when creating a project that is using data, an "analysis" must be created beforehand. An "analysis" contains the description of data files (or tables). The application data will be saved in the data files. When running the application, these descriptions will be used to create the database and/or the data files. The information will be stored in this database or in these data files. Remark Several tools for performing maintenance operations on the HFSQL databases are supplied with WEBDEV. They can be accessed from the HFSQL Control Center. WEBDEV supports most of the database formats (nearly all of them). The most common formats are: • HFSQL, the database system supplied in standard with WEBDEV. The HFSQL database is available in Classic mode or in Client/Server mode. • AS/400, Access, Sybase, Informix, ... • Oracle, SQL Server, MySQL, xBase, ... • Any database accessible in SQL language in Windows. • Text (ASCII files). Several methods (also called "access modes") can be used to access the data: • Native Connector (also called Native Access), • OLE DB access, • Direct ODBC access, • ODBC access via OLE DB.