ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Description of queries
  • Overview
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
Description window of query (insert, update or delete) or description window of a query in SQL code
Overview
The description window of a query (insert, update or delete) or the description window of a query in SQL code is used to:
  • find out and/or modify the name and caption of the query.
  • specify whether the SQL commands used must be checked (or not) by the HFSQL engine ("Run with hQueryWithoutCorrection in test mode".
  • specify the connection used during the test of the query.
  • find out and/or modify the values to insert or to modify in the query result (insert query or update query).
  • find out and/or modify the selection conditions (update query or delete query).
  • find out and/or modify the sequence of selection conditions (update query or delete query).
  • ...
Reports & Queries cannot be used to create insert queries, update queries or delete queries.
This description window is displayed:
  • when creating an Insert query, an Update query or a Delete query.
    Reminder: To create a query:
    • Click in the quick access buttons.
    • The new element window appears: click "Queries".
  • from a query found in the query editor ("Query description" from the popup menu of the query).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/08/2023

Send a report | Local help