search for: sqldrop

...y it. Despite sqlSave succeeding without error, sqlQuery tells me the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is dropped upon evaluating close(myConn). Also, sqlDrop works as expected. Thanks for your time. Any thoughts are appreciated. Dave Mitchell [[alternative HTML version deleted]]

...1,2] <- NA hills <- hills[1:15,] row.names(hills)[12] <- "Dollar ('$')" set.seed(1) # MySQL ## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x channel <- odbcConnect("MysqlODBC")  #my database odbcGetInfo(channel) sqlTypeInfo(channel) sqlTables(channel) sqlDrop(channel, "test.USArrests",errors = FALSE)  #explicit database AND table call as MySQL doesn't allow general table creation  Everything works as advertised. ----------------------------------------------------------------------------------------------- #Then we get here.  I have the...

...Despite sqlSave succeeding without error, sqlQuery tells me that the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is dropped upon evaluating close(myConn). Also, sqlDrop works as expected. Thanks for your time. Any thoughts are appreciated. Dave Mitchell [[alternative HTML version deleted]]

Hi, Using the fast=F option, sqlSave saves without matching column names. It looks like a bug to me.......... Here's a simple (artificial) example. ----------------------------------------- Create a dataframe and save it to a database table "test" as follows: df <- data.frame(T=1, S=10) sqlSave(channel, df, "test", rownames=F) The table now looks like T S 1 10 If

...lareFetch=0 TextAsLongVarchar=1 UnknownsAsLongVarchar=0 BoolsAsChar=1 Parse=0 CancelAsFreeStmt=0 ExtraSysTablePrefixes=dd_ LFConversion=0 UpdatableCursors=0 DisallowPremature=0 TrueIsMinus1=0 BI=0 ByteaAsLongVarBinary=0 UseServerSidePrepare=0 LowerCaseIdentifier=0 > sqlDrop(channel, "clx_test") character(0) > sqlSave(channel, clx_test, varTypes=varspec, addPK=TRUE, fast=TRUE) > odbcClose(channel) *** glibc detected *** /usr/lib/R/bin/exec/R: corrupted double-linked list: 0x082dd498 *** ======= Backtrace: ========= /lib/tls/i686/cmov/libc.so.6[0xb7b8c3f...

Hello! I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case). What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts): > sqlSave(con, x, tablename =