Displaying 2 results from an estimated 2 matches for "essai_global".
2009 Jul 08
0
RODBC and sqlSave issue
...se. I have three columns. The first one should be in the
MS-SQL format "datetime". The second one in the MS-SQL format
"varchar(50)", and the third one in the MS-SQl format "numeric(20,8)".
I use the following command line:
> sqlSave(channel, DF, tablename="essai_global", rownames=FALSE, oldstyle=FALSE)
The data is indeed send to the database. But the types are wrong (varchar(255) pour les trois colonnes.)
I have then tried to use the varTypes argument, but I do not manage to use it.
If I use the following command lines:
> varTypes=c("datetime"...
2009 Jul 09
2
How to Populate List
...se. I have three columns. The first one should be in the
MS-SQL format "datetime". The second one in the MS-SQL format
"varchar(50)", and the third one in the MS-SQl format "numeric(20,8)".
I use the following command line:
> sqlSave(channel, DF, tablename="essai_global", rownames=FALSE, oldstyle=FALSE)
The data is indeed send to the database. But the types are wrong (varchar(255) pour les trois colonnes.)
I have then tried to use the varTypes argument, but I do not manage to use it.
If I use the following command lines:
> varTypes=c("datetime"...