PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
New WINDEV 24 feature!
  • This lesson will teach you the following concepts
  • Overview
  • Creating the project
  • Creating the analysis
  • Generating the analysis
Appendix 2. Using SQL data
This lesson will teach you the following concepts
  • Creating a project.
  • Creating an analysis.

Estimated time: 40 mn
Previous LessonTable of contentsNext Lesson
Overview
This lesson allows you to handle the SQL databases with WINDEV.

Note

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.

Note

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.
    Note: 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 wizard for project creation starts. The different wizard steps 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 wizard step is used to type the project name, its location and its description. In our case, this project will be named "sqldatabase".
    5. The different wizard steps are specified on the left of wizard. These steps can be clicked directly. Since the other steps in the "Description" are not essential, you can click "Charters" directly.. The different wizard steps are specified on the left of wizard. These steps can be clicked directly. Since the other steps in the "Description" are not strictly necessary, you can click "Guidelines" directly.
    6. This step is used to define the programming charter. Don't modify the suggested options. Go to the next step via the arrows found at the bottom. This step is used to define the code style. Don't modify the suggested options. Go to the next step via the arrows found at the bottom.
    7. This step is used to define the style book. Select "Elegant". Go to the next step via the arrows found at the bottom.
    8. Click the "Database" step. This step is used to give information regarding the database.
    9. Select "Yes, use an existing database" and go to the next step.
    10. Select "Import the description from an existing database".
    11. The wizard for analysis creation starts.
Creating the analysis
  • The wizard steps for creating the analysis are as follows:
    1. Specify the analysis name and directory. By default, the analysis name corresponds to the project name and the analysis directory is a ".ana" directory in the project directory. We will keep these default parameters. Go to the next wizard step.
    2. You now have the ability to choose the types of databases used by the project. Select OLE DB (or the SQL database use if you own the corresponding Native Connector).
      Note: Native Connectors are listed first.
      Go to the next wizard step.
    3. Select the OLE DB source corresponding to the type of your database.
      Go to the next wizard step.
    4. In the following steps, specify the parameters of your OLE DB connection (the steps are identical for a Native Access):
      • the connection name (the caption associated with the connection is optional). Go to the next step.
      • the name of database server. Go to the next step.
      • the user name and password. Go to the next step.
      • the database name if necessary. Go to the next step.
    5. Specify the mode for accessing data. You can:
      • access the data in its current format directly. Only the description of tables is imported into the analysis. No conversion is required.
      • convert the data to HFSQL Classic format.
    6. In our case, choose "Access the data in its current format directly". Go to the next step.
    7. Select the tables (files) to import.
    8. Validate and end the wizard. The tables are imported and viewed into the data model editor.
  • The analysis is as follows:
Generating the analysis
Generating the analysis consists in validating the modifications performed in the analysis (creation of data files, addition or deletion of items, etc.) and to apply them to the entire project (pages, linked controls, reports, etc.).
The generation is automatically proposed when closing the data model editor while modifications have been performed.
You also have the ability to generate the analysis manually. That's what we are going to do.
  • To generate the analysis:
    1. In the data model editor, on the "Analysis" pane, in the "Analysis" group, click "Generation".
    2. The analysis generation is automatically started.
When your analysis is generated, the data can be handled like the HFSQL data. There is no difference. You can:
  • Create a full application via RAD (Rapid Application Development). See "Lesson 3.4. The full RAD" for more details.
  • Create a full custom application. See "Part 4" for more details.
Previous LessonTable of contentsNext Lesson
Minimum required version
  • Version 24
Comments
Click [Add] to post a comment