Displaying 1 result from an estimated 1 matches for "df_demandpatternmaster".
2010 Feb 10
0
RODBC Update image file into a MS-SQL database table
...as a binary vector
3. sqlUpdate
My code:
pngfile <- file(<filename>, "rb")
N <- 1e6
repeat{
pngfilecontents <- readBin(pngfile, what="raw", n=N)
if(length(pngfilecontents) == N) N <- 5 * N else break
}
close(pngfile)
#There is a table df_DemandPatternMaster in the database with primary
key DemandPatternID, with appropriate record in place with NULL value in
pngFile field.
update.query <- "update df_DemandPatternMaster set "
update.query <- paste( update.query, " pngFile = '",
serialize(pngfilecontents, NULL) , &q...