On Tue, Nov 8, 2011 at 1:04 PM, Ben quant wrote:
> 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.nam
On Tue, Nov 8, 2011 at 11:43 AM, Ben quant 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 primar
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 !dbPreExi
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 betw
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 looki
5 matches
Mail list logo
