gmDatabase (version 0.5.1)

gmJoinAVariable: Creating the join R representation of a SQL JOIN

Description

Queries the variable types of the variables, which shall be joined, and creates the R presentation of an SQL JOIN.

Usage

gmJoinAVariable(sel,var,nameUse=var,bind=TRUE,db=getOption("gmDB"),selID=attr(sel,"id"))
gmJoinADollarExpr(sel,expr,nameUse,envir,bind=TRUE,db=getOption("gmDB"),
                    gmNameVarID=getGmNameVarID(db))

Value

For gmJoinADollarExpression the new selection expression, where the dollar expression is added.

Arguments

sel

The selection statement in R representation.

var

R expression of an SQL query.

nameUse

the names used for the variables

envir

defines the environment used for evaluation of expr

bind

should the variable be bound

db

The database connection to the material analysis database.

selID

The ID attribute of the selection.

expr

An R expression.

gmNameVarID

The gmVarID of gmName from the database.

Author

K. Gerald van den Boogaart, S. Matos Camacho

Details

Internals functions for constructing a SQL statement.