dbGetTable: get a table from a .pdResult file

In BenBruyneel/proteinDiscover: ProteinDiscover

get a table from a .pdResult file

Description

get a table from a .pdResult file

Usage

dbGetTable(
  db,
  tablename,
  columns = NA,
  filtering = " ",
  sortorder = NA,
  SQL = FALSE
)

Arguments

db	database access 'handle'
tablename	used to pass on the name of the table containing the data
columns	allows the selection of columns to take from the table, default = NA (all columns)
filtering	allows for " WHERE <expression>" additions to the SQL statement default = " " (no filtering). Note: always put a space (" ") before any statement
sortorder	allows for sorting of the selected columns, default = NA, (no sorting). Other valid value is a character character vector of columnNames to be used for sorting string (with "ASC" or "DESC" if needed)
SQL	allows the function to return the SQL query statement in stead of a data.frame

Value

a data.frame containing requested data from a database table or a character string specifying an SQL query

BenBruyneel/proteinDiscover documentation built on March 16, 2024, 4:36 p.m.