[REBOL] Re: ODBC
From: sqlab:gmx at: 11-Dec-2000 9:58
> Do you have any specifics on the bugs with certain SQL datatypes?
>
> We're running REBOL/Command on Windows/NT workstation talking to
> PostgreSQL 7.0.2 on NetBSD. The ODBC driver is the 'stock'
> Win32 postodbc driver. So far, this has been an excellent setup
> for producing reports. Far faster (and IMHO far more flexible)
> than either Access or R:Base 2000 (the other 'front-ends' we use)
> when dealing with an SQL server and above average (million+ rows)
> size tables.
>
> So far - we haven't had *any* trouble with Rebol/ODBC. But, since
> we're about to start using Rebol for datbase updates as well, if
> you know of specific trouble spots a heads up would be appreciated.
> TIA
>
I remember just without access to the bug reports I sent to Rebol, that
Rebol/Command can not handle Streams with Cache at all (an implementation
specific datatype also known as LONGVARBINARY an/or LONGVARCHAR), and
gives
under certain conditions wrong values for numeric datatypes. I don't
remember BIT fields, but I guess there is a problem too.
I will not tell about the results I had trying to access NonStopSQL with
Rebol/Command.
If you want to check how compatible Rebol/Comand is, run "Make Table" in
ODBC Test (ANSI) with your choosen database and try to work with that
table.
AR
--
Sent through GMX FreeMail - http://www.gmx.net