






Hello,

I contact you after having unsuccessfully asked my question to R mailing list. 

I use the package RODBC to connect to a MS-SQL server. 
I am able to getQuery from the database.

I
am now studying the sqlSave some data into the database. Unfortunetly,
I meet some issues relating to the format of the data that arrives into
the database. 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","varchar(50)","numeric(20,8)")
> sqlSave(channel, DF, tablename="essai_global", rownames=FALSE, oldstyle=FALSE)



I have the following resturn:

Warning message:
In sqlSave(channel, DF, tablename = "essai_global", rownames = FALSE,  :
  argument 'varTypes' has no names and will be ignored



and the types are still wrong..

How can I use the varTypes??? I have read the documentation, but I dd not manage to find out.

Thank you very much

Wapita
_________________________________________________________________

r  !  Téléchargez-le maintenant ! 

	[[alternative HTML version deleted]]


