search for: vartypes

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be created.* En este pdf https://cran.r-project.org/web/package...

...nd grab the data types (this will work even if the database has columns but is empty), then use this information when populating. In short, I do the following: library(RODBC) dbCon <- odbcConnect(db) tmp <- sqlColumns(dbCon, dbTable) ## this function grabs a bunch of info about the columns) varTypes <- as.character(tmp$TYPE_NAME) names(varTypes) <- as.character(tmp$COLUMN_NAME) sqlSave(dbCon, dataSet, dbTable, append=TRUE, rownames=FALSE, varTypes=varTypes) The "secret ingredient" here is varTypes : this is a named character vector of data types, as said in many other threads...

Buen dia Javier, muchas gracias por tu ayuda y el script compartido. Me va a servir como ayuda para seguir aprendiendo sobre RODBC pero no encuentro una solucion para este problema puntual de poder definir el tipo y ancho de las variables, q segun creo se hace con el argumento varTypes. Si alguien tien algun ejemplo donde haya usado la SqlSave y VarTypes, me sera de gran ayuda. Abrazo a todos 2017-07-12 15:33 GMT-03:00 Javier Marcuzzi <javier.ruben.marcuzzi en gmail.com> : > Estimado José Ramirez Costa > > > > Yo tengo un archivo donde guarde lo que reali...

...o a usarlo desde R, con el paquete RODBC. Mi problema puntual es que al crear una tabla en el servidor SQL a partir de un data frame en R (usando la funcion sqlSave) no puedo definir el tipo de variables que quiero usar en el data frame. Segun entiendo esto se deberia poder hacer con el parametro vartypes, pero hasta ahora solo he podido cargar un vector q dice el tipo de variables (varchar, int, o numeric) pero no he podido indicarle el ancho q tiene cad variable. Esto en SQL se escribiria algo asi: [ACTA] int, [APENAC] varchar(25), [PESONAC] numeric(4,0), Alguien uso vartypes de esta forma? Des...

I get error trying to run examples from 'svyby' help page (?svyby in package "Survey"): # code data(api) dclus1<-svydesign(id=~dnum, weights=~pw, data=apiclus1, fpc=~fpc) svyby(~api99, ~stype, dclus1, svymean) # error message > Error in match.arg(vartype, several.ok = TRUE) : unused argument(s) (several.ok ...) Is this a version problem? I'm running R

Hi, I’m using the svyby for total statistics, for example: svyby(~p_igov,~div_a,desenho_nps,svytotal,drop.empty.groups=TRUE,vartype =c("se","var","cvpct")) In the numerical variable p_igov (and others) I have many non responses but if I maintain the NA it doesn’t work. summary(base_nps$p_igov) Min. 1st Qu. Median Mean 3rd Qu. Max. NA's

Dear Tobias, I finally succeeded in exporting my dataframes from R into Access with this script: library(RODBC) canal <- odbcConnectAccess("D:/Floristique.mdb") sqlSave(channel=canal, dat=flore, tablename="Floristique", rownames=F, safer=F, fast=F, varTypes=c(dates="Date")) odbcClose(canal) My problem in exporting my dataframe "flore" seems to be closely linked with the name of the column of dates in my dataframe, which was formerly "date" and which I changed into "dates". Since my exporting worked (?). The...

Hi Justin, my class is a visitor pattern and I use accept method to go recursive in suboject in my AST. In locals I store AllocaInst pointer. void *visit(var1_init_decl_c *symbol) { llvm::Type *lType; varNames.clear(); varType = ""; symbol->var1_list->accept(*this); /* get a vector contains variable names */ symbol->spec_init->accept(*this); /* Store in

On Fri, Jan 11, 2013 at 8:20 AM, Manuele Conti <manuele.conti at sirius-es.it>wrote: > Hi Justin, > my class is a visitor pattern and I use accept method to go recursive in > suboject in my AST. > In locals I store AllocaInst pointer. > > > void *visit(var1_init_decl_c *symbol) { > llvm::Type *lType; > > varNames.clear(); > varType = "";

...rmat "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: War...

In response to a few private e-mails, here a summary of using Delphi, R-DCOM and R 2.2.0 1) As Earl Glynn noted ( http://finzi.psych.upenn.edu/R/Rhelp02a/archive/50705.html ), there were a few paths specific to my installation in http://www.menne-biomed.de/download/RDComDelphi.zip leading to path errors on compilation. Hopefully, this has been corrected in the new zip file. 2) Always check if

Hello, I would like to call a function that can take infinite time to be executed in some circumstances (which can not be easily detected). So, I would like that once the function is being executed for more than two seconds it is stopped. I have found documentation for timers but i did not found how to "kill" a function. Moreover, I would like not to change the function code (it should

Hi, i have big trouble with office 2007, powerpoint can't show flash objects this is the output of wineconsole: Code: rr:ole:apartment_getclassobject DllGetClassObject returned error 0x80004002 err:ole:CoGetClassObject no class object {d27cdb6e-ae6d-11cf-96b8-444553540000} could be created for context 0x3 err:ole:TLB_ReadTypeLib Loading of typelib

I downloaded asterisk-12.4.0 (asterisk-12-current.tar.gz, dated 10-JUL_2014) from http://downloads.asterisk.org/pub/telephony/asterisk/. The packaged configured OK. However, I'm getting a compile error: use of undeclared identifier 'pvt'. I've found similar reports for other versions (asterisk-11 and dongle; macports; a couple others), but nothing for 12.4. Any suggestions to

The Wine development release 1.6-rc4 is now available. What's new in this release (see below for details): - Bug fixes only, we are in code freeze. The source is available from the following locations: http://prdownloads.sourceforge.net/wine/wine-1.6-rc4.tar.bz2 http://mirrors.ibiblio.org/wine/source/1.6/wine-1.6-rc4.tar.bz2 Binary packages for various distributions will be available

Hello, After a (bad) first try some months ago, I'm trying again to use RODBC package instead of DBI+RMySQL packages to populate MySQL database. The main command is sqlSave(channel, data_df, tablename, append=T, rownames=FALSE, colnames=FALSE, fast=FALSE, varTypes=vartypes) where data_df is the data.frame I want to save and vartypes is obtained following the tip given here http://r.789695.n4.nabble.com/some-helpful-tips-on-using-RODBC-td2324503.html Useful Tips for RODBC Two columns have a bigint unsigned type. The first contains numbers with 11 figures (...

Happy 1999! I've been celebrating the holidays by (finally) getting to the port of our S+ NetCDF routines to R, which I'm trying to make into a library. At the moment, there are two issues I'd appreciate advice on: 1. Is support for mode "single" data planned anytime soon in R? A lot of our NetCDF files contain "single" data and having to coerce into

I tested also with a clean git source. Something wrong with ole32. Code: -fPIC -Wall -pipe -fno-strict-aliasing -Wdeclaration-after-statement -Wempty-body -Wstrict-prototypes -Wtype-limits -Wwrite-strings -fno-omit-frame-pointer -Wpointer-arith -Wlogical-op -I/usr/include/freetype2 -g -O2 -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=0 -o tmarshal_i.o tmarshal_i.c

Hello I have 2 datasets say Data1 and Data2 both are of different dimesions. Data1: 120 rows and 6 columns (Varname, Vartype, Labels, Description, ....) The column Varname has 120 rows which has variable names such id, age, gender,.....so on Data2: 12528 rows and 120 columns The column names in this case are V1, V2, ......... V120 (which are default names in R when we say head=F in read.csv)

you're not showing enough code. What does accept() do? Based on your description, I strongly suspect that your alloca and constant are not the same type. Remember that alloca returns a pointer type that you must load to get at the actual variable. On Jan 11, 2013 3:28 AM, "Manuele Conti" <manuele.conti at sirius-es.it> wrote: > Hi All, > I'm writing a code