## GdaTreeMgrSelect GdaTreeMgrSelect — A tree manager which creates a node for each row resulting from the execution of a SELECT statement |

## Stability Level

Stable, unless otherwise indicated

## Synopsis

    struct              GdaTreeMgrSelect;
    GdaTreeManager *    gda_tree_mgr_select_new             (GdaConnection *cnc,
                                                             GdaStatement *stmt,
                                                             GdaSet *params);

## Object Hierarchy

      GObject
       +----GdaTreeManager
             +----GdaTreeMgrSelect

## Properties

      "connection"               GdaConnection*        : Read / Write / Construct Only
      "params"                   GdaSet*               : Read / Write / Construct Only
      "statement"                GdaStatement*         : Read / Write / Construct Only

## Description

The GdaTreeMgrSelect is a GdaTreeManager object which executes a SELECT statement and creates a node for each row in the result.

The GdaConnection and SELECT GdaStatement to be used need to be specified when the object is created. If the SELECT statement to be used needs some parameters, then it is possible to give values to some of them when constructing the object, but not necessary.

If the SELECT statement needs some parameters which have not been provided during the construction, then these parameters will be fetched from the GdaTreeNode below which the nodes will be placed (using `gda_tree_node_fetch_attribute()`).

For each node created, an attribute is set for each column in the SELECT statement: the attribute name is the column name and the attribute value is the value if that column.

## Details

### struct GdaTreeMgrSelect

    struct GdaTreeMgrSelect;

### gda_tree_mgr_select_new ()

    GdaTreeManager *    gda_tree_mgr_select_new             (GdaConnection *cnc,
                                                             GdaStatement *stmt,
                                                             GdaSet *params);

Creates a new GdaTreeMgrSelect object which will add one tree node for each row in the GdaDataModel resulting from the execution of `stmt`.

`cnc` : | a GdaConnection object
`stmt` : | a GdaStatement object representing a SELECT statement
`params` : | a GdaSet object representing fixed parameters which are to be used when executing `stmt`
Returns : | a new GdaTreeManager object. [transfer full]

Since 4.2

## Property Details

### The `"connection"` property

      "connection"               GdaConnection*        : Read / Write / Construct Only

Connection to use.

### The `"params"` property

      "params"                   GdaSet*               : Read / Write / Construct Only

Parameters for the SELECT statement.

### The `"statement"` property

      "statement"                GdaStatement*         : Read / Write / Construct Only

SELECT statement.