Displaying 1 result from an estimated 1 matches for "strq".
Did you mean:
str
2010 Apr 02
2
How to save a model in DB and retrieve It
...t;'", gsub("'", "''", rawToChar(modX)), "'", sep = ''),
")", sep = "") )
# Up to this it is working correctly,
# in DB I have the "modX" variable
# Problem arise retrieving data and 64kb limit:
strQ <- "
SELECT CONVERT(varchar(max), tModel) AS tModel
FROM GRT.GeneratorsModels
WHERE (cGeneratorID = 1)
"
x <- sqlQuery(Channel, strQ, stringsAsFactors = F, believeNRows = FALSE)
x <- sqlQuery(Channel, strQ, stringsAsFactors = F, believeNRows = FALSE) #read e...