ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor
  • Overview
  • Exporting the result to a text file
  • Exporting the result to an XML file
  • Exporting the result to a spreadsheet file
  • Exporting the result to an HFSQL data file
  • Printing the result
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Result of a query in test mode
Overview
After its execution in test mode (see Running the test of a query), the result of the query can be:
  • exported to a text file (Word or Open Office).
  • exported to an XML file.
  • exported to a spreadsheet file (Excel or Open Office).
  • exported to a HFSQL data file.
  • printed.
A record found in the query result can also be copied to the clipboard.
Exporting the result to a text file
For the next operation, we consider that the query result is displayed.
To export the query result to a text file:
  1. Select "Export the table to Word" (or "Export the table to OpenOffice.org Writer") in the context menu (right mouse click) of the query result. The window for selecting the "RTF" file is displayed.
  2. Specify the name and location of the "RTF" file.
  3. Validate. The records found in the query result are automatically exported to the "RTF" file.
Exporting the result to an XML file
For the next operation, we consider that the query result is displayed.
To export the query result to an XML file:
  1. Select "Export the table to XML" in the context menu (right mouse click) of the query result. The window for selecting the XML file is displayed.
  2. Specify the name and location of the XML file.
  3. Validate. The records found in the query result are automatically exported to the XML file.
Exporting the result to a spreadsheet file
For the next operation, we consider that the query result is displayed.
To export the query result to an Excel file:
  1. Select "Export the table to Excel" (or "Export the table to OpenOffice.org Calc") in the context menu (right mouse click) of the query result. The window for selecting the "XLS" file is displayed.
  2. Specify the name and location of the "XLS" file.
  3. Validate. The records found in the query result are automatically exported to the "XLS" file.
Exporting the result to an HFSQL data file
For the next operation, we consider that the query result is displayed.
To export the query result to an HFSQL data file:
  1. Click the "Export to an HFSQL file" button or select "Export into an HFSQL file" in the context menu (right mouse click) of the query result. The window for selecting the HFSQL file is displayed.
  2. Specify the name and location of the HFSQL data file.
  3. Validate. The records found in the query result are automatically exported to the HFSQL data file. The result can be viewed with WDMap for example.
Printing the result
For the next operation, we consider that the query result is displayed.
To print the query result:
  1. Select "Print" in the context menu (right click) of the query result or click . The window for selecting the items to print is displayed.
  2. Indicate the items to print and validate.
  3. A print preview showing the query result is displayed.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/18/2024

Send a report | Local help