PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
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
Description window of a 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).
  • ...

Important

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 ("File .. New .. Query").when creating an Insert query, an Update query or a Delete query.
    Reminder: To create a query:
    • Click among the quick access buttons.
    • Click "Queries" in the wheel that is displayed. The window for creating a new element is displayed: click "Queries".
  • from a query found in the query editor ("Query description" from the popup menu of the query).
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment