search for: vartype

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/packag...

...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 thread...

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 real...

...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? De...

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 Version 2.1.0 (2005-04-18, i386-pc-linux-gnu) and have installed survey_3.4-4.tar.gz using install.package("survey", dependencies=T). I'd be grateful if somebody would tra...

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 1.0 9.0 51.0 208.7 1...

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 varType variable list */ lType = typeOf(varType); for (unsigned int i = 0; i < varNames.size(); i++) { AllocaInst *alloc = new All...

...s-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 = ""; > symbol->var1_list->accept(*this); /* get a vector contains variable names */ > symbol->spec_init->accept(*this); /* Store in varType variable list */ > lType = typeOf(varType); > for (unsigned int i = 0; i < varNames.size(); i++) { > Alloca...

...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: Wa...

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

...x80004002 err:ole:CoGetClassObject no class object {d27cdb6e-ae6d-11cf-96b8-444553540000} could be created for context 0x3 err:ole:TLB_ReadTypeLib Loading of typelib L"C:\\users\\jfinlay\\Temp\\PPT11.0\\ShockwaveFlashObjects.exd" failed with error 2 fixme:typelib2:ctl2_encode_typedesc PTR vartype, may not work correctly. fixme:typelib2:ctl2_encode_typedesc PTR vartype, may not work correctly. fixme:typelib2:ctl2_encode_typedesc Unrecognized type 12. fixme:ole:ITypeInfo_fnGetMops (0x2b2ac78 1610678272) stub! fixme:ole:ITypeInfo_fnGetMops (0x29f8b90 -525) stub! fixme:typelib2:ICreateTypeInfo2...

...9; chan_bridge_media.c:122:2: error: illegal storage class on function RAII_VAR(struct ast_callid *, callid, NULL, ast_callid_cleanup); ^ /home/jeffrey/asterisk-12.4.0/include/asterisk/utils.h:991:5: note: expanded from macro 'RAII_VAR' auto void _dtor_ ## varname (vartype * v); \ ^ chan_bridge_media.c:122:2: error: function definition is not allowed here /home/jeffrey/asterisk-12.4.0/include/asterisk/utils.h:992:42: note: expanded from macro 'RAII_VAR' void _dtor_ ## varname (vartype * v) { dtor(*v); } \...

...;s pointer size, not system's. Andr? Hentschel (15): oleaut32/tests: Get rid of IS_ANCIENT in vartest. oleaut32/tests: Get rid of HAVE_OLEAUT32_RECORD in vartest. oleaut32/tests: Don't use autoheader styled define in vartest. oleaut32/tests: Get rid of IS_ANCIENT in vartype. oleaut32/tests: Get rid of HAVE_OLEAUT32_RECORD in vartype. oleaut32/tests: Get rid of HAVE_OLEAUT32_DECIMAL in vartype. oleaut32/tests: Get rid of HAVE_OLEAUT32_CY in vartype. oleaut32/tests: Don't use autoheader styled defines in vartype. oleaut32/tests: Don'...

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...

...ile is left open */ int *var_id_p, /* variable id */ long **varlen, /* Length of variable, along each dimension */ long *ndims_r, /* number of dimensions in variable */ /* This argument is created automatically by S+'s .C for pointers=T variables */ char **vartype) /* character string describing S object type */ { ... *varlen = dimval = (long *)S_alloc(ndims,sizeof(long)); ... } S+ call: ... vardims <- integer(0) # Length of each dimension vartype <- "" # "integer","single&q...

...ude/freetype2 -g -O2 -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=0 -o testlist.o testlist.c ../../../tools/winegcc/winegcc -m32 -B../../../tools/winebuild --sysroot=../../.. -fasynchronous-unwind-tables dispatch.o olefont.o olepicture.o safearray.o tmarshal.o typelib.o usrmarshal.o varformat.o vartest.o vartype.o test_reg_i.o tmarshal_i.o tmarshal.res testlist.o -o oleaut32_test.exe.so ../../../libs/port/libwine_port.a -loleaut32 -lole32 -lrpcrt4 -luser32 -lgdi32 -ladvapi32 -L/emul/linux/x86/usr/lib -L/emul/linux/x86/lib winebuild: vartest.o is an empty file winegcc: ../../../tools/winebuild/winebu...

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) I want to assign the variab...

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