Because I don't know anything about sqldf. :)

Here is what happens, but I"m sure it is happening because I didn't read
the manual yet:

> s <- sqldf('create table r.dat("id" int primary key,"val" int)')
Error in ls(envir = envir, all.names = private) :
  invalid 'envir' argument
Error in !dbPreExists : invalid argument type

ben

On Tue, Nov 8, 2011 at 10:41 AM, jim holtman <jholtman@gmail.com> wrote:

> Why not just send it in as is.  I use SQLite (via sqldf) and here is
> the way I write my SQL statements:
>
>    inRange <- sqldf('
>        select t.*
>                , r.start
>                , r.end
>            from total t, commRange r
>            where t.comm = r.comm and
>                t.loc between r.start and r.end and
>                t.loc != t.new
>        ')
>
> On Tue, Nov 8, 2011 at 11:43 AM, Ben quant <ccquant@gmail.com> wrote:
> > Hello,
> >
> > I'm using package RpgSQL. Is there a better way to create a multi-line
> > query/character string? I'm looking for less to type and readability.
> >
> > This is not very readable for large queries:
> > s <-  'create table r.BOD("id" int primary key,"name" varchar(12))'
> >
> > I write a lot of code, so I'm looking to type less than this, but it is
> > more readable from and SQL standpoint:
> > s <- gsub("\n", "", 'create table r.BOD(
> > "id" int primary key
> > ,"name" varchar(12))
> > ')
> >
> > How it is used:
> > dbSendUpdate(con, s)
> >
> > Regards,
> >
> > Ben
> >
> >        [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@r-project.org 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.
> >
>
>
>
> --
> Jim Holtman
> Data Munger Guru
>
> What is the problem that you are trying to solve?
> Tell me what you want to do, not how you want to do it.
>

	[[alternative HTML version deleted]]

