similar to: Summary: SQL-Interface

Displaying 20 results from an estimated 100 matches similar to: "Summary: SQL-Interface"

1999 Apr 19
1
math mode in box plots
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: >
1999 Oct 18
2
core dump
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
1999 Oct 13
1
dataframe transposition
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
1999 Oct 14
2
use of databases with R?
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",
1999 Oct 04
1
SQL-Interface
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
2000 Mar 08
0
RE: [R] RODBC
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
2000 Apr 01
1
Bug ? mine or ? in R core
Dear R Gurus, I would very much appreciate some help with this code snippit from my RODBC package. R crashes or exhibits bizarre behaviour when repeatedly fetching large numbers of rows. Examples: > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx 3rd
1999 Oct 22
0
on-line documentation (was AR models)
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
1999 Oct 16
1
ODBC database access package
I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,
1999 Nov 06
1
configure in libraries
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
1999 Oct 11
1
if(grep())
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
1999 Sep 30
6
Graphics output device
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
2000 Oct 03
1
Bug in RODBC ?
Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,
2000 Oct 03
1
Bug in RODBC ?
Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,
2005 Feb 24
2
sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)
Full_Name: David Whiting Version: 2.1.0 Under development (unstable) OS: linux Submission from: (NULL) (82.39.106.169) I have just upgraded from a previous version (2.0.0?) and found some of my code that used okay to run now gives an error. The function being called is sqlSave(). I am pretty sure (but not 100% certain) that the data frame I am trying to save has not changed. I am 100% sure that
2000 Feb 29
2
RODBC
Firstly can I add my congradulations to the R core team on the release of v1.0.0 and my thanks for all their hard work. To the subject of this message: does anyone have a binary version of Michael Lapsley's RODBC package built for win32 that they can distribute? I have a solution where I can use Perl ODBC functions to dump data to a text file for reading in to R, but I think the direct ODBC
2008 Mar 04
1
enum arguments not recognized
Ok, I''ve found a minor problem that I was able to fix, but I''m not sure if this is the right way to handle it, being new to swig and all. Basically, in wxDC.h, there''s a function declaration: void GradientFillLinear(const wxRect& rect, const wxColour& initialColour, const wxColour& destColour, wxDirection nDirection = wxEAST); The problem is
2006 Jul 26
2
RODBC on linux
Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended
2000 Mar 08
2
possible BUG with as.data.frame() and/or [.data.frame
Here is a possible BUG with as.data.frame() and/or [.data.frame which broke Michael Lapsleys RODBC-Code. Can anyone confirm it is a bug or a 'feature' of the prototype? tablename <- "abc" a <- as.data.frame(cbind("abc", 1:3)) b <- as.data.frame(cbind(tablename, 1:3)) # ok > a V1 V2 1 abc 1 2 abc 2 3 abc 3 # missing column name > b tablename 1
2011 Mar 07
2
How to reference a package in academical paper
Dear, I am now writing more formal "academical" paper, and would like to reference an R package. Do you have any recommendation how to do it? Taking for instance the RODBC package as an example, how would the reference look like? http://cran.r-project.org/web/packages/RODBC/index.html Thank you Jan [[alternative HTML version deleted]]