R/project_hours_update_string.R

Defines functions update_string

update_string<-function(val,user,proj,task,yr,mnth,wk){
    paste0('UPDATE projecthours set hours = ',
           val,
           ' where user = ',
           shQuote(user),
           ' AND project = ',
           shQuote(proj),
           ' AND task = ',
           shQuote(task),
           ' AND  year = ',
           yr,
           ' AND month = ',
           mnth, 
           ' and week =',
           wk,
           ';')
}
JARS3N/LiveLongAndProsper documentation built on June 21, 2020, 12:49 p.m.