create_sql: called by many functions from several db packages to convert...

In andybeet/dbutils: Utility package for db connectivity and functionality

called by many functions from several db packages to convert passed arguments to sql statements

Description

utility function to create a SQL statement based on passed arguments

Usage

create_sql(dataName, fieldName, fieldName2, dataType, defaultSqlStatement)

Arguments

dataName	Character or numeric. value of argument passed
fieldName	Character. Database fieldname name which has value = dataName
fieldName2	Character. Alternative field name for string values of dataName
dataType	Character. Formatting for the dataName in the database
defaultSqlStatement	String. Select statement. (eg. "Select * from db")

Value

String. SQL statement

Examples

## Not run: 
create_sql(dataName = "all",fieldName="svspp", fieldname2= "comname",
 dataType = "%03d",defaultSqlStatement="select * from svdbs.svspecies_list")

## End(Not run)

andybeet/dbutils documentation built on March 15, 2024, 4:43 p.m.