Displaying 1 result from an estimated 1 matches for "columnname1".
Did you mean:
columnname
2003 Feb 10
3
non-SQL sqlQuery error
...")
The puzzling thing is that the error does not seem to be like the usual
mispecified-SQL type that I normally
get when using sqlQuery(). I am not sure how to debug this problem,
since I can't really see what's going on
in the sqlQuery() internally.
My query includes a "SUM(ColumnName1) GROUP BY ColumnName2" construct,
and from trial and error, it seems
that this is the cause of the failure (at least removing it makes the
error go away).
I am using R1.6.2 and the RODBC package from
http://cran.r-project.org/bin/windows/contrib/PACKAGES.
Can anyone offer any clues?
Thanks...