Windev21 Aulas,Estudos e Desenvolvimento: 08/04/20

terça-feira, 4 de agosto de 2020

DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO

https://youtu.be/440OjUIfmS0

Esse Ao Vivo vai estrear as 20:00 do dia 11/09/2020 sexta

Bom Dia/Boa Tarde/Boa Noite

DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
Tutoriel WINDEV : Leçon 3.3.a. Projet et analyse - Création

ASSUNTOS

https://windevdesenvolvimento.blogspot.com/2020/08/dicas-2997-windev-tutorial-20-projeto-e.html
https://youtu.be/440OjUIfmS0

https://doc.pcsoft.fr/fr-FR/?1410087521&name=lecon_33_projet_analyse

Video original da Franca
https://youtu.be/XxTPJjszmS4

Playlist Windev TUTORIAL
https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

Lesson 3.3. Project and analysis

This lesson will teach you the following concepts

Creating a project.
Creating an analysis.


	Estimated time: 40 mn

Previous Lesson

Table of contents

Next Lesson

Overview

To create an application with database, you must:

Create the project linked to the application. This project will group all application elements (windows, codes, queries, reports, ...).
Create the analysis linked to the project. The analysis is used to describe all data files handled by the application.


	Remark	This lesson is used to create an application with HFSQL database. As already seen in the previous lesson, WINDEV allows you to create applications that handle other databases. The "Appendix 2. Using data from an external database" lesson presents the operations that must be performed to create a project and an analysis based on an SQL database (via OLE DB or via Native Connector).

Creating the project

To create the project:
1. Start WINDEV (if not already done).
2. Display the WINDEV home page if necessary (Ctrl + <).
3. In the home page, click "Create a project" 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
  To create a project, you can also:
  
  Click among the quick access buttons.
  
  The element creation window appears: 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").
5. For this lesson, we are going to create a "blank" project. You can also create a project based on an existing example, provided with WINDEV. Select "Create a blank project" and go to the next step of the wizard.
6. WINDEV then proposes to specify the platform description. Keep the default options ("Windows 32-bit executable" and "Executable with windows"). Go to the next step of the wizard.
7. The wizard proposes to type the name of project, its location and its description. In our case, this project will be named "WD My First Database".
8. WINDEV proposes to create this project in the "\My projects\WD My First Database" directory. You can keep this location or modify it via the [...] button. For the project summary, type "The purpose of project is to manage the customers and their orders".
9. The different steps of the wizard are specified on the left. These steps can be clicked directly. Since the other steps in the "Description" are not strictly necessary, you can click "Guidelines" directly.
10. This step is used to define the code style. Don't modify the suggested options. Go to the next step.
11. This step is used to define the style book. Select "Phoenix".
  
  Go to the next step.
12. Click the "Database" step. We are now going to specify the information regarding the database.
13. Select "Yes, create a new database" and validate. The analysis creation wizard starts.


	Remark	To better understand the lessons found in this section and to optimize your training, we advise you to create the "WD My First Database" project. A corrected example can be accessed at any time to check the validity of operations performed. To open this corrected project, in WINDEV's home page (Ctrl + <), click "Tutorial" and select "My first database (Answer)".

Creating the analysis

The steps of the analysis creation wizard 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 step of the wizard.
2. Next, you can choose the types of databases used by the project. Select "HFSQL Classic" (WINDEV's default database).
  
  Go to the next step of the wizard.
3. V

ErpMatos - TgsSistemas

skype:amarildo.matos.informatica

email: amarildo.matos@gmail.com

whats: 51984197742

Youtube: Amarildo Matos

http://www.amarildomatos.com.br

https://groups.google.com/forum/#!forum/amarildowindev

www.windev.com

https://www.pcsoft.fr/webinaires.htm?p=forumpcs

https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp

https://www.windev.com/windev/WD-Express.htm

https://www.windev.com/windevmobile/WM-Express.htm

http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html

DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS

https://youtu.be/Ismg7UedLHc

Esse Ao Vivo vai estrear as 20:00 do dia 10/09/2020 quinta

Bom Dia/Boa Tarde/Boa Noite

DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
Tutoriel WINDEV : Leçon 3.2. WINDEV et les bases de données

https://windevdesenvolvimento.blogspot.com/2020/08/dicas-2996-windev-tutorial-19-windev-e.html
https://youtu.be/Ismg7UedLHc

https://www.pcsoft-windev-webdev.com/visuels/universal-access-to-data.pdf

https://doc.windev.com/en-US/?1410087520&name=lesson_32_windev_and_the_databases

Video original da Franca

https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

ErpMatos - TgsSistemas

skype:amarildo.matos.informatica

email: amarildo.matos@gmail.com

whats: 51984197742

Youtube: Amarildo Matos

http://www.amarildomatos.com.br

https://groups.google.com/forum/#!forum/amarildowindev

www.windev.com

https://www.pcsoft.fr/webinaires.htm?p=forumpcs

https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp

https://www.windev.com/windev/WD-Express.htm

https://www.windev.com/windevmobile/WM-Express.htm

http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html

Lesson 3.2. WINDEV and the databases

This lesson will teach you the following concepts

Vocabulary used.
The different modes for accessing the databases.


	Estimated time: 5 mn

Previous Lesson

Table of contents

Next Lesson

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.

HFSQL

HFSQL is a database that is very powerful, very fast and very reliable.

HFSQL operates in Windows and Linux, on mobile devices (iOS, Android, Windows CE, Windows 10), on networks of any size and type, and it automatically manages hundreds of concurrent accesses.

HFSQL can be freely distributed with your WINDEV applications.

HFSQL proposes all database features, especially:

In the different sections of this tutorial, we will use an HFSQL Classic database, then an HFSQL Client/Server database.

The different modes for accessing the databases

Native Connector (Native Access)

A Native Connector is using a database format directly and exclusively. This optimized type of access is developed specifically for each database format.

In WINDEV, a Native Connector is available for the following databases:

HFSQL Classic or Client/Server (standard)
xBase (standard)
Access (standard)
XML (standard)
SQLite (standard)
Oracle (optional)
AS/400 (optional)
SQL Server (optional)
Sybase (optional)
Informix (optional)
DB2 (optional)
Progress (optional)
MySQL (optional and free)
PostgreSQL (optional and free)
MariaDB (optional and free)
SQL Azure (optional and free)

Other Native Connectors will be available soon, contact our sales department for more details!

The WLanguage SQL* and HRead* functions can be used with this type of access. The code is portable and independent of the database.

Direct ODBC access

An access via ODBC is using a multi-database access standard. The ODBC layer must be installed on your computer. In most cases, this layer is already installed in the recent Windows versions. This can be checked in the control panel of Windows by selecting "ODBC data source" (or "ODBC administrator" according to the Windows version used).

Caution: some databases may not be accessible via this method. If you want to use this type of access, check whether an ODBC driver exists and install this driver if necessary.

Only the WLanguage SQL* functions can be used with this type of access.

OLE DB access

An access via OLE DB uses a multi-database access standard. This type of access is based on MDAC (Microsoft Data Access Component).


	Important	If you are using an OLE DB access, MDAC must necessarily be installed on the user computers (version 2.6 or later).

Some databases may not be accessible via this method. If you want to use this type of access, check whether an OLE DB driver exists.

The WLanguage SQL* and HRead* functions can be used with this type of access.

ODBC access via OLE DB

In summary, it is a "mix" of OLE DB and ODBC. This is the "heaviest" method and the least efficient one in term of performance. It should not be used on small databases.

The WLanguage SQL* and HRead* functions can be used with this type of access.