Displaying 3 results from an estimated 3 matches for "sqlfetchmore".
2004 Sep 15
0
RODBC 1.1-1
...based on an idea of Matthew Dowle).
* The C code calls SQLExecuteDirect rather than SQLExecute and
does not call SQLCloseCursor, based on a problem report from
Matthew Dowle using MS SQLServer. Repeated calls to
sqlGetResults now work.
* New function sqlFetchMore.
* Table names in Access with embedded spaces are mapped to the
[name space] form which Access requires.
* Table creation no longer removes _ from column names.
* New functions get/setSqlTypeInfo and the typeInfo argument to
sqlSave allow users to spec...
2004 Sep 15
0
RODBC 1.1-1
...based on an idea of Matthew Dowle).
* The C code calls SQLExecuteDirect rather than SQLExecute and
does not call SQLCloseCursor, based on a problem report from
Matthew Dowle using MS SQLServer. Repeated calls to
sqlGetResults now work.
* New function sqlFetchMore.
* Table names in Access with embedded spaces are mapped to the
[name space] form which Access requires.
* Table creation no longer removes _ from column names.
* New functions get/setSqlTypeInfo and the typeInfo argument to
sqlSave allow users to spec...
2009 May 21
1
Error in importing table from SQL to R
...arge)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLarge' not found
NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE,
rownames = TRUE)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLarge' not found
NEWDATASQL3 <- sqlFetchMore(myconne, CampaignDataLarge, colnames = TRUE,
rownames = TRUE)
NEWDATASQL3
[1] -1
NEWDATASQL4 <- sqlQuery(myconne, "select * from CampaignDataLarge", errors =
TRUE, colnames = FALSE, rownames = TRUE)
NEWDATASQL4
[1] "[RODBC] ERROR: Could not SQLExecDirect"...