[ALLY] Re: About ODBC: (was about VIEW)
From: gchiu::compkarori::co::nz at: 31-Mar-2001 11:51
On Fri, 30 Mar 2001 10:13:02 -0500
"Vos, Doug" <[doug--vos--eds--com]> wrote:
> We just bought a copy of REBOL/Command and been running
> it
> for several days.
>
> Have not had problems with ODBC yet.
> What problems are you talking about?
> Specific bug? Error message?
These are from December, 2k.
I checked into these things a bit and there are definite
issues with
Interbase. It isn't one of the DBs we tested with so we
didn't catch
the problems. They probably affect other dbs too... we just
haven't
seen it yet... thanks for the help.
The problem will get fixed in the next rev of /Command but
don't ask
me when that is... 'cuz I don't know. :(
Sterling
> This is very odd. I can't retrieve any numeric fields thru
> ODBC unless I first cast them into char(). I had not tried
> this before so had not noticed this.
>
> On the bright side, inserting data thru ODBC and R/command
> seems to be a lot faster than how I normally do it going
> thru Visual dBase - as long as I stick to varchar fields.
>
> --
> Graham Chiu
>From AR:
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.
--
Graham Chiu