|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The management mode of data files may have to be adapted when using an HFSQL Client/Server application... |
|
|
|
|
|
|
|
| WDModFic is a tool for automated modification of data files on development and end-user workstations... |
|
|
|
|
|
|
|
| The FicEncryption property sets the encryption method of a data file. |
|
|
|
|
|
|
|
| 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, ...
|
|
|
|
|
|
|
|
| WDTRAD allows you to import and export a dictionary... |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| Used to recreate an empty log. |
|
|
|
|
|
|
|
| The following files are automatically created when logging an HFSQL Client/Server data file... |
|
|
|
|
|
|
|
| WDLog is used to view the content of a log file... |
|
|
|
|
|
|
|
| Sets to a normal state all records that are wrongly marked as held by a transaction... |
|
|
|
|
|
|
|
| The following files are automatically created when logging an HFSQL Classic data file... |
|
|
|
|
|
|
|
| Describes through programming the different index files that will be created. |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all changes made to the files since the beginning of the transaction... |
|
|
|
|
|
|
|
| Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The aliases are used to handle ... |
|
|
|
|
|
|
|
| Deletes a file identified by its identifier from a MongoDB file system. |
|
|
|
|
|
|
|
| Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in Reports & Queries... |
|
|
|
|
|
|
|
| Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| Usage example of the HCopyFile function |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file. |
|
|
|
|
|
|
|
| Regardless of the data files used by your application (HFSQL Classic or HFSQL Client/Server), the log process can be implemented on these data files... |
|
|
|
|
|
|
|
| WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application... |
|
|
|
|
|
|
|
| The main operations that can be performed on a data file from the data model editor are as follows ... |
|
|
|
|
|
|
|
| MCI functions are used to easily handle the media files... |
|
|
|
|
|
|
|
| WDTRAD is automatically installed along with WDMSG and/or WDINT. |
|
|
|
|
|
|
|
| Usage example of the HInfoFileRights function |
|
|
|
|
|
|
|
| Usage example of the HAlias function |
|
|
|
|
|
|
|
Copies an HFSQL data file (.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 data files for example).
- from an HFSQL server to antoher HFSQL server.
|
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
|
Performs the following operations: - If the data file doesn't exist, create an empty data file (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 data file exists, opens the data file.
|
|
|
|
|
|
|
|
| Deletes a file identified by its identifier from a MongoDB file system. |
|
|
|
|
|
|
|
| Retrieves (on the local computer) a file identified by its identifier and found in a MongoDB file system. |
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
|
Performs the following operations: - If the data file doesn't exist, create an empty data file (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 data file exists, opens the data file.
|
|
|
|
|
|
|
|
Returns the list of items:- found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
- found in a Record variable.
|
|
|
|
|
|
|
|
| WDZip is used to compress and group your files in archives... |
|
|
|
|
|
|
|
WINDEV includes a wizard for generating a setup program:- to install a WINDEV application.
- to install other files. Installing goodies for instance (images, videos, ...).
|
|
|
|
|
|
|
|
Copies an HFSQL data file (.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 data files for example).
- from an HFSQL server to antoher HFSQL server.
|
|
|
|
|
|
|
|
| Several file descriptions can be grouped into a "Custom-Folder"... |
|
|
|
|
|
|
|
| Usage example of the HCopyRecord function |
|
|
|
|
|
|
|
| The mongoGridFSFileInfo type is used to define the advanced characteristics of a file in a MongoDB database. |
|
|
|
|
|
|
|
| Reinitializes the content of a Scheduler control from its data source (HFSQL data file, for example). |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Retrieves information about the current exception. |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
| Reinitializes the content of a Scheduler control from its data source (HFSQL data file, for example). |
|
|
|
|
|
|
|
| WDLog is used to restore the data files saved by WDLog... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file. |
|
|
|
|
|
|
|
| Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. |
|
|
|
|
|
|
|
| Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Refreshes a TreeView control from a given position. |
|
|
|
|
|
|
|
| Retrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component. |
|
|
|
|
|
|
|
| Modifies the search mode of physical data files (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
|
|
|
|
|
|
|
| Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. |
|
|
|
|
|
|
|
| Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Refreshes a TreeView control from a given position. |
|
|
|
|
|
|
|
| Lists the different triggers available on a connection or on one of the connection files. |
|
|
|
|
|
|
|
| The DirectoryJournalOperation property is used to manage the directory of the log of operations file associated with a log data file. |
|
|
|
|
|
|
|
| Modifies the search mode of physical data files (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| WINDEV Tutorial: Creating a WINDEV project and its analysis
Lesson 2 - Creating data files in the analysis - 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 |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| WEBDEV Tutorial - Website deployment
Lesson 2 - Deploying a website via HTTP - 30 min |
|
|
|
|
|
|
|
| Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Usage example of the HDeclareExternal function |
|
|
|
|
|
|
|
| WEBDEV Tutorial - Creating a WEBDEV project and its analysis
Lesson 2 - Creating data files in the analysis - 40 min |
|
|
|
|
|
|
|
| Once the translation of framework libraries ("... |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an item. |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Creates an empty data file (extension ".FIC") with index file, full-text index file, spatial index file and memo file if required. |
|
|
|
|
|
|
|
| Creates an empty data file (file extension ".FIC") with index file, full-text index file and memo file if required. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an item. |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have... |
|
|
|
|
|
|
|
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.).
- data files common to all users (HFSQL data files .fic, .ndx, .mmo).
|
|
|
|
|
|
|
|
| When creating a project, a directory specific to this project is automatically created... |
|
|
|
|
|
|
|
| Fills an array of classes or structures with the content of an HFSQL data file or query. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the business rules... |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| WDInst allows you to configure the characteristics of the files to install... |
|
|
|
|
|
|
|
| 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 file (.NDX file) properly refers the data found in the data file (.FIC file). |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| The hFileParameter type is used to define the data files taken into account by a scheduled optimization task. |
|
|
|
|
|
|
|
| Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
|
| Creates the description file of a Master Replica (logged replication or universal replication). |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| Loads the content of an external file (text, image, ...) in a buffer variable. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose several WLanguage functions allowing you to compress and merge your files into archives... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files... |
|
|
|
|
|
|
|
| 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 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... |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| Using WDConver in command line mode consists in running a conversion description created and saved with WDConver ("... |
|
|
|
|
|
|
|
| Returns a detailed information about the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| The code editor allows you to enter "Code snippets"... |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| A project is a logical set of elements and processes whose purpose is to accomplish a given objective... |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user computers... |
|
|
|
|
|
|
|
| External component in practice |
|
|
|
|
|
|
|
| WINDEV Mobile Tutorial: Deploying an iOS application
10 min |
|
|
|
|
|
|
|
| Example of the HCreation function |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| WINDEV Tutorial - Deploying an application
Creating the executable and the setup program - 30 min |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module... |
|
|
|
|
|
|
|
| The data handled by a WINDEV Mobile application can come from |
|
|
|
|
|
|
|
| List of functions for handling external files |
|
|
|
|
|
|
|
| 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 data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| Duplicates the record read in a data file. The record in memory is added to the data file (query or view). |
|
|
|
|
|
|
|
The property Name allows you to:- find out the name of the font associated with a variable of type Font.
- know the name of a field, report or report block.
- know the name of a field, a group of fields or a window.
- know the name of a field, a group of fields or a page.
- know and modify the name of a heading, data file, full-text index or semantic index.
|
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| HFSQL Classic is the database format... |
|
|
|
|
|
|
|
| The following text can be extracted... |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".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. |
|
|
|
|
|
|
|
| Creates the description file of a subscriber replica. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".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. |
|
|
|
|
|
|
|
| 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 LogFile property is used to determine if a data file is a log file.
|
|
|
|
|
|
|
|
| WINDEV Tutorial - Reports and Queries
Distribute Reports and Queries with your applications - 10 min |
|
|
|
|
|
|
|
| To create a.NET application from a project... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| WINDEV Mobile Tutorial: Deploying an Android application
10 min |
|
|
|
|
|
|
|
| WINDEV allows you to create native 64-bit Linux executables. Their UI is developed with the window editor. |
|
|
|
|
|
|
|
| A replication includes one or more data files... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Ends the description of the structure of an xBase data file programmatically. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Synchronizes the master replica and the subscriber replica: the operations performed on one of the replica are transferred into the other replica. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
Adds: - the record found in memory into the data file (query or view).
- the record found in a Record variable into the data file (query or view).
|
|
|
|
|
|
|
|
| The code history is used to... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to manage the different HFSQL databases (Network, Mobile, Client/Server) of an organization... |
|
|
|
|
|
|
|
Adds: - the record found in memory into the data file (query or view).
- the record found in a Record variable into the data file (query or view).
|
|
|
|
|
|
|
|
| What's new in WINDEV 2026 in the What's new 2026 brochure. |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|