We help IT Professionals succeed at work.

Urgent Need for a Paradox ODBC Driver that allows modifications

inthedark
inthedark asked
on
1,575 Views
Last Modified: 2013-11-23
I need a Windows ODBC driver that will allow deletions to a paradox table used in a Delphi system.

I don't have Delphi installed, the guy who wrote the system died.

Background:

The company got a "Table Full" error message. I think there is something to do with block sizes.
I have copied the table at fault to my system and now need to repair it.  What do I need to do?
I looked at the table and there are a lot of records that are years old and can now be deleted. Also there are some recent entries that need to be deleted as the seem corrupted.  There is a field called Number that appears to be a key to this table, the recent entries contain values with huge gaps, so I think I need to reset these values. I need to find the table that drives these values.

I connected an Access database to the table but the driver will not allow deletes.
     
The system was written a long time ago (about 1999).

I don't know Delphi and I don't know anybody who does.

Looking for your help.
Comment
Watch Question

Commented:
Only trying to help...
There's a utilitty at http://sourceforge.net/projects/jedidbd/ which is very similar to Database Desktop which comes with Delphi 7 and allows you to edit and work with Paradox Tables. The problem is that it's not as powerful as Database Desktop, but, it's free and opensource. I think at the very least it will allow you to delete records and otherwise maintain the tables.
Here are some BDE utilities from Borland, I'll afterwards talk about some specific ones:
http://info.borland.com/devsupport/bde/utilities.html
There's also "Paradox Repair Utility" by borland which you can get at
http://www.borland.com/devsupport/bde/files/tutil32d.zip
(I tried to upload it but this silly utility didn't like what was in the ZIP
There's also the Paradox Tables Check and Repair utility which I think when I downloaded the executable didn't work so I had to recompile it, so I'm attaching my recompiled utility as a jpg - rename it to an EXE to run it
--to look for it yourself you can download it from: http://www.rksolution.cz/Delphi/Delphi.htm or at the BDE utilities link I gave you.
 
Good luck
 

PDXRBLD.jpg
CERTIFIED EXPERT

Author

Commented:
Thanks for the response I will try this out ASAP.
CERTIFIED EXPERT

Author

Commented:
How can I download and install the BDE drivers. The problem is I do not know what version to download and install?

Commented:
You can try http://info.borland.com/devsupport/bde/bdeupdate.html
and
http://alainlecomte.free.fr/Download.htm
If those fail I will have to link you to a demo of an application I made which installs the BDE on the system.
 
By the way, after the BDE is installed it's usually located at
C:\Program Files\Common Files\Borland Shared\BDE\bdeadmin.exe

Commented:
(or also in the control panel)

Commented:
Oh to answer your last question about which version, the latest one (5.2) should work with a 1999 app. I would download the latest.
CERTIFIED EXPERT

Author

Commented:
I am unable to download BDE from the Borland site, when I click on the 5.2 professional or entreprise download it always says unable to display this page. Or using Firefox it says file does not exist?

Commented:
Hmm you can get 5.1 from that other site I gave you. I'll see what I can dig up
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
Here's another demo that seems to install the BDE
http://www.columbusoft.com/AFD/download.htm 
CERTIFIED EXPERT

Author

Commented:
Things looking better tanks rfwoolf part 1 working.  The gartplan.dk downloads for the BDE installer works well.  The JediDBD desktop now works and I can change and delete records.
All I have to do now is work out how to fire a SQL delete query and I think that will be job done.
CERTIFIED EXPERT

Author

Commented:
I found File-New-SQL Query and I have removed the old records that are no longer needed.

So all I need to do now is rebuild the table so the deleted records are removed. How shall I do that?
 Do I use the tableoperations - pack?

Commented:
Correct, packing a table does that :)
Also it may be a good idea to run one of those utilities that checks the tables - it might find such-and-such an index is wrong or whatever, but you may or may not need that.
CERTIFIED EXPERT

Author

Commented:
I think all is ok now, but i am not sure how the system generates the number field?

CERTIFIED EXPERT

Author

Commented:
Thanks the poor customer is working and happy now.
CERTIFIED EXPERT

Author

Commented:
Many many thanks

Commented:
Do you know what fieldtype the number field is?
Paradox data types are alpha, number, money, short, long integer, BCD, date, time, timestamp, memo, formatted memo, graphic, OLE, logical, autoincrement, binary, and bytes.
Autoincrement the number is incremented by the server.
All the others the program has to check what is the latest number in the table, increment it by 1 and then set it as the number.
It is up to the developer what system to use - but my guess is Autoincrement. The Paradox Table Checker should be able ot check indexes etc for you and repaire them if they're broken.
 
Good luck

 

Commented:
Well I'm glad I could help, I hope it's all sorted out :p

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.