|
|
|
|
|
|
|
|
|
|
Description window of query (insert, update or delete) or description window of a query in SQL code
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).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|