Displaying 5 results from an estimated 5 matches for "sqltypeinfo".
2012 Feb 06
0
sqsSave() test using Test.R script returning error suggesting no values upon "insert"
...g:
library(RODBC)
library(MASS)
USArrests[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.
------------------------------------------------------------------------------------------...
2007 Nov 13
2
Query an Access database based on a date attribute (Tudor Bodea)
Tudor Bodea asked:
>In this context, I try to get all the records for which market is atl-bos,
>competitor is delta and dd is 2007-11-20 (first record above). To do this I used
>># channel <- odbcConnectAccess("test.mdb")
>>res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos'
>>and competitor = 'delta' and dd =
2002 Dec 31
1
RODBCType&NullDataExportProblems
Hello
I am trying to move data between R and other systems (e.g. SAS and MS
SQL Server) using RODBC. I think I have the most recent version of
RODBC (0.9) and here is some other system info:
> odbcGetInfo(channel)
[1] "Microsoft SQL Server version 08.00.0679. Driver ODBC version 03.52"
> version
_
platform i386-pc-mingw32
arch i386
os mingw32
system i386,
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...arrafo
*4.1 Data types when saving a data frame When sqlSave creates a table,
there is some choice as to the SQL data types used. The default is to
select the SQL data type from the R type via the typeInfo argument to
sqlSave. If this is not supplied (usual) a default mapping is looked up
using getSqlTypeInfo() or by interrogating sqlTypeInfo(). This will almost
always produce the correct mapping for numeric, integer and character
columns of up to 254 characters (or bytes). In other cases (include dates
and date-times) the desired SQL type can be specified for each column via
the argument varTypes, a na...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
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