ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Tools / WDSQL
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
The result of a select query can be:
  • exported to a file (text, Excel, XML or Word),
  • printed.
Remark: 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 Print to print the query result.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2023

Send a report | Local help