ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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").
Note: The result can also be 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: The result is displayed in table form:
  • Find a record: click on the icon and enter the first letters of the value you're looking for.
  • Sort records by field: click on the header of the column you wish to sort.
Running a select query in form mode

Overview

When executing a selection query in form mode, the result of the query is presented in the form of forms: each item in the record is displayed as a whole, and it is possible to move from one form to another (using the buttons, ...).
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: 09/21/2024

Send a report | Local help