search for: sqlfetchmor

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

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

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