Table, List Box and Combo Box controls bound to queries

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control / Data-bound Table

Overview
Table control based on an independent query (without parameters)
Principle
Using the HCancelDeclaration/HFreeQuery functions
Refreshing the query content
Table control based on an embedded query (without parameters)
Principle
Refreshing the query content
Table control based on a query with parameters (independent or embedded query)
Principle
Passing parameters to the query: notation .
Special cases: initialization of a Table field or use of TableDisplay without the taRéExécuteRequête constant
Special case: using the TableDisplay function with the constant taRéExécuteRequête

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Table, List Box and Combo Box controls bound to queries

Not available with this kind of connection

Overview

A Table, List Box or Combo Box control can be used to display the content of a data file or query.

A Table, List Box or Combo Box control can be bound to:

an independent query. This query already exists in the project: select this query among the queries of your project.
an query integrated with the field: this query will be created in the Table (List or Combo) field creation wizard.. This query will be available for this control only and it will be saved with the window (or with the page) that uses it. In this case, the window (or the page) contains all the necessary elements.
a query parameterized A parameterized query: this query (independent or integrated) requires parameters to run and display the result in the Table, List or Combo field.

Remark: This help page describes the case of Table fields, but the operation is identical for List and Combo fields.

Table control based on an independent query (without parameters)

Principle

A Table control based on an independent query (without parameters) displays the records from this query.

By default, the query is run and loaded in memory during its first use. The result of a query used in a Table control based on a data file remains in memory when the associated window is closed. This query will not be re-run when it is re-used.

To re-run this query, you must use:

the HFreeQuery function.
the HCancelDeclaration function.
TableDisplay (or ListDisplay for a List Box or Combo Box control).

Using the HCancelDeclaration/HFreeQuery functions

If HCancelDeclaration is not called, the query will not be executed next time the Table control is initialized (next time the window is open, for example). The data retrieved during the last query execution will be used. If the Table control is based on a query with parameters, see "Table control based on a query with parameters (embedded or not)".
If HCancelDeclaration is called, the query will be executed next time the Table control is initialized (next time the window is open, for example).

Note: The HFreeQuery function is based on the HCancelDeclaration function.. Their operating mode is identical.

Example:

// Closing code of the window
HCancelDeclaration(TABLE_MyTable.BrowsedFile)

Refreshing the query content

To force the re-execution of the query, use TableDisplay (or ListDisplay for a List Box or Combo Box control) associated with the taReExecuteQuery constant.

Table control based on an embedded query (without parameters)

Principle

A Table control based on an embedded query (without parameters) displays the records from this query.

By default, the query is run and loaded in memory when the Table control is displayed. The result of an embedded query used in a Table control based on a data file is automatically cleared from memory when closing the associated window. This query will be re-run when it is re-used.

Refreshing the query content

To force the re-execution of the query, use TableDisplay (or ListDisplay for a List Box or Combo Box control) associated with the taReExecuteQuery constant.

Table control based on a query with parameters (independent or embedded query)

Principle

When a Table control is bound to a query with parameters (independent or embedded), the parameters must be passed to the query before it is executed.

If these parameters are not specified before the first execution of the query, the query will not be run and the Table control will remain empty.

To pass parameters to the query, you can:

specify the parameters one by one by using:
- the following notation:
  <Query Name>.<Name of Parameter1> = xxx
  <Query Name>.<Name of Parameter2> = xxx
  <Query Name>.<Name of Parameter3> = xxx
  
  In this case, the query is automatically run when initializing the Table control.
- the MySource keyword:
  MySource.<Name of Parameter1> = xxx
  MySource.<Name of Parameter2> = xxx
  MySource.<Name of Parameter3> = xxx
- the indirection:
  {"<Query Name>.<Name of Parameter 1>"} = xxx
  or
  {"<Query Name>"}.<Name of Parameter 1> = xxx
specify the parameters at once with HExecuteQuery.

This method for passing parameters can be used in the declaration code of global variables of the window or in the initialization code of Table control for example.

To take these parameters into account, you must use TableDisplay (or ListDisplay for a List Box or Combo Box control).

To re-execute the query with different parameters, you just have to specify these new parameters, and then use TableDisplay (or ListDisplay for a List Box or Combo Box control).

Passing parameters to the query: notation <Nom Requête>.<Nom Paramètre1>

All the query parameters do not necessarily have to be specified. The query conditions that use unspecified parameters will be ignored. For more details, see Methods for passing parameters to a query.

Note: If no query parameters are specified before the first execution, the query will not be executed.. The Table control associated with the query will remain empty.

Attention: Each time the query is executed, all query parameters are reset.. The values that have been used beforehand are not stored. You must redefine the query parameters so that it can be run again.

Special cases: initialization of a Table field or use of TableDisplay without the taRéExécuteRequête constant

If no query parameter was modified since the last query execution, the query will not be re-run. The Table control will display the records corresponding to the last execution of the query.
Once the query parameters are modified, TableDisplay (or ListDisplay for a List Box or Combo Box control) is used to re-execute the query. The Table control displays all the records corresponding to the specified parameters.

Special case: using the TableDisplay function with the constant taRéExécuteRequête

To force a query to execute, use TableDisplay (or ListDisplay for a List Box or Combo Box) with the taReExecuteQuery constant.

Reminder: As the query parameter structure is re-initialized each time the query is run, don't forget to re-define the desired parameters before using this function.