[Fwd: [R] RPgSQL db.execute() command]

[David Meyer]

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._