similar to: ODBC database access package

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael

Sorry, I was commenting on the previous windows version (version file says 0.5a) (the first one which ran under RW.1.0.0) I have Win NT 4.0 Service pack 5 and R is > version _ platform Windows arch x86 os Win32 system x86, Win32 status major 1 minor 0.0 year 2000 month February day 29 language R > -----Original Message----- > From: Prof Brian

Spoetry is a book on S+ by Patrick Burns available on the net at http://www.seanet.com/~pburns/Spoetry/Spoetry.pdf Its about 439 pages with 16 chapters. You can read all about it at http://www.seanet.com/~pburns/Spoetry/ Michael Lapsley

Here is another of those 'is it a bug or am I using it wrong' questions: I'd be very grateful if someone could help. I am doing a lot of graphs for a thesis at the minute, many of which need (ideally) greek letters in xlab and ylab. This works: >plot(c(1,2,3,4),c(1,2,3,4),xlab=expression( alpha * "-1-m")) > This does not: >

Here is a nasty one: (0.65.1 on linux) > plot(c(1,2,3,4),c(2,4,6,8),log="Y") Segmentation fault (core dumped) [ml at athome ml]$ Seems the bug is in errorcall(). yes, I know the syntax is wrong, but it is an easy mistake to make and it is inconvenient to lose the work space at times. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at

Dear list, What is the correct approved way to abort a library install if the c fails to build? I am tarting up my odbc library, and I would like to stop the install process if the needed header files and libraries are not present on the system. Error messages flash past so fast that it is easy to miss their significance. Michael ---------------------------------- E-Mail: Michael Lapsley

Would anyone care to comment if this is the best solution to this problem? > trygrep <-function(x,y) + if(grep(x,y)) + print("yes") else + print("NO") > >trygrep("foo","bafoobar") [1] "yes" > > trygrep("foo","bar") Error in if (grep(x, y)) print("yes") else print("NO") : missing value

Dear R-helpers, I wonder if I could impose upon you for forther assistance, this time with dataframes: hopefully this will be of general interest, as I personally have found them hard to get to grips with. I was trying to transpose rows and cols and move col1 to the names. Then all sorts of things go wrong. Although the end result looks the same, page() shows the structure to be quite

Can anyone give advice how to interactively exchange data between R and SQL-Databases like DB2, ORACLE, MS-SQL-Server ? If the answer is: 'currently not', this would be information for me as well. I will summarize to the list. Best regards -- Dr. Jens Oehlschl?gel-Akiyoshi MD FACTORY GmbH Bayerstrasse 21 80335 M?nchen Tel.: 089 545 28-27 Fax.: 089 545 28-10 http://www.mdfactory.de

Dear R team / R helpers / R users , I downloaded R-1.0.0 to install it but I am currently facing the following problem : Installation of packages. Here is the output I had while trying to install RmSQL : ------------- > R INSTALL -l /software/R-1.0.0/library/ /software/archive/R/RmSQL_0.2-1.tar.gz Installing package `RmSQL' ... libs RmSQL.c:7: msql.h: No such file or directory make:

Dear developers, I wonder would you consider making a save to a graphics file format (as opposed to ps)? What prompts this is that we have just finished my wife's thesis using R heavily for stats and graphs. The combination of latex, bibtex and R generated .eps worked a treat and we were very pleased with both the final outcome and the efficiency of gernerating it, especially when all the

Hi All, I am trying to copy portions of tables from one SQL database to another, using sqlCopy in the RODBC package. RemoteChannel = connection to remote database LocalChannel = connection to local database LocalTable = table in my local database to receive data from the remote database query <- select query in SQL sqlCopy(RemoteChannel, query, "LocalTable",

Hi, I am wondering if anyone has had experience w/the R database packages: RMySQL, RODBC, RPgSQL, and/or RmSQL, and if so, if you have any recommendations to make. We have some large tables we would like to store -- something like 5-10 columns by 3.5 mil rows (or maybe 7 mil rows). thanks, Natalie Hawkins Statistical Research Associate FHCRC/Scharp

Hi All: Package TSERIES is stated to depend on MVA. However, there is no MVA package to be found under the list of package sources. Best wishes, ANDREW tseries: Package for time series analysis Package for time series analysis with emphasis on non-linear and non-stationary modelling Version: 0.7-6 Depends: ts, mva, quadprog Date: 2001-08-27 Author: Compiled by Adrian

Estimado Patricio Vireri No mire Rmysql hoy pero por esas cosas de la vida decidieron no compilarlo en windows, hay varias alternativas, pero particularmente no use ninguna. MariaDB ahora tiene grafos, por si le sirve. Si compilo Rmysql no es un principiante, entonces pregunta de principiante ¿si solo usa odbc? Le pregunto esto porque cuándo yo usaba mac compre a una empresa " conexión

Hi Michael, Here is the result of my first testing: (0) Dr. Watson Sorry, I should have given a more precise description: by default in R exists a function with the name 'table', if you use this name as in odbcPrimaryKeys(0, table) a Dr. Watson occurs, because table does not give a table name. However, it is always a good idea to prevent Dr. Watsons, even if it is triggered by a

Is it possible to access data stored in microsoft access databases using R for windows or Linux? Thanks, Joel -- *************************** jallen at students.cas.unt.edu University of North Texas -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help",

Hi all, I use a function update.packages to update all packages in my R instalation. But I need compare one by one packages to discovery new packages. My question is: Exist in R any function that compare all installed packages in my R and all packages available in CRAN and return a list of the new packages (ie packages that I dont have im my installation) and automatic download and install

======================================================================= Simple CRAN packages which do not compile without modifications (all others do) ======================================================================= -- akima /usr/bin/ld: multiple definitions of symbol _idlc_ -- fracdiff /usr/bin/ld: multiple definitions of symbol _gammfd_ (and others) -- odesolve --

R is not for Relational, but could be... I was musing on data.frames when I decided what I needed was a SQL like 'select' statement. Before I get involved in writing something like that, has anyone else written anything that allows a relational like algebra on data.frames? Thanks, John Carter EMail: ece at dwaf-hri.pwv.gov.za Telephone : 27-12-808-0374x194 Fax:-