Garbage chars in MEMO field!

Thread View: borland.public.datagateway

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Chuck Baldi Wed, 14 Jul 1999 00:00

#69

Author: Chuck Baldi
Date: Wed, 14 Jul 1999 00:00

29 lines
2065 bytes

I am getting garbage characters appearing in data that is inserted into
MS-Access MEMO fields.  The data set colum type is String while the
database column type is MEMO.  When the data is originally written, it
is correct in the local data set until the query is refreshed.  Looking
at the database I have verified that the garbage does indeed get
inserted by the "saveChanges()" even though the data set in memory does
not show it. This tells me that the garbage is appearing somewhere
between the data set and the database.  The garbage is always appended
to the correct data.  I am using an MS-Access database via DataGateway. 
The problem occurs whether I tie the column to a JBCL control or set the
data programmatically.

I have seen others complain about this same thing before but have not
seen any corrections to the problem.  Does anyone know of a
work-around?  Someone has even suggested that the problem only occurrs
with DataGateway.  As I am only using DataGateway I am unable to verify
this.  However it does not surprise me since even though Inprise touts
DataGateway as an asset to the JBuilder package and a solution for all
my database needs, it is a severely under-documented and under-supported
product.

I fixed the problem once before by switching the MEMO field to TEXT, but
I don't have the luxury this time.

If anyone has any suggestions I would appreciate it.  How about some
knowledgable help from the Inprise folks who wrote/support/use-every-day
DataGateway?

Chuck Baldi

Re: Garbage chars in MEMO field!

#73

Author: John B. Moore
Date: Fri, 23 Jul 1999 00:00

27 lines
1792 bytes

In article <378CA318.5B20FC26@didax.com>, Chuck Baldi wrote:
> I have seen others complain about this same thing before but have not
> seen any corrections to the problem.  Does anyone know of a
> work-around?  

   I think the conclusion at this time is that it is a function of the 
interaction between the BDE and the OBDC driver.. Have you tried other 
drivers..??

> Someone has even suggested that the problem only occurrs
> with DataGateway.  As I am only using DataGateway I am unable to verify
> this.  However it does not surprise me since even though Inprise touts
> DataGateway as an asset to the JBuilder package and a solution for all
> my database needs, it is a severely under-documented and under-supported
> product.

   DGW is a dead product line..  It was never intended as a production 
solution but was a "this will get you going until the better JDBC class 3 
and 4 drivers are available" solution. Very similar to the JDBC-OBDC 
bridge.  My advice is to fine another JDBC driver.

   John...

+++++++++++++++++++++++
TeamB are volunteer helpers. Please do not email replies or questions. 
Post or reply only on this newsgroup. Thank you.
=======================

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads