get_query.chMDB

get_query.chTKCat

get_query

Facilitate the management of data from knowledge
resources that are frequently used alone or together
in research environments.
In 'TKCat', knowledge resources are manipulated as modeled database (MDB)
objects. These objects provide access to the data tables along with a general
description of the resource and a detail data model documenting the
tables, their fields and their relationships.
These MDBs are then gathered in catalogs that can be easily
explored an shared.
Finally, 'TKCat' provides tools to easily subset, filter and combine MDBs and
create new catalogs suited for specific needs.

Patrice Godard

TKCat

Tailored Knowledge Catalog

get_query.chMDB function

<dl><dt>x</dt>
<dd>an object with a database connection</dd>
<dt>query</dt>
<dd>the SQL query</dd>
<dt>autoalias</dt>
<dd>Change this parameter only if you know what you're doing.
if TRUE, make relevant alias to query the chMDB
using the table names from the data model. If FALSE, the user must know the
table instance name in the remote database. By default, autoalias is set
to TRUE when using a non-current instance of the database.</dd>
<dt>...</dt>
<dd>method specific parameters</dd></dl>

Arguments

Get SQL query — get_query.chMDB

<dl>

<dt>x</dt>
<dd>an object with a database connection</dd>


<dt>query</dt>
<dd>the SQL query</dd>


<dt>autoalias</dt>
<dd>Change this parameter only if you know what you're doing.
if TRUE, make relevant alias to query the chMDB
using the table names from the data model. If FALSE, the user must know the
table instance name in the remote database. By default, autoalias is set
to TRUE when using a non-current instance of the database.</dd>


<dt>...</dt>
<dd>method specific parameters</dd>

</dl>

get_query.chMDB: Get SQL query

Description

Usage

Value

Arguments