Tuto WINDEV 25

92 Part 3: My first database Overview You may have to handle data when creating an application. To store the data, you must create a "database". In WINDEV, when creating a project that is using data, an "analysis" must be created beforehand. An analysis contains the description of the data files (or tables) containing the application data. 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 WINDEV. They can be accessed from the HFSQL Control Center. WINDEV can handle most of the database formats (nearly all of them). The most common formats are: • HFSQL, the database system supplied with WINDEV. The HFSQL database is available in Classic mode or in Client/Server mode. • Oracle, SQL Server, MySQL, xBase, SQL Azure, ... • AS/400, Access, Sybase, Informix, ... • Any database accessible in SQL language in Windows. • Text (ASCII files). Several methods can be used to access data: • Native Connector (also called Native Access), • OLE DB access, • Direct ODBC access, • ODBC access via OLE DB.