Interbase BDE

Posted on 2012-08-21
Last Modified: 2012-11-13
Hi Experts

I have 100 + applications written in Delphi 5 and using BDE and interbase XE I am getting $210D errors and it has been advised to move from the BDE as it is not supported any more What suggestions do you have to move to.

Some update programs have 2 - 3 Databases and up to 30 Tables depending on the customers requirements. What is the quickest and easiest solution

Question by:Kevinfeening
    LVL 9

    Expert Comment

    I offer to use delivered with Delphi native Interbase components.
    LVL 25

    Expert Comment

    by:Sinisa Vuk
    My guess too. There are some tools which can help you to import db structures (tables/fields/indexes/data).
    LVL 44

    Expert Comment


    It might be worth the money to hire an expert to do the code conversion.  Consult the EE jobs topic area.

    We are here to help you, but this isn't a trivial task, unfortunately.  I've urged Borland/Codegear/Embarcadero to create code migration tools ever since they announced the end-of-life for the BDE.

    Author Comment

    Thanks but that isn't an option the company I work for would drop the product and use another so I need some advice or a new job

    If I use the interbase components is there any conversions

    or do you have any other options
    LVL 44

    Accepted Solution

    I would start by importing the data into IB and learn SQL.  Play with a throw-away project, so you can get used to retrieving/displaying/updating data with dbExpress.

    Once you are comfortable with dbExpress, look for some place in your application that only uses one or two tables.  Convert the BDE controls and code in that part OF A COPY OF YOUR APPLICATION and test vigorously.  The Delphi experts can help you with code, but you'll need to post the unit and give the experts some idea of what they aren't seeing in your post (data description, data-related controls on your form, etc.)

    Author Comment

    Thanks it will try that

    Also I was looking at the IBDatabase, IBTransaction, IBTable etc are they an option
    I have created a project updating a file after a change and it works OK

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
    In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now