The .REP file

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Access via ODBC or OLE DB

Big Data

HFSQL functions

Handling a CEDB database

Management of 3-tier

Management of HFSQL Client/Server

Management of HFSQL Cluster

Management of log process

Management of replication

Management of statistics

Management of transactions

Management of triggers

Management of xBase files

SQL functions

The .REP file

Overview

.REP or list of files?

What is the .REP file used for?

Using the .REP file by programming

Structure of .REP file

Accessing the databases: summary

Analysis shared between earlier WINDEV applications and WINDEV 24 applications

Assisted management of HFSQL errors

Automatic modification of data files

Automatic modification of data files: new date format

Browsing the HFSQL data files

Communication by GPRS

Connecting to a database via RPC

Errors while managing data files

Filtering a data file, a view or a query

Functions for HFSQL management

HFSQL data files exceeding 2 gigabytes

HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003

HFSQL thumbnails

HFSQL: Change of name

Hyper File functions available for backward compatibility

Locking data files: correspondence between WINDEV 5.5 and the later versions

Management errors specific to Native Accesses

Managing NULL in HFSQL

Managing aliases on the data files

Managing connections

Managing space characters in the searches?

Managing the Unicode format in the HFSQL files

Managing the automatic identifiers when adding a record

Modifying the query content

Native Access access

Native XML Access

Optimizing the remote access

Partial indexing of memos

Remote access (RPC on HFSQL)

SQL functions: Special case

Search and full-text index

Synchronizing data (Windows CE)

The .REP file

The HFSQL views

The composite keys

The different types of browse available in SQL

Unalterable data files

WDModFic : Tool for automatic modification of data files

Overview
.REP or list of files?
What is the .REP file used for?
Example: Updating an application while modifying the analysis
Using the .REP file by programming
Managing the .REP file or the list of data files
Creating and modifying the .REP file (or the list of data files)
Reading the .REP file
Writing into the file
Updating the list fo data files
Structure of .REP file
Structure of .REP file

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HSetREP (Function)

The .REP file

Available only with these kinds of connection

Overview

The .REP file (or the list of files in WINDEV Mobile) allows you to store the list of the data files used by the application.

This .REP file can be used in programming by the WLanguage functions.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

.REP or list of files?

The <MyProject>.REP file contains the list of files used by the application (identifier, logical name and full path of physical file).

The GUID of the analysis is the unique identifier of the analysis linked to the project, containing the description of files. This identifier can be found in the data model editor, in the analysis description ("Options" tab).

The file GUID corresponds to the identifier of logical file. This identifier can be found in the data model editor, in the description window of file ("Notes" tab).

This file is automatically created in the directory of the application and it is filled by the HFSQL engine.

WINDEV Mobile allows you to update a list of data files used by the Windows Mobile application (equivalent to the.REP file in WINDEV).

This list is saved in the Pocket PC registry, in the following key: "\HKEY_LOCAL_MACHINE\SOFTWARE\PC SOFT\WD Mobile\25.0\<ApplicationName>\DATA".

The following details are stored for each data file used by the current application:

Identifier (GUID of the file). This identifier can be found in the data model editor, in the description window of file ("Notes" tab).
Logical name.
Full path of the physical file.

This information is automatically filled by the HFSQL Mobile engine.

For example:

What is the .REP file used for?

The ".REP" file (or the list of files in WINDEV Mobile) allows you to easily locate the data files that have been used by the WINDEV or WINDEV Mobile application.

The WINDEV application automatically updates the ".REP" file but it rarely uses the ".REP" file.

This file is used by all the tools that handle the data files of the application, and mainly by the automatic update of the data files, etc.

Example: Updating an application while modifying the analysis

When updating a WINDEV application, the automatic modification of data files is automatically started if the structure of the database is modified.

This procedure is using the ".REP" file to locate the physical files used by the application in order to modify them.

For more details, see: The automatic modification of data files

Using the .REP file by programming

Managing the .REP file or the list of data files


HSetREP	Enables or disables the management of .REP file When the management of .REP file is enabled, you have the ability to specify the name and path of the .REP file. A HFREP.INI file will be created in the directory of common application data (\Application Data\PC SOFT directory). The management of ".REP" file is enabled by default.

Creating and modifying the .REP file (or the list of data files)


HCreation	Creates a physical data file. This function fills the .REP file if the management of .REP file is enabled.
HCreationIfNotFound	Creates a physical data file if it does not exist. This function fills the .REP file if the management of .REP file is enabled and if the hDelayedOpening constant is not used. If the hDelayedOpening constant is specified, the .REP file will be updated during the automatic opening of the file during the first access to the file.
HOpen	Opens a physical data file and fills the .REP file if necessary

Note: The information given by HChangeDir, HSubstDir and HChangeName is taken into account when creating and updating the ".REP" file.

Reading the .REP file


HListREP	Lists the different files found in the .REP file as well as their physical path

Writing into the file

To write into the .REP file, all you have to do is use the functions for managing the external files:

fOpen: to open the file
fWriteLine: to write a new line into the file
fClose: to close the file

The structure of the added line must be as follows:


LOCALIZATION=	File GUID	Tabulation	Logical file name	Tabulation	Path of physical file


LOCALIZATION_CS=	File GUID	Tabulation	Logical name of the file	Tabulation	Physical location of the file in the HFSQL server	Tabulation
	ServerName:Port	Tabulation	ServerIP:Port	Tabulation	Database

In an application in Unicode, LOCALIZATION_CS is replaced by LOCALIZATION_CS_UTF8: the different strings are encoded in UTF8.

The GUID of the file corresponds to the identifier of the logical data file. This identifier can be found in the data model editor, in the description of the data file ("Notes" tab).

Two WLanguage properties return the GUID of a data file and the GUID of the analysis that created it:


GUIDAnalysis	Returns the GUID of the analysis that was used to create the data file.
GUIDFile	Returns the GUID of the file defined in the analysis that was used to create the data file.

Updating the list fo data files

To update the list of data files, you have the ability to use the functions for registry management (or the ceRegistryXXX functions from a standard WINDEV application).

Structure of .REP file

The .REP file has the following structure:

The first line contains the information regarding the analysis in which the data files have been described. This analysis corresponds to the analysis of the current project.
The structure of this line is as follows:
ANALYSISGUID= Analysis GUID

The GUID of the analysis is the unique identifier of the analysis linked to the project, containing the description of the data files. This identifier can be found in the data model editor, in the analysis description ("Options" tab).

The following lines describe the different data files handled by the application. A line is created for each physical data file handled. This line contains the following information:
LOCALIZATION= File GUID Tabulation Logical name of data file Tabulation Path of physical data file

The file GUID corresponds to the identifier of logical file. This identifier can be found in the data model editor, in the description of the data file ("Notes" tab).

Example of .REP file: