|
|
|
|
|
|
|
|
|
|
|
|
| Resultados de la búsqueda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Conecta la aplicación actual a una base de datos que será consultada por SQL a través de un proxy de servicio web (SOAP). |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database... |
|
|
|
|
|
|
|
The CacheSize property is used to:- Get the maximum number of records that can be stored in the cache of the Native MySQL Connector.
- Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.
|
|
|
|
|
|
|
|
| La propiedad CtCacheSize permite determinar y cambiar el número máximo de registros que se pueden almacenar en la caché del Conector Nativo MySQL. |
|
|
|
|
|
|
|
| WordPress ofrece numerosas plantillas para crear sitios web originales... |
|
|
|
|
|
|
|
| Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| Crea una lista de las bases de datos Client/Server asociadas a una conexión. |
|
|
|
|
|
|
|
The Source property can be used on:- Chart control field field: in this case, the Source property indicates the source of the series: table column, list of values, etc, ...
- connection in which case the Source property is used to identify or define the source of a connection (HFSQL Client/Server, OLE DB, etc.).
|
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| La ventana de descripción del proyecto permite configurar varios elementos del proyecto... |
|
|
|
|
|
|
|
| Para migrar un sitio WEBDEV a PHP... |
|
|
|
|
|
|
|
Begins, commits or rolls back a transaction:- on the files of a database opened by SQLConnect,
- on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.
|
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
Used to lock:- The entire data table, in read and write mode. Its data cannot be accessed by other computers.
- The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.
|
|
|
|
|
|
|
|
| Like for any application, WINDEV allows you to create a setup program for a Java application... |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| La propiedad Provider permite gestionar el tipo de una conexión (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| Stores the current context of a data file: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Conecta la aplicación actual a una base de datos que debe ser interrogada mediante SQL. |
|
|
|
|
|
|
|
| La propiedad CtOLEDBProvider obtiene y establece el nombre del proveedor OLE DB (también llamado servidor OLE DB). |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information... |
|
|
|
|
|
|
|
| Abre una conexión a una base de datos Client/Server específica para gestionar archivos del Groupware Usuario en modo Client/Server. |
|
|
|
|
|
|
|
| La propiedad CtDescribedOLEDBProvider obtiene y establece el nombre del proveedor OLE DB (también llamado servidor OLE DB). |
|
|
|
|
|
|
|
The CalculatedItemExpression property is used to:- Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or programmatically.
- Define the SQL expression returning the value of a calculated item (when describing the item through programming).
|
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
Returns the list of files:- current analysis.
- analyses in progress (projects with multiple analyses).
- a specific analysis recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| WEBDEV le permite crear un sitio PHP que maneja archivos de datos... |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
|
|
|
|
|
|
|
| Para seleccionar registros procedentes de varios archivos de datos, se deben utilizar uniones en la consulta SQL.... |
|
|
|
|
|
|
|
| Algunas funciones de WLanguage no están disponibles en PHP... |
|
|
|
|
|
|
|
| The automatic assisted replication is used to easily implement a replication on an existing application... |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| A site generated in PHP can be debugged in standard WEBDEV mode... |
|
|
|
|
|
|
|
| Este documento presenta los diferentes modos de acceso a bases de datos desde una aplicación WINDEV Java... |
|
|
|
|
|
|
|
| Crea un archivo de datos vacío (extensión ".FIC") con el archivo de índice y el archivo memo, si es necesario. |
|
|
|
|
|
|
|
| Creates an empty data file (file extension ".FIC") with index file, full-text index file and memo file if required. |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| The assisted replication through programming is used to implement a replication on an existing application while controlling the synchronization in the application itself... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| An LDM (Logical Data Model) is used to describe data structures (data files, fields, etc.)... |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| Tutorial WINDEV - Base de datos externa
Utilizar datos de una base de datos externa - 40 min |
|
|
|
|
|
|
|
| WINDEV y WEBDEV permiten manipular fácilmente bases de datos externas (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| WINDEV le permite generar una aplicación Java sin siquiera conocer el lenguaje Java... |
|
|
|
|
|
|
|
| Aplicaciones Java en la práctica |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Importa temporalmente la descripción de un archivo de datos en el análisis actual a partir de un archivo de datos HFSQL existente. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV y WINDEV Mobile proponen los tipos Enumeración y Combinación... |
|
|
|
|
|
|
|
| The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ... |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| The native access to HFSQL Classic and Client/Server is available for WINDEV applications running in Linux ("console" applications) and for the WEBDEV websites hosted in Linux... |
|
|
|
|
|
|
|
The Type property is used to get:- the type of element (data file or item) defined programmatically or in the data model editor, view or query.
- the type of object.
- the type of data held in a Variant.
|
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| WINDEV allows you to create native 64-bit Linux executables. Their UI is developed with the window editor. |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| Lista de propiedades HFSQL |
|
|
|
|
|
|
|
| Declara una consulta creada en el editor de consultas al motor HFSQL y ejecuta la consulta. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| Una aplicación Java es una aplicación compilada íntegramente en Java... |
|
|
|
|
|
|
|
| WEBDEV 2026 ya está disponible. |
|
|
|
|
|
|
|
| Declara una consulta creada en el editor de consultas al motor HFSQL y ejecuta la consulta. |
|
|
|
|
|
|
|
| WINDEV 2026 ya está disponible. |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure. |
|
|
|
|
|
|
|
| What's new in WINDEV/WEBDEV/WINDEV Mobile 2025 in the What's new 2025 brochure. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 2024 presented in the 2024 New Features brochure. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|