search for: sqltablecreate

Displaying 3 results from an estimated 3 matches for "sqltablecreate".

2005 Feb 24
2
sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)
...ot updated MySQL. > sqlSave(lh, data, "survey") Error in gsub(pattern, replacement, x, ignore.case, extended, fixed) : invalid regular expression '[^[:alnum]_]+' > traceback() 4: gsub("[^[:alnum]_]+", "", colnames) 3: mangleColNames(names(colspecs)) 2: sqltablecreate(tablename, colspecs = colspecs, keys = keys) 1: sqlSave(lh, data, "survey") > str(data) `data.frame': 192 obs. of 171 variables: [...] (I can send the whole structure if that will help) > version _ platform i686-pc-linux-gnu arch...
2000 Mar 08
0
RODBC: follow up
...12, "varchar", 255, 255, NA, NA, 1, NA)) creates a data.frame with "" as column names (except for "tablename" as third column name) I don't know whether this is a R bug or expected behaviour. However it currently creates trouble as the later call of query <- sqltablecreate(tablename, newname, keys = 0) fails at Browse[1]> debug: if (coldata[i, 11] == 1) { null <- "NULL" } else { null <- "NOT NULL" } Browse[1]> Error in [.data.frame(coldata, i, 11) : undefined columns selected because newname/coldata misses colnames debug...
2005 Feb 24
0
sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7704)
...ave(lh, data, "survey") > Error in gsub(pattern, replacement, x, ignore.case, extended, fixed) : > invalid regular expression '[^[:alnum]_]+' >> traceback() > 4: gsub("[^[:alnum]_]+", "", colnames) > 3: mangleColNames(names(colspecs)) > 2: sqltablecreate(tablename, colspecs = colspecs, keys = keys) > 1: sqlSave(lh, data, "survey") > >> str(data) > `data.frame': 192 obs. of 171 variables: > [...] > (I can send the whole structure if that will help) > >> version > _ > platform i686-pc-linux-g...