|
|
|
|
|
|
|
|
HRecordToXML (Function) In french: HEnregistrementVersXML
 Not 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 the data files and on the queries.
// Export current record of the last data file used
sXML is string = HRecordToXML() // Export current record of "Customer"
sXML is string
sXML = HRecordToXML(Customer) // Export current record of "Customer"
// Remark: only the NAME and NUMBER items are taken into account
sXML is string
sXML = HRecordToXML(Customer, "NAME,NUMBER") 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 if it corresponds to an empty string (""), all the items are exported (except Composite Key items, Binary Memo items and Binary items) in the physical order of description. <Charset>: Integer constant Character set that will be used to generate the XML file: | | | charsetAnsi | Roman characters in ANSI standard | | charsetArabic | Arabic characters | | charsetBaltic | Baltic characters | | charsetChinese | Chinese characters (People's Republic of China) | | charsetDefault | Uses the computer's default character set. No character set is forced. | | charsetEastEurope | Eastern European characters (Polish, etc.) | | charsetGreek | Greek characters | | charsetHebrew | Hebrew characters | | charsetJapanese | Japanese characters | | charsetKorean | Korean characters | | charsetOccidental | Roman characters in ANSI standard | | charsetRussian | Russian characters | | charsetThai | Thai characters | | charsetTraditionalChinese | Traditional Chinese characters (Republic of Taiwan) | | charsetTurkish | Turkish characters | | charsetUTF8 | Used to manage the countries with two character sets (Hong Kong) and the countries with no character set defined in Windows (Georgian and Armenian). | | charsetVietnamese | Vietnamese 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> : Composite key, binary memo or binary items are ignored.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|