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

[happyji]

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.