ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Tools / WDSQL
  • Overview
  • Running a select query in table mode
  • Overview
  • Running a select query in table mode:
  • Running a select query in form mode
  • Overview
  • Running a select query in form mode
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
WDSQL is used to run all the SQL queries created by WDSQL.
When running:Result:
  • A select query
The query result can be viewed:
  • in table mode ( or "Run .. Run in table mode").
  • in form mode ( or "Run .. Run in form mode").
Remark: The result can also be exported and/or printed.
  • An insert query ( or ).
The records are directly added.
  • An update query ( or ).
The records are directly modified.
  • A delete query ( or ).
The records are directly deleted.
Running a select query in table mode

Overview

When running a select query in table mode, the query result is displayed in a table. This table allows you to have an overall view of the query result.
For example:

Running a select query in table mode:

To run a select query in table mode:
  1. Load (if necessary) the query to run in WDSQL ("File .. Load a query" or ).
  2. Select "Execution .. Run in table mode" (or click ). The query result is displayed in a table. This result can be exported and/or printed.
Remark: Viewing the result in table mode:
  • Finding a record: click and type the first letters of the sought value.
  • Sorting the records according to an item: click the header of column to sort.
Running a select query in form mode

Overview

When running a select query in form mode, the query result is displayed in forms: each record item is entirely viewed and you can move from a form to another one (with , ...).
For example:

Running a select query in form mode

To run a select query in form mode:
  1. Load (if necessary) the query to run in WDSQL ("File .. Load a query" or ).
  2. Select "Execution .. Run in form mode" (or click ). The query result is displayed in a form. This result can be exported and/or printed.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/07/2023

Send a report | Local help