[R-sig-DB] RODBC sqlSave to table with computed column

Prof Brian Ripley r|p|ey @end|ng |rom @t@t@@ox@@c@uk
Sat May 26 11:42:31 CEST 2012


On 25/05/2012 21:52, Mortensen, Mikael - Marketing wrote:
> Hello. Does sqlSave support appending to a table with a computed column?

Depends what you mean.

> In my attempt, RODBC will not allow the append because I have "missing columns in 'data'"

No attempt was shown.

> If I create a column in my dataframe as a place holder for the computed column in the table and then try to append the data RStudio experiences an unhandled exception and crashes.
>
> Thanks for any advice you might have.
>
> Mikael
>
> 	[[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db

First, follow the posting guide at 
http://www.r-project.org/posting-guide.html .

Second, this is a subscribers-only list, so subscribe before posting the 
missing information .....


-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-sig-DB mailing list