[R] sqlQuery

[Ernesto Jardim]

Navarre Sabine (stu) wrote:

>Hello,
> 
> 
>(sqlQuery(channel, "select * from......"))
> 
>I would like to know if it's possible to put a file name in the
>parameters of the function 'sqlQuery' instead of putting the query .
>If it's possible, what kind of extension for my file have I need?
> 
>That's for your help
> 
>Sabine 
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at 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
>  
>

I think you can just create a character vector with the sql string and 
call sqlQuery(chanel, myfile)

Regards

EJ