|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The management mode of tables may have to be adapted when using an HFSQL Client/Server application... |
|
|
|
|
|
|
|
| WDModFic is a tool for automated modification of tables on development and end-user workstations... |
|
|
|
|
|
|
|
| The FicEncryption property sets the encryption method of a table. |
|
|
|
|
|
|
|
| A server may encounter problems without any user (or developer) noticing anything. For example: - a scheduled task may fail,
- an automatic backup may fail,
- a node may become inactive in an HFSQL cluster, ...
|
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| WDTRAD allows you to import and export a dictionary... |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| The following files are automatically created when logging an HFSQL Client/Server table... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "normal" records if they do not belong to an ongoing transaction... |
|
|
|
|
|
|
|
| The following files are automatically created when logging an HFSQL Classic table... |
|
|
|
|
|
|
|
| WDLog is used to view the content of a log file... |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all changes made to the files since the beginning of the transaction... |
|
|
|
|
|
|
|
| Deletes a file identified by its identifier from a MongoDB file system. |
|
|
|
|
|
|
|
| The aliases are used to handle ... |
|
|
|
|
|
|
|
| Usage example of the HCancelDeclaration function |
|
|
|
|
|
|
|
| WDLog is used to apply to a backup of a data file the different operations saved in the log of this file... |
|
|
|
|
|
|
|
| Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in Reports & Queries... |
|
|
|
|
|
|
|
| Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| Usage example of the HCopyFile function |
|
|
|
|
|
|
|
| The wizard for creating iPad windows allows you to easily create a window containing all the main elements of a window for an iPad application... |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server table. |
|
|
|
|
|
|
|
| WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application... |
|
|
|
|
|
|
|
| The main operations that can be performed on a table from the table model editor are as follows ... |
|
|
|
|
|
|
|
| WDTRAD is automatically installed along with WDMSG and/or WDINT. |
|
|
|
|
|
|
|
| Usage example of the HInfoFileRights function |
|
|
|
|
|
|
|
| Regardless of the tables used by your application (HFSQL Classic or HFSQL Client/Server), the log process can be implemented on these tables... |
|
|
|
|
|
|
|
| Usage example of the HAlias function |
|
|
|
|
|
|
|
Performs the following operations: - If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
- If the table exists, opens the table.
|
|
|
|
|
|
|
|
| Deletes a file identified by its identifier from a MongoDB file system. |
|
|
|
|
|
|
|
| Returns the list of items: |
|
|
|
|
|
|
|
Performs the following operations: - If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
- If the table exists, opens the table.
|
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| Retrieves information about the current exception. |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
|
| WDZip is used to compress and group your files in archives... |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server table. |
|
|
|
|
|
|
|
| WDLog is used to restore the tables saved by WDLog... |
|
|
|
|
|
|
|
WINDEV includes a wizard for generating a setup program:- to install a WINDEV application.
- to install other files. Installing goodies for instance (images, videos, ...).
|
|
|
|
|
|
|
|
| Usage example of the HCopyRecord function |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to use the OpenOffice spelling checker in your interfaces |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".rpl" extension). |
|
|
|
|
|
|
|
Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any):- from the HFSQL server to the server (to perform a backup for example).
- from the HFSQL server to the client (to perform a local backup for example).
- from the client to the HFSQL server (to update the tables for example).
- from an HFSQL server to antoher HFSQL server.
|
|
|
|
|
|
|
|
| Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
| Modifies the search mode of physical tables (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
| Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user. |
|
|
|
|
|
|
|
| Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server table. |
|
|
|
|
|
|
|
| Retrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Modifies the search mode of physical tables (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| Lists the different triggers available on a connection or on one of the connection files. |
|
|
|
|
|
|
|
Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any):- from the HFSQL server to the server (to perform a backup for example).
- from the HFSQL server to the client (to perform a local backup for example).
- from the client to the HFSQL server (to update the tables for example).
- from an HFSQL server to antoher HFSQL server.
|
|
|
|
|
|
|
|
| Refreshes a TreeView control from a given position. |
|
|
|
|
|
|
|
| The DirectoryJournalOperation property is used to manage the directory of the log of operations file associated with a log table. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user. |
|
|
|
|
|
|
|
| Creates the image of the specified window in a BMP file. |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| WINDEV Tutorial: Creating a WINDEV project and its database schema
Lesson 2 - Creating tables in the database schema - 40 min |
|
|
|
|
|
|
|
| Several WLanguage functions allow you to include log-based replication in your application and to customize it... |
|
|
|
|
|
|
|
| Usage example of the HChangeName function |
|
|
|
|
|
|
|
Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
|
|
|
|
|
|
|
| Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
|
| WEBDEV Tutorial - Website deployment
Lesson 2 - Deploying a website via HTTP - 30 min |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Usage example of the HDeclareExternal function |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| WEBDEV Tutorial - Creating a WEBDEV project and its database schema
Lesson 2 - Creating tables in the database schema - 40 min |
|
|
|
|
|
|
|
| Creates an empty table (file extension ".FIC") with index file, full-text index file and memo file if required. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the business rules... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
Returns a directory path for the data shared: - between all the users of the computer
- between all the TSE users
This directory can be used without restriction in Windows XP, Vista, and so on. This directory is used to store: - the files for the general configuration of the application (.INI files, .XML files, etc.).
- tables common to all users (HFSQL tables .fic, .ndx, .mmo).
|
|
|
|
|
|
|
|
| Once the translation of framework libraries ("... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose several WLanguage functions allowing you to compress and merge your files into archives... |
|
|
|
|
|
|
|
| Creates an empty table (extension ".FIC") with index file, full-text index file, spatial index file, and memo file if required. |
|
|
|
|
|
|
|
| When creating a project, a directory specific to this project is automatically created... |
|
|
|
|
|
|
|
| When generating the external component, two files are automatically created in the EXE directory of the current project... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... |
|
|
|
|
|
|
|
| Fills an array of classes or structures with the content of an HFSQL table or query. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| If your application uses assisted universal replication via a .WER file, the setup creation wizard proposes to configure the setup to install the different tools required for this type of replication. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an HFSQL Client/Server table. |
|
|
|
|
|
|
|
| The hFileParameter type is used to define the tables taken into account by a scheduled optimization task. |
|
|
|
|
|
|
|
| Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
|
| Log-based replication can be implemented in the data model editor... |
|
|
|
|
|
|
|
| Returns a directory path for the data of the current user of the current application. |
|
|
|
|
|
|
|
| Creates the description file of a Master Replica (logged replication or universal replication). |
|
|
|
|
|
|
|
| Several file descriptions can be grouped into a "Custom-Folder"... |
|
|
|
|
|
|
|
| WDInst allows you to configure the characteristics of the files to install... |
|
|
|
|
|
|
|
| Loads the content of an external file (text, image, ...) in a buffer variable. |
|
|
|
|
|
|
|
| A project is a logical set of elements and processes whose purpose is to accomplish a given objective... |
|
|
|
|
|
|
|
| A project is a logical set of elements and processes whose purpose is to accomplish a given objective... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| List of constants used by the functions for managing errors and exceptions. |
|
|
|
|
|
|
|
| The hBackupDescription type is used to programmatically describe an HFSQL Client/Server backup. |
|
|
|
|
|
|
|
| The comparison between source and target text helps you find translation errors... |
|
|
|
|
|
|
|
| Returns a detailed information about the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an HFSQL Client/Server table. |
|
|
|
|
|
|
|
| Using WDConver in command line mode consists in running a conversion description created and saved with WDConver ("... |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user computers... |
|
|
|
|
|
|
|
| Deletes a worksheet from the Excel document. |
|
|
|
|
|
|
|
| The code editor allows you to enter "Code snippets"... |
|
|
|
|
|
|
|
Specifies the useful size of an internal window with automatic scrollbars. The useful size corresponds to the full size of the internal window: - Width of the internal window.
- Height of the internal window.
|
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table. |
|
|
|
|
|
|
|
| A project is a logical set of elements and processes whose purpose is to accomplish a given objective... |
|
|
|
|
|
|
|
| WDOptimizer is used to... |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| Définit l'image SVG utilisée pour un graphe de type "Pourcentage imagé". |
|
|
|
|
|
|
|
| External component in practice |
|
|
|
|
|
|
|
| WINDEV Mobile Tutorial: Deploying an iOS application
10 min |
|
|
|
|
|
|
|
| Example of the HCreation function |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| WINDEV Tutorial - Deploying an application
Creating the executable and the setup program - 30 min |
|
|
|
|
|
|
|
| The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB... |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
The setup wizard allows you to: - Select and configure the files to install. This step is very important.
- Specify the WINDEV framework used by the installer.
|
|
|
|
|
|
|
|
| The data handled by a WINDEV Mobile application can come from |
|
|
|
|
|
|
|
| This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features... |
|
|
|
|
|
|
|
| The setup wizard allows you to include additional modules in the setup. The additional modules are used to add additional options to the setup program and to access the advanced setup parameters. |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| List of functions for handling external files |
|
|
|
|
|
|
|
| Duplicates the record read in a table: the record found in memory is added into the table (query or view). |
|
|
|
|
|
|
|
| Duplicates the record read in a table: the record found in memory is added into the table (query or view). |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| HFSQL Classic is the database format... |
|
|
|
|
|
|
|
| Creates the description file of a subscriber replica. |
|
|
|
|
|
|
|
| The following text can be extracted... |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| WINDEV Mobile Tutorial: Deploying an Android application
10 min |
|
|
|
|
|
|
|
| The LogFile property is used to determine if a table is a log file.
|
|
|
|
|
|
|
|
| WINDEV Tutorial - Reports and Queries
Distribute Reports and Queries with your applications - 10 min |
|
|
|
|
|
|
|
| WINDEV allows you to create native 64-bit Linux executables. Their UI is developed with the window editor. |
|
|
|
|
|
|
|
| To create a.NET application from a project... |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| A replication includes one or more tables... |
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| An HFSQL application can operate in network mode or in Client/Server mode... |
|
|
|
|
|
|
|
| The remote administration tool is used to manage the backups of your dynamic WEBDEV websites. |
|
|
|
|
|
|
|
Adds: - the record found in memory into the table (query or view).
- the record found in a Record variable into the table (query or view).
|
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to manage the different HFSQL databases (Network, Mobile, Client/Server) of an organization... |
|
|
|
|
|
|
|
| Synchronizes the master replica and the subscriber replica: the operations performed on one of the replica are transferred into the other replica. |
|
|
|
|
|
|
|
| Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table. |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| The code history is used to... |
|
|
|
|
|
|
|
Adds: - the record found in memory into the table (query or view).
- the record found in a Record variable into the table (query or view).
|
|
|
|
|
|
|
|
| What's new in WINDEV 2026 in the What's new 2026 brochure. |
|
|
|
|
|
|
|
| Moves a directory and its contents to another directory within a remote drive. |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| WEBDEV 2026 new features in the 2026 New Features brochure. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure. |
|
|
|
|
|
|
|
| What's new in WINDEV Mobile 2026 is presented in the What's new 2026 brochure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|