ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Array items
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HRecordToXML (Function)
In french: HEnregistrementVersXML
ODBCNot available with this kind of connection
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
Remark: This function can be used on both data files and queries.
Example
// Exporte l'enregistrement en cours du dernier fichier de données utilisé
sXML is string = HRecordToXML()
// Exporte l'enregistrement en cours du fichier de données "Client"
sXML is string 
sXML = HRecordToXML(Client)
// Exporte l'enregistrement en cours du fichier de données "Client"
// Remarque : seules les rubriques NOM et NUMERO sont prises en compte
sXML is string 
sXML = HRecordToXML(Client, "NOM,NUMERO")
Syntax
<Result> = HRecordToXML([<Data file> [, <List of items> [, <Charset>]]])
<Result>: ANSI character string
Structure and value of the current record in XML format. This structure has the following format:
<FILE>
<ITEM1> data of item 1 </ITEM1>
<ITEM2> data of item 2 </ITEM2>
<ITEM3> data of item 3 </ITEM3>
...
</FILE>
<Data file>: Optional character string
Name of the HFSQL data file or query used. If this parameter is not specified, the last HFSQL data file used will be taken into account.
<List of items>: Optional character string
Name of the items to export.
If several items are specified, the name of the items must be separated by a comma.
Composite key, binary memo or binary items are ignored.
If this parameter is not specified or is an empty string (""), all fields are exported (except compound key, binary memo or binary fields) in the physical order of description.
<Charset>: Integer constant
Character set that will be used to generate the XML file:
charsetAnsiRoman characters in ANSI standard
charsetArabicArabic characters
charsetBalticBaltic characters
charsetChineseChinese characters (People's Republic of China)
charsetDefaultUses the computer's default character set. No character set is forced.
charsetEastEuropeEastern European characters (Polish, etc.)
charsetGreekGreek characters
charsetHebrewHebrew characters
charsetJapaneseJapanese characters
charsetKoreanKorean characters
charsetOccidentalRoman characters in ANSI standard
charsetRussianRussian characters
charsetThaiThai characters
charsetTraditionalChineseTraditional Chinese characters (Republic of Taiwan)
charsetTurkishTurkish characters
charsetUTF8Used to manage the countries with two character sets (Hong Kong) and the countries with no character set defined in Windows (Georgian and Armenian).
charsetVietnameseVietnamese characters
Remarks

Array items

If one of the exported items is an array item, each element of the array item is exported in a new level:
<FILE>
<ITEM1> data of item 1 </ITEM1>
<ITEM2> data of item 2 </ITEM2>
<ARRITEM>
<ARRITEM_1> data of element 1 </ARRITEM_1>
<ARRITEM_2> data of element 2 </ARRITEM_2>
<ARRITEM_3> data of element 3 </ARRITEM_3>
</ARRITEM>
...
</FILE>

Reminder: Compound key, binary memo and binary fields are ignored.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help