labkey.deleteRows laurapas  2016-02-10 10:53
Status: Closed
 
Hi Jon,
Nope, labkey.deleteRows is not working. labkey.selectRows has always worked fine. I am using up to date packages and running from a Mac. Any ideas?

> todelete <- labkey.deleteRows(baseUrl="https://labkey-dev.roche.com:8443/labkey",
+ folderPath="/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results",
+ schemaName="lists",
+ queryName="QuaSAR_AuDIT",
+ toDelete=data.frame(Key=1,
+ stringsAsFactors = FALSE)
+ )
> todelete
$rowsAffected
[1] 1

$queryName
[1] "QuaSAR_AuDIT"

$schemaName
[1] "lists"

$containerPath
[1] "/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results"

$rows
list()

$command
[1] "delete"



> toselect <- labkey.selectRows(
+ baseUrl="https://labkey-dev.roche.com:8443/labkey",
+ folderPath="/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results",
+ schemaName="lists",
+ queryName="QuaSAR_AuDIT"
+ )
> str(toselect)
'data.frame':    3888 obs. of 14 variables: