On 9/7/07, Gabor Grothendieck <[EMAIL PROTECTED]> wrote:
> Yes but delete does not return anything so its not useful. In the devel
> version of sqldf you can pass multiple command so try this using the
> builtin data frame BOD noting that the record with demand = 8.3 was
> removed:
>
> > library(sqldf)
> Loading required package: RSQLite
> Loading required package: DBI
> Loading required package: gsubfn
> Loading required package: proto
> > # overwrite with devel version of the sqldf.R file
> > source("http://sqldf.googlecode.com/svn/trunk/R/sqldf.R";)
> > sqldf(c("delete from BOD where demand = 8.3", "select * from BOD"))
> Time__1 demand
> 1 2 10.3
> 2 3 19.0
> 3 4 16.0
> 4 5 15.6
> 5 7 19.8
I see, Gabor, but I would expect as more natural to have
sqldf("delete from BOD where demand = 8.3")
working, with no second command.
Paul
> On 9/7/07, Paul Smith <[EMAIL PROTECTED]> wrote:
> > Dear All,
> >
> > Is sqldf equipped with delete queries? I have tried delete queries but
> > with no success.
> >
> > Thanks in advance,
> >
> > Paul
> >
> > ______________________________________________
> > R-help@stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
>
______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
