PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Handling the custom-folders in the analysis
  • Handling a custom-folder
  • Actions that can be performed on a custom-folder
  • Customizing the graphic representation of the custom-folder
  • Printing the content of the custom-folder
  • Handling the groups/custom-folders by programming
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
When handling analyses containing several descriptions of data files, the analysis graph is difficult to read. To manage these huge analyses, WINDEV, WEBDEV and WINDEV Mobile propose to use the custom-folders in the analysis.
The custom-folders are used to grouper several descriptions of data files.
These "custom-folders" are used to simplify:
  • the search and the display of the description of a data file found in a large analysis.
  • the operation performed on the groups of data files by programming.
    For example, you have the ability to perform a change of connection for all the data files found in a custom-folder with HChangeConnection: to do so, specify the name of the custom-folder that must be handled in the WLanguage function (see the list of available functions below).
    This feature is available for the HFSQL Classic data files, for the HFSQL Client/Server data files and for the data files handled by the Native Accesses.
These groupings are performed in the "Analysis" pane or in the analysis graph directly. These custom-folders are not physically created.
The following example groups the data files according to their category:
Limitations:
  • A custom-folder may be empty and it may contain no file description.
  • There is no need to associate a file description with a custom-folder.
  • A custom-folder cannot belong to another custom-folder.
  • Two custom-folders cannot have the same name.
  • A custom-folder and a file description cannot have the same name.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Handling the custom-folders in the analysis
The different operations that can be performed on the custom-folders of the analysis are as follows:
  • create a custom-folder.
  • rename a custom-folder.
  • delete a custom-folder.
  • associate a file description with a custom-folder.
  • dissociate a file description from a custom-folder.
To handle the custom-folders in the analysis:
  • the "Analysis" pane must be displayed ("Display .. Toolbars .. Panes .. Analysis").the "Analysis" pane must be displayed. To display the "Analysis" pane, on the "Home" pane, in the "Environment" group, expand "Panes" and select "Analysis".
  • the "Analysis" pane must be in "TreeView" mode ( ).
To handle the custom-folders in the analysis, the "Analysis" pane must be displayed. To display the "Analysis" pane, on the "Home" pane, in the "Environment" group, expand "Panes" and select "Analysis".

Handling a custom-folder

To create a custom-folder:
  1. In the "Analysis" pane (or in the analysis graph), select "New custom-folder" from the popup menu (right mouse click). A new custom-folder is automatically created.
  2. Type the name of this custom-folder and validate ([Enter] key).
To rename a custom-folder:
  1. Select the custom-folder to rename in the "Analysise" pane.
  2. Display the popup menu (right mouse click) and select "Rename" (or press [F2]).
  3. Type the new name for this custom-folder and validate ([Enter] key).
To delete a custom-folder:
  1. Select the custom-folder to delete (in the "Analysis" pane or in the analysis graph).
  2. Display the popup menu (right mouse click) and select "Delete".
  3. The custom-folder is deleted. The data files associated with this custom-folder are automatically dissociated from this custom-folder.
To associate a file description with a custom-folder:
  1. Select the file description that must be associated with the custom-folder.
  2. Drag and Drop the description toward the custom-folder to which the description must belong. The description is automatically associated with the custom-folder.
    Note: If the description already belonged to a custom-folder, the description is only associated with the new custom-folder.
To dissociate a file description from a custom-folder:
  1. Select the file description to dissociate in the "Analysis" pane.
  2. Display the popup menu (right mouse click) and select "Remove from custom-folder".
  3. The file description is automatically dissociated from the custom-folder.
Actions that can be performed on a custom-folder

Customizing the graphic representation of the custom-folder

Customizing a custom-folder consists in displaying a specific image in the background of the custom-folder.
To customize the graphic representation of a custom-folder:
  1. Select the custom-folder in the analysis graph.
  2. Display the popup menu (right mouse click) and select "Description".
  3. Check "Custom-folder displayed in the analysis graph" and select the requested image. This image will be displayed in the graphic representation of the custom-folder.
  4. Validate.

Printing the content of the custom-folder

You have the ability to print the documentation of the elements found in the custom-folder:
  1. Select the custom-folder in the "Analysis" pane.
  2. Display the popup menu (right mouse click) and select "Print".
Handling the groups/custom-folders by programming
Several WLanguage functions can be used to handle the custom-folders by programming:
Versions 09 and later
HChangeConnection
New in version 09
HChangeConnection
HChangeConnection
Dynamically changes the connection associated with a data file.
Versions 09 and later
HChangeDir
New in version 09
HChangeDir
HChangeDir
Modifies the access path to a data file (which means the directory where the file will be used).
Versions 09 and later
HChangeLocation
New in version 09
HChangeLocation
HChangeLocation
Modifies the search mode of physical data files (.FIC, .NDX, ...).
Versions 09 and later
HClose
New in version 09
HClose
HClose
Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user.
Versions 09 and later
HCreationIfNotFound
New in version 09
HCreationIfNotFound
HCreationIfNotFound
Performs the following operations
  • If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation
  • If the file exists, opens the file.
Versions 09 and later
HFlush
New in version 09
HFlush
HFlush
Forces the operating system of the computer where the data files are found to write the data onto the disk.
Versions 09 and later
HListFile
New in version 09
HListFile
HListFile
Returns the list of files:
  • found in the current analysis or in a specific analysis recognized by the HFSQL engine. The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • available on a connection via a native access or via an OLE DB driver.
  • for a group of files defined in the data model editor.
Versions 09 and later
HOpen
New in version 09
HOpen
HOpen
Opens a data file.
Versions 09 and later
HPass
New in version 09
HPass
HPass
Defines the password used to create or open a data file.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment