PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Exporting the result of a select query
  • Exporting the result of a select query to a text file
  • Exporting the result of a select query to a Excel, Word or XML
  • Printing the result of a select query
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
Overview
The result of a select query can be:
  • exported to a file (text, Excel, XML or Word),
  • printed.
Note: For the following operations, we consider that the query result is displayed in WDSQL.
Exporting the result of a select query

Exporting the result of a select query to a text file

To export the result of a select query to a text file:
  1. Click the "Export" button. The window for selecting the text file is displayed.
  2. Specify the name and location of text file (".TXT" extension by default).
  3. Choose the type of separator used between the different items of each record ("Type" option):
    • Separator: Tabulation: The items will be separated by tabs.
    • Separator: Semicolon: The items will be separated by semicolons.
  4. Validate. The records found in the query result are automatically exported to the text file.

Exporting the result of a select query to a Excel, Word or XML

To export the result of a select query to Excel, Word or XML:
  1. Right-click the table containing the query result.
  2. Select the requested export mode: Word, Excel or XML.
  3. Specify the name of export file and validate.
Printing the result of a select query
To print the result of a select query:
  1. Click the "Print" button. The window for selecting the items to print is displayed.
  2. Specify the items to print and validate. The query result is displayed in a print preview.
  3. Click to print the query result.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment