David Meyer wrote:>
> Evan Zane Macosko wrote:
> >
> > Hello everyone.
> >
> > I am using the RPgSQL package, and am having some trouble using the
> > db.execute command. I successfully connect to my database, and issue
a
> > simple SQL query, like db.execute("Select * from c0000075"),
where
> > c0000075 is a table in my database. But when I try to fetch from the
> > buffer, R tells me that the table consists of just a null value! Any
> > suggestions?
>
> The db.execute()-function has a parameter "clear" with default
"T"rue,
> which causes the buffer to be cleared after command execution. Simply
> set it to "F"alse.
>
> (Yes, it's not very intuitive; I ignore the reasons which might have
> induced the package writer to do this)
>
> -d
>
> >
> > thanks!
> > Evan Macosko
> >
> >
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> > r-help mailing list -- Read
http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> > Send "info", "help", or "[un]subscribe"
> > (in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
> >
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>
> --
> Mag. David Meyer Wiedner Hauptstrasse 8-10
> Vienna University of Technology A-1040 Vienna/AUSTRIA
> Department for Statistics, Probability Tel.: (+431) 58801/10772
> Theory and Actuarial Mathematics mail: david.meyer at
ci.tuwien.ac.at
--
Mag. David Meyer Wiedner Hauptstrasse 8-10
Vienna University of Technology A-1040 Vienna/AUSTRIA
Department for Statistics, Probability Tel.: (+431) 58801/10772
Theory and Actuarial Mathematics mail: david.meyer at ci.tuwien.ac.at
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
