PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • 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 a HFSQL data file
  • Printing the result
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
Result of a query in test mode
Overview
After its execution in test mode (see 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 into the clipboard.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
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") from the popup 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" from the popup menu (right mouse click) of the query result. The XML file selection window 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") from the popup 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 a HFSQL data file
For the next operation, we consider that the query result is displayed.
To export the query result to a HFSQL data file:
  1. Click the "Export to a HyperFileSQL file" button or select "Export into a HyperFileSQL file" from the popup menu (right mouse click) of the query result. The window for selecting the HFSQL file is displayed.Click the "Export to a HFSQL file" button or select "Export into a HFSQL file" from the popup 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" from the popup menu (right mouse 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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment