Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Unanswered: Delphi 5,BDE, Paradox 5 Transactions

    Hi,
    I use Delphi 5 with BDE and Paradox 5. I would like to know if transactions are supported in Paradox 5 tables and if Commit , StartTransaction , Rollback are working properly.

    Do we have to set a value in the registry in order to make transactions work?

    Thank you very much

  2. #2
    Join Date
    Apr 2004
    Location
    Arizona
    Posts
    75
    No.

    Paradox 5 is an old sequential open file database that does not support any of the new functionality of modern SQL databases.

    Also, Paradox 5 is a horrible database. It is constantly getting corrupted and needing reindexes and repairs. Plush it Blobs are just plain broken so don't try to use them. If I where you I would consider using Firebird instead of Paradox. It is a fully relational SQL database that does support transaction just like the industrial databases and it is Open Source. Plus there are many tools support by Delphi that will work with it, including the BDE.

    Firebird: The true open source relational database for Windows, Linux, Mac OS X and more

    If you got the money then I recommend MS-SQL Server.

    Granted you will need to learn a little about ADO and ODBC instead of that dead BDE which no one uses any more. Firebird also support ADO and if you start using ADO instead of the BDE you will be able to make code that works on a multitude of databases.

    Just MHO based on personal experience with Paradox and Delphi. Take it with a grain of salt.

  3. #3
    Join Date
    Nov 2004
    Posts
    13

    Firebird

    Agree on Paradox issues. I am using 7 (Office X3) with ongoing blob issues.
    A question about firebird: Is it possible to import Paradox blobs, or are these lost?

  4. #4
    Join Date
    Apr 2004
    Location
    Arizona
    Posts
    75
    To be honest, I stop working with Paradox back in 2003. At the time there were some datapumps that would move the data over for you but they did not work the way I would like so I just made my own convertor that would open a connection to both databases and just move the data.

    The new ones are probably better than the old Informix ones I had to use back then. Try this...

    Google

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •