Solved

What is the best component to use to convert the Delphi 3 BDE to Delphi 2010

Posted on 2010-09-02
13
580 Views
Last Modified: 2013-11-23
I have 2 apps written in Delphi 2 and 3. I need to convert them to Delphi 2010. What alternatives are there to the BDE that will work with oracle? I modify the sql statements in the code using modify/insert/update/delete.
0
Comment
Question by:zstafa
  • 4
  • 2
  • 2
  • +4
13 Comments
 
LVL 32

Expert Comment

by:ewangoya
ID: 33591695
You can use DBExpress or  DBGO components
They work fine
0
 
LVL 37

Accepted Solution

by:
Geert Gruwez earned 500 total points
ID: 33593823
if you want to fast components you can go with www.devart.com
they have really good database components > look for ODAC
0
 
LVL 13

Expert Comment

by:aflarin
ID: 33594320
I think DBExpress will be the best choice.

This links may help you:

http://edn.embarcadero.com/article/29106

Also you can try these components:

http://www.ethea.it/eng_instantbdexpress.asp
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Expert Comment

by:AndrewB2
ID: 33602355
You could give Zeoslib a go - freeware and quite mature.
 http://zeos.firmos.at/portal.php
0
 
LVL 22

Expert Comment

by:senad
ID: 33655308
0
 
LVL 45

Expert Comment

by:aikimark
ID: 33655701
@zstafa

Are you looking for a component that you drop into your project, rename all BDE references to the new component and expect it to compile?  I doubt one exists.  The conversion will require some programming.  You must understand the BDE code as well as equivalent relational database methods.
0
 
LVL 3

Author Comment

by:zstafa
ID: 33659621
I am only looking for the the component that will give me the least problems during the conversion process. I am currently testing all of the proposed solutions and will be accepting soon. Thanks for all of your help.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33659914
it mostly depends on how the code is written

if you use query components directly from the palette is the least effort
to implement straight away.

However if you build a library/package around the components you want
and then use that library/package, you only need to change the base components in the library/package

sample libcode:

  TXQuery = class(TQuery)
  end;

in your code you would be using TXQuery instead of TQuery

If you wanted to  change to a other component (for whatever reason)

  TXQuery = class(TADOQuery)
  end;

or
  TXQuery = class(TIBQuery)
  end;

or
  TXQuery = class(TSQuery)  
  end;

it can happen that you need to redeclare some properties
because some components are not directly interchangeable
0
 
LVL 3

Author Comment

by:zstafa
ID: 33705369
I was told by a coworker that DBExpress is supposed to be used only for small applications and will not be fast enough for the data driven app that we have? Is this true? I am currently testing aflarin's solution and if this is the case then it wont work.... thanks
0
 
LVL 45

Expert Comment

by:aikimark
ID: 33706245
@zstafa

We need more information.  

1. What kind of database are you going to connect to?
2. Are you using a disconnected/briefcase model?
3. Where will the Delphi application reside in relation to the database? (network proximity)
4. What database drivers are you using?
5. On what data is your coworker basing his statements about dbExpress performance?
6. What are your performance requirements?
0
 
LVL 3

Author Comment

by:zstafa
ID: 33708689
1. Oracle 10
2. We are using a direct connection and storing pre-save changes in a paradox database
3. It's a WAN .... for example a large university
4. We are trying to make a decision on what to use
5. He is basing his information on stuff he read on the internet
6. I am looking for the best performance for an Oracle database

Thanks
0
 
LVL 3

Author Comment

by:zstafa
ID: 33718221
I have tested a bunch of components for database access in our environment on a complex query that returns about 9000 records. I ran each one 7 times and recorded the time from a button click to when the datasource was populated. here are the averages.

devartODAC - 12.039 seconds
AnyDAC - 12.059
SQLDirect - 12.201
DBGO - 14.713
AllRoundAutomations - 17.650
DBExpress(simpleDataSet) - 19.693
DBExpress(clientDataSet) - 25.855

and devartODAC has a BDE migration wizard. Still doing more testing, but I think I am norrowing it down.  Thanks to everyone.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Windows Drag & Drop Location 2 100
Delphi XE2 application frozen on Windows 10 10 309
indy Tmemory stream non latin charcter issue 2 109
Breakpoint doesn't stop in my variable 3 23
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

9 Experts available now in Live!

Get 1:1 Help Now