pasteIdRestrictions: Paste equality restrictions to a SQL query

In talithafs/dzVis-Package: Data Visualization with Data Zoom

Description

Concatenates equality restrictions and an existing SQL query string

Usage

pasteIdRestrictions(query, restrictions, whereClause = FALSE,
  andClause = TRUE)

Arguments

query	A character value. Initial value of the query string. Restrictions will be pasted after it.
restrictions	A n x 2 matrix with n equality restrictions
whereClause	If set to TRUE, a 'where' clause is inserted before the restrictions. If set ot FALSE, an 'and' clause is inserted
andClause	If set to TRUE, 'and' clauses will join the restrictions. If set ot FALSE, 'or' clauses will join the restrictions.

Value

A character. The new query string.

talithafs/dzVis-Package documentation built on May 31, 2019, 2:54 a.m.