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...