PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Overview
  • Operations in the data model editor
  • Importing an XML document
  • Generating the analysis
  • Use by programming
  • Browsing the different files of XML document
  • Limitations
  • Queries
  • Creating files
  • Filter
  • Reading XML files
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
Native XML Access
Native AccessesAvailable only with this kind of connection
Overview
WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor.
The method for handling the XML files is the same as the method for handling the standard HFSQL data files.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Operations in the data model editor

Importing an XML document

To import the structure of an XML document into the data model editor:
  1. In the data model editor, start the import wizard ("Structure of files .. Import the descriptions of files/tables"). In the data model editor, start the import wizard: on the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import the descriptions of files/tables".
  2. In the wizard that starts:
    • Specify the database type: XML
    • Specify whether the data must be migrated to the HyperFileSQL Classic format.Specify whether the data must be migrated to the HFSQL Classic format.
    • Specify the path of the XML document to import.
    • Select the tables of the XML document to import.
  3. Validate the wizard: the different files found in the XML document and their tree structure are automatically represented in the data model editor.

Generating the analysis

When the analysis is generated ("Analysis .. Generation"), you have the ability to create windows or pages that handle the XML document described in the analysis.To create windows or pages that handle the XML document described in the analysis, the analysis must be generated: on the "Analysis" pane, in the "Analysis" group, click Generation icon .
Use by programming

Browsing the different files of XML document

The structure of an XML document is represented by different files in the data model editor.
To read the content of an XML file, read the content of main file (the parent) then read the content of linked files (the children).
By default, when reading a file, a filter is automatically applied to the linked files in order to only read the records corresponding to the main file.
For example:
Browsing the different files of XML document
The email of this person can be retrieved when browsing the Person file.
To do so, all you have to do is position on the "Person" file and apply HReadFirst to the "Email" file.
In this case, the record read in the "Email" file will correspond to the first email associated with the current record in the "Person" file.
If this mechanism is disabled (HDeactivateAutoFilter), the record read in the "Email" file will correspond to the first record found in the Email file (and not to the child of the record read in the "Person" file).
To re-enable the positioning mechanism in the linked files, use HActivateAutoFilter.
Limitations

Queries

The queries are not available for the XML files.

Creating files

The functions for file creation (HCreation and HCreationIfNotFound) are not available for the XML files.

Filter

The following syntax of HFilter is not available for the XML files:
<Result> = HFilter(<File Name> , <Selection Condition>)

Reading XML files

HRead reads the current record only. You cannot specify a record number other than the current one. To specify the current record number, use the hCurrentRecNum constant.
See also
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment