Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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