Native XML Access

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

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

Native XML Access

Overview

Operations in the data model editor

Use by programming

Limitations

See also

Accessing HFSQL files via SAMBA on Linux

Accessing the databases: summary

Analysis shared between earlier WINDEV applications and WINDEV 24 applications

Assisted management of HFSQL errors

Automatic data file modification: new date format

Automatic modification of data files

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 management functions (prefixed syntax)

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
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

WEBDEV

WINDEV Mobile

Others

See also

Management of XML

Native XML Access

Available 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. Remark: 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:

In the data model editor, start the import wizard: on the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import file/table descriptions".
In the wizard that starts:
- Specify the database type: XML
- 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.
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

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 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.