Several of you have kindly sent me examples of bugs in RODBC, but none of them reproduce on my systems. I am fairly sure I know what is happening, and that it is client-specific. (Do empty strings get returned as "", NULL or skipped?) Also, empty character fields were getting mapped to NA. There's a comment in the code that fields need to set to a null string, and that was only being done for the first row. If my diagnosis is right, I have a fix (and have simpilfied the code a lot en route). http://www.stats.ox.ac.uk/pub/bdr/RODBC/RODBC_0.7-2.tar.gz (source) http://www.stats.ox.ac.uk/pub/bdr/RODBC/RODBC.zip (Windows) I'd be grateful for confirmation (or otherwise). BTW, although I have altered the code to compile under R-devel, it does not work correctly for me as yet. -- Brian D. Ripley, ripley@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-devel 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-devel-request@stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._