search for: dataform

Displaying 1 result from an estimated 1 matches for "dataform".

Did you mean: datafarm
2012 Oct 26
1
Package RODBC sqlQueries
...think my syntax, particularly with respect to my WHERE statement, is off but I can't find any documentation as to why. When I run a query from within the Access2007 database, it looks like this: SELECT tblDataFieldRawSiteVisit.* FROM tblDataFieldRawSiteVisit WHERE (((tblDataFieldRawSiteVisit.dataForm)="Oyster Transition Plan Site Mapping Detail")); After inserting that (verbatim) into my R code like this: testData = sqlQuery(db, SELECT tblDataFieldRawSiteVisit.* FROM tblDataFieldRawSiteVisit WHERE (((tblDataFieldRawSiteVisit.dataForm)="Oyster Transition Plan Site Mapping Detail...