terça-feira, 4 de agosto de 2020

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://youtu.be/Q0JBDyqyQY4


Playlist Windev TUTORIAL

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













Lesson 3.2. WINDEV and the databases

This lesson will teach you the following concepts
  • Vocabulary used.
  • The different modes for accessing the databases.
Lesson duration

Estimated time: 5 mn
Previous LessonTable of contentsNext 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.


DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO








Nenhum comentário:

Postar um comentário

Teste

Teste
teste