Tuto WINDEV 25

Part 8: Appendices 443 Overview This lesson allows you to handle the SQL databases with WINDEV. Remark This lesson is intended to the users with a good knowledge of SQL databases. Some operations to perform on the SQL database will not be presented in details To create an application that is using an SQL database, you must: • Create the project linked to the application. This project will group all application elements (windows, codes, queries, reports, ...). • Import the description of SQL data files. Remark To follow this lesson, you must: 1. Connect to your SQL server. 2.  Import onto the SQL server the SQL script files and the image directory (found in the "\Exercises\SQLDatabase\" directory of directory containing the tutorial examples) with the available import tools (MySql, Oracle, SQL Server, ...). The image directory is used to get the images of Product data file. 3. Run the SQL script files on the SQL server. Remark: The provided SQL scripts operate on Oracle only. Your SQL database is ready for this lesson. Creating the project ▶ To create the project: 1. Start WINDEV (if not already done). 2. Display the WINDEV home page (Ctrl + <). 3.  In the home page, click the "Create a project" button and select "Windows or Linux application". The project creation wizard starts. The different steps of the wizard help you create your project. The information specified in this wizard can be modified later. Tip Tip: To create a project, you can also: 1. Click among the quick access buttons. 2.  The window for creating a new element is displayed: click "Project". 4.  The first step of the wizard allows you to select the operating system for which the project is intended. Select "Windows platform" and go to the next step of the wizard ("Next").