AltME: Databases

Messages

Endo
Well, I didn't use it much, but I this works:
;create table tbl [a b c]
>> db-insert tbl [1 2 3]
>> db-select/joins [a b c] tbl [select [a c] from tbl] b
== [1 2 3 1 3]
GiuseppeC
Thanks Endo
Your are very helpful to me
Endo
GiuseppeC
Yes, reading about REBOL. I was to quicky.
Endo
Well, the whole community was very helpful to me, now I'm trying be.
GiuseppeC
I have read in the REBOL3 world about incompatibility with ODBC in the latest icarnations. Do you know anything about this ?
Endo
I still use R2, didn't use R3 yet. Just a few tests etc.
As I know, there is no direct ODBC support in R3, but there is an ODBC extension which is stable if I'm not mistaken.
GiuseppeC
I meant "in the latest icarnations of ODBC"
Endo
BrianH and Kaj can answer more correctly about R3 && ODBC.
GiuseppeC
R2 and ODBC
Endo
R2 & ODBC is quite stable & useful.
There are just a few small problems which can be solved some work arounds.
such as, R2 doesn't support new SQL Server datatypes. You should CAST & CONVERT your values in your SQL to be able to get those values into R2 app.

BrianH
I don't know about the datatype support when connecting to Access 2007 databases; what Endo said was related to SQL Server. However, I have Access 2010 here and 2007 at home so I can run some tests later today if you like.
BrianH
R2 is more ambitious about datatype conversion than the R3 extension, which only handles SQL datatypes that are directly compatible with 64bit or smaller R3 datatypes. However, R2 doesn't handle floating-point datatypes, and R3 does.
Endo
I've used Access 2007 with R2, I didn't see a problem. Not sure about the supported datatype. I usually use old/standard/simple SQLs.
BrianH
Weirdly enough, the datatypes that R2 doesn't support in newer SQL Server versions are the ones that were added to make SQL Server *more* standard. It supports the old, non-standard ones just fine.
BrianH
I get tripped up by missing datatype support with the R3 extension a lot more than with R2. Converting from numeric to float is one thing - iffy, but at least you can do it; converting from varchar(max) or text to varchar is often impossible without data loss.
BrianH
Had to do more than one project with scripts that call themselves in R2 to do data extraction from text fields, then call themselves in R3 to do processing.
Good thing the R3 extension is open-source. Given time to work on it, we can improve its datatype support :)

Last message posted 349 weeks ago.