search for: tblnames

Hi, I've written some code that fetches data from an Access Database (2003), processes the data, then saves the modified data back into a table in the Access database. It works if I only pass through the code once, but if I put a loop around the code so that I fetch data from a different source table, and then save it again to a different destination table, the code crashes. It is

...m8 m9 m10 m11 q q2 msr icr fb1 fd8 msf ids) # } # execute the x12 fortran pgm. executable x12a stored in /home/fred/x12a system("/home/fred/x12a/x12a blp") # read x12 fortran pgm output tables back into R blp.x12 <- readx12out("blp", adtype="M", calendar=F, tblnames=NULL) # basic versions of writex12in and readx12out writex12in <- function(tso,file){ write.table(cbind(time(tso) %/% 1, cycle(tso), tso), file=paste(file,".dat",sep=""), sep=" ", quote=F, row.names=F, col.names=F) } readx12out...

I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is

Hi when executin the following code, I get an "$ operator is invalid for atomic vectors". I understand the meaning of the error (and have seen the warnings in earlier R versions). My question is, is there an updated version of RMySQL which deals with it, or is my on;ly option to switch to RODBC (which I would not like to do as I am using Linux)? If I have to use RODBC, how can I easily

I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME. Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values. Can this be done? If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an

Hi all, Thanks to everyone who replied to my change of case question... I doubt I would have ever randomly guessed 'toupper' or 'tolower'. I am trying to be cleaver[1] and make a flexible data structure in R. I have a relatively large quantity of data that can be broadly grouped into blocks/chunks which are identical in their form: blockid = numeric blocktype = string

Is there a way to estimate a nominal response model? To be more specific let's say I want to calibrate: \pi_{v}(\theta_j)=\frac{e^{\xi_{v}+\lambda_{v}\theta_j}}{\sum_{h=1}^m e^{\xi_{h}+\lambda_{h}\theta_j}} Where $\theta_j$ is a the dependent variable and I need to estimate $\xi_{h}$ and $\lambda_{h}$ for $h \in {1...,m}$. Thank you, Mauricio Romero Quantil S.A.S. Cel: 3112231150