makeSQLTable: Generate a table from a SQL query

In c-hill-mdrc/QCmemo: PSE QC Memo Helper Functions

Description

The function makeSQLTable accepts a SQL query and displays the results in a table.

Usage

makeSQLTable(connection = con, query)

Arguments

connection	A DBIConnection object, as returned by dbConnect.
query	A character string containing a SQL query.

Value

A flextable object.

Note

The QC memo template contains a chunk of code, just after the call to loadSASdf(), that automatically loads all the Step 1 and Step 2 datasets into a SQL database so that they can be accessed by queries. For more information, see dbWriteTable.

c-hill-mdrc/QCmemo documentation built on July 25, 2020, 12:48 a.m.