PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Use conditions
  • Binary Memo column (image)
  • Limit
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
Creates an XML file from the data found in a Table or TreeView Table control .
Notes:
  • By default, a style sheet (".XSL" file) is automatically generated when creating the XML file.
  • The document entity of generated XML file is named WINDEV_TABLE.
Versions 15 and later
PHP This function is now available for the PHP sites.
New in version 15
PHP This function is now available for the PHP sites.
PHP This function is now available for the PHP sites.
Versions 18 and later
WEBDEV - Server codePHP This function can now be used to handle the treeview tables in the WEBDEV and PHP sites.
New in version 18
WEBDEV - Server codePHP This function can now be used to handle the treeview tables in the WEBDEV and PHP sites.
WEBDEV - Server codePHP This function can now be used to handle the treeview tables in the WEBDEV and PHP sites.
Versions 20 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
New in version 20
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
Versions 23 and later
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 23
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
Example
WINDEVReports and QueriesUser code (UMC)
sFile is string
// File name
sFile = fSelect("", "", "Choose the export file", ...
"XML files (*.XML) *.xml", "xml", fselCreate + fselExist)
// The export is canceled if no name was specified
// Otherwise, export the content of TABLE_TABLE1
IF sFile <> "" THEN TableToXML(TABLE_TABLE1, sFile, taNoTitle)
WEBDEV - Server codeAjax
sFile is string
// File name
sFile = CompleteDir(fExeDir()) + "MyXML" + ConnectionCount() + ".xml"
// The export is canceled if no name was specified
// Otherwise, export the content of TABLE_TABLE1
IF sFile <> "" THEN TableToXML(TABLE_TABLE1, sFile, taNoTitle)
Syntax
<Result> = TableToXML(<Table Name> , <Name of XML File> [, <Options> [, <Start Row> [, <End Row>]]])
<Result>: Boolean
  • True if the file was created,
  • False otherwise.
<Table Name>: Character string (with or without quotes)
Name of control to use. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
<Name of XML File>: Character string (with quotes)
Name and full path of XML file to create. The file is replaced by the new file if it already exists.
<Options>: Optional Integer constant
Configures the XML file to create.
taWithInvisibleColumnsAlso exports the invisible control columns.
Versions 22 and later
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
New in version 22
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
taColumnDisplayedOrderExports the columns according to the order of columns currently displayed in the control (and not according to the order of columns defined in the editor).
WEBDEV - Server code This constant is not available.
taSelectedLinesExports the selected rows only (all the rows are exported by default).
taNoTitleOnly the data is copied into the file.
taNoTotalDoes not export:
  • the rows containing totals, mean and automatic count (these rows are exported by default).
  • Versions 22 and later
    WINDEV the rows containing custom calculations (these rows are exported by default).
    New in version 22
    WINDEV the rows containing custom calculations (these rows are exported by default).
    WINDEV the rows containing custom calculations (these rows are exported by default).
WEBDEV - Server code This constant is not available.
taNoXSLThe style sheet (".XSL" file) is not created.
taColumnsTitles
(default value)
The title of columns is inserted into the file.
<Start Row>: Optional integer
Number of the row where the export will start.
If this parameter is not specified, the start row is the first row of control.
<End Row>: Optional integer
Number of the row where the export will end.
If this parameter is not specified, the end row is the last row of control.
Remarks

Use conditions

TableToXML can be used on:
  • a browsing or memory control.
  • a single-selection or multi-selection control.
WINDEVWEBDEV - Server codeReports and QueriesAjaxUser code (UMC)

Binary Memo column (image)

For the Binary Memo columns, the XML file contains an empty string.

Limit

The merged columns are ignored.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230std.dll
Linux wd230std.so
Minimum required version
  • Version 9
This page is also available for…
Comments
GERAR XML DE UMA TABELA
sFile is string

// Opens the file picker
sFile = fSelect("", "", "Select a file...", "xml" + TAB + "*.xml", "*.xml", fselCreate + fselExist)


IF sFile <> "" THEN TableToXML(TABLE_descricao, sFile, taNoTitle)

// BLOG COM VIDEO E EXEMPLO
http://windevdesenvolvimento.blogspot.com.br/2017/07/aula-1207-windev-tabela-068-tabletoxml.html

https://www.youtube.com/watch?v=wFWdyUP8-uI


De matos
Jul. 12 2017