search for: hyr

...nd am a little perplexed. When (trying to) modify a table I issue the following commands with subsequent errors sqldf("alter table Korea drop column code", dbname = "mydb") error in statement: near "drop": syntax error or sqldf("alter table Korea rename column hyr to hyrI", dbname = "mydb") error in statement: near "column": syntax error These are simple commands - am I missing something obvious? I can retrieve data from them, and retrieve their table_info Thanks Peter -- View this message in context: http://r.789695.n4.nabble.c...

...library(foreign) library(MASS) library(nlme) datos<-read.spss(file="c:\\Documents and Settings\\Administrador\\Escritorio\\datosfin.sav",to.data.frame=TRUE) str(datos) `data.frame': 1414 obs. of 5 variables: $ POB : Factor w/ 6 levels "CHI","HOS","HYR",..: 1 1 1 1 1 1 1 1 1 1 ... $ CLON : num 1 1 1 1 1 1 1 1 2 2 ... $ TEMP : Factor w/ 2 levels "20 C","25 C": 1 1 1 1 2 2 2 2 1 1 ... $ SALINITA: Factor w/ 2 levels "15 g/l","30 g/l": 1 1 2 2 1 1 2 2 1 1 ... $ DE : num 17 0 7 1 15 28 4...