Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: BDE - Is it the only way to open DBASE files?


This question is answered. Helpful answers available: 0. Correct answers available: 1.


Permlink Replies: 5 - Last Post: Apr 14, 2015 6:57 PM Last Post By: John MacDonald
John MacDonald

Posts: 179
Registered: 3/22/98
BDE - Is it the only way to open DBASE files?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 26, 2014 5:59 PM
Hey everyone.

Two questions:

1. Is the bde the only way to get access to a dbase file?

2. Once we have the dbase file open how do I get to know the files metadata?


--
JMAC out

quinn wildman

Posts: 856
Registered: 12/2/99
Re: BDE - Is it the only way to open DBASE files?
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 27, 2014 8:28 AM   in response to: John MacDonald in response to: John MacDonald
You didn't mention if you are using RAD Studio here, so if you expand
the scope to outside RAD Studio, you should have many choices to access
a dBASE file.

There is a dBASE ODBC driver. You could use it many places, including
RAD Studio.

Goldmine is a product that uses dBASE. Dunno how, or it's usage is
applies here.

DBASE product is still around. See www.dbase.com.

FoxPro

To see the metadata of a dBASE table in RAD Studio

* connect a TTable to it
* Double Click on the TTable (bring up the fields editor)
* Right click in the fields editor and select Add All fields.


John MacDonald wrote:

Hey everyone.

Two questions:

1. Is the bde the only way to get access to a dbase file?

2. Once we have the dbase file open how do I get to know the files metadata?


--
JMAC out

John MacDonald

Posts: 179
Registered: 3/22/98
Re: BDE - Is it the only way to open DBASE files?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 14, 2015 6:56 PM   in response to: quinn wildman in response to: quinn wildman
Thanks Quinn:

I am using Rad Studio. I used FireDac and the ODBC driver.


quinn wildman wrote:
You didn't mention if you are using RAD Studio here, so if you expand
the scope to outside RAD Studio, you should have many choices to access
a dBASE file.

There is a dBASE ODBC driver. You could use it many places, including
RAD Studio.

Goldmine is a product that uses dBASE. Dunno how, or it's usage is
applies here.

DBASE product is still around. See www.dbase.com.

FoxPro

To see the metadata of a dBASE table in RAD Studio

* connect a TTable to it
* Double Click on the TTable (bring up the fields editor)
* Right click in the fields editor and select Add All fields.


John MacDonald wrote:

Hey everyone.

Two questions:

1. Is the bde the only way to get access to a dbase file?

2. Once we have the dbase file open how do I get to know the files metadata?


--
JMAC out


--
JMAC out

Edited by: John MacDonald on Apr 14, 2015 9:56 PM
Mark Wallin

Posts: 9
Registered: 2/8/01
Re: BDE - Is it the only way to open DBASE files?
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 6, 2014 1:50 PM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
Hey everyone.

Two questions:

1. Is the bde the only way to get access to a dbase file?

2. Once we have the dbase file open how do I get to know the files metadata?


--
JMAC out

I just saw this post and I'd like to add that I used Halcyon from www.grifsolu.com for many years. It is a component for Delphi that provides direct access to dBase files (Clipper or Foxpro flavor). I did this to avoid the deployment issues of the BDE. The site still seems to be up but the user forum is gone and the latest updates were only up thru Delphi XE. It looks like the product might still be for sale but I could be wrong. The product always worked well for me and I combined it with TXQuery (no longer being marketed or supported) to add SQL access to the tables. I still have these components installed in my older Delphi versions. They work fine in Windows 7 as well as older versions.

To work with Dbase files, I always used Foxpro 5 to directly access and maintain the data, structures and indexes outside of the application. This is as close to the 'metadata' as you are going to get, I believe. Foxpro can still be obtained from various sources (Ebay, Amazon) but is no longer supported by Microsoft much to the chagrin of its many users.

If you have any other questions, I would be glad to assist.

Mark J. Wallin

Edited by: Mark Wallin on Nov 7, 2014 2:23 PM

You may also want to look at http://www.grafxsoft.com/
They market CA-Visual Objects (taken over from CA) and Vulcan.NET - a descendent of Clipper and also compatible with Visual Objects. Both have access to all forms of dBase tables.

Marius .

Posts: 64
Registered: 11/22/99
Re: BDE - Is it the only way to open DBASE files?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 8, 2014 2:51 AM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:

Hey everyone.

Two questions:

1. Is the bde the only way to get access to a dbase file?

2. Once we have the dbase file open how do I get to know the files
metadata?

You use Advantage database (http://devzone.advantagedatabase.com). It
is supported by AnyDac/FireDac (if you have a more recent Delphi). ADS
has an API to query the metadata.. We have been using ADS for the last
10 years, it works really well.
Marius .

Posts: 64
Registered: 11/22/99
Re: BDE - Is it the only way to open DBASE files?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 8, 2014 12:29 PM   in response to: Marius . in response to: Marius .
Correction

** You can use Advantage database
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02