Board index » delphi » Mixing different versions of Paradox tables

Scott Meissner

Delphi Developer
Mon, 22 Sep 2003 04:41:36 GMT

Mixing different versions of Paradox tables

I have been called upon to support an application that was written in an
early version of Delphi. The users seem to get BLOB errors every so
often. I am going to try and use many of the various recommendations
found on the Borland web site to fix the problem, however, I noticed
that when the original developer created the application, some of his
tables show up in the Database Desktop as Paradox version 4.0 and some
of the tables show up as Paradox version 5.0 for Windows.  This would
appear to me to be a problem, but I only do a small amount of code
support for Delphi.

Please Help.

Thanks

Scott

 
Rick Carte

Delphi Developer
Tue, 23 Sep 2003 02:20:55 GMT

Re:Mixing different versions of Paradox tables


Quote
Scott Meissner <meiss...@vitalrecords.com> wrote:
>I have been called upon to support an application that was written in an
>early version of Delphi. The users seem to get BLOB errors every so
>often. I am going to try and use many of the various recommendations
>found on the Borland web site to fix the problem, however, I noticed
>that when the original developer created the application, some of his
>tables show up in the Database Desktop as Paradox version 4.0 and some
>of the tables show up as Paradox version 5.0 for Windows.  This would
>appear to me to be a problem, but I only do a small amount of code
>support for Delphi.

I don't think the table versions are your problem.  The BDE
will by default save tables in the lowest version that will
support all the features selected.  This is actually a "feature,"
as it allows maximum backwards compatability.

Check that all your users are using the same BDE version, and
that it is one that supports the BLOB fields well.

Even better, we usually bypass the problem by simply storing the
drive and path information for the BLOB field in a string field,
rather than storing the BLOB itself in the table.

Other Threads

1. Paradox 4.x, 5.x and 7 tables Mix with Language driver mix

2. Different version of Paradox Tables

3. Mixing and losing records in Paradox Tables on a Client/server application

4. Open Different Paradox Table using same Table Component

5. Attempt to mix objects from different sessions

6. Mixing Objects from different Sessions

7. Attempt to mix objects from different sessions ?

8. Mixed Versions (1.0 & 2.0

9. Joining 2 different InterBase Tables with 2 different Database

10. Joining 2 different InterBase Tables with 2 different Database