[Fwd: [R] RPgSQL db.execute() command]
david.meyer at ci.tuwien.ac.at
Wed Jul 4 12:01:01 CEST 2001
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)
> > 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
More information about the R-help