[R] sqlFetch doesn't read the whole objects.

[Jeff Newmiller]

Not reproducible, not even close. Other than saying 600 is not a magic limit in R, not much help can be given.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

happyji <ejo at bcm.edu> wrote:

>Hi everyone,
>
>I connected a data in FileMaker server with odbcConnect.
>When I call the data "CANCERS" using sqlFetch, it looks okay. 
>However, the number of obs was different with the actual number.
>If I read the same data from Microsoft Access, there are 656 obs. in it
>but
>srt() shows me 600 obs.
>
>Does anyone know why this happened and how to read all obs. from R?
>
>Thank you in advance.
>
>EJ
>
>
>> psb<-odbcConnect("PSB",uid="XXX",pwd="XXXXXXX")
>> cancers<-sqlFetch(psb,"CANCERS")
>> str(cancers)
>'data.frame':   600 obs. of  5 variables:
> $ study_id   : int  7 152 11 12 3 14 16 22 23 24 ...
>$ cancer_type: Factor w/ 121 levels " Breast cancer ",..: 15 24 65 NA
>45 16
>73 46 23 66 ...
>$ cancer_age : Factor w/ 70 levels "17","1968","1983",..: NA 14 31 NA
>58 NA
>NA 38 NA 35 ...
> $ cancer_recs: num  656 656 656 656 656 656 656 656 656 656 ...
>$ cancer_year: Factor w/ 43 levels "1/2003","12/05",..: 34 34 NA 34 NA
>34
>26 NA 34 34 ...
>
>
>
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/sqlFetch-doesn-t-read-the-whole-objects-tp4647943.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>R-help at r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.