BorlandTalk.com

michael · Guest

Dear All,

I have few dbase files from older application. They are using .dat as the
extension.
If I rename the file to dbf and using odbc or jet 4.0 ( ole ) I managed to
open connection and read table as it is.
The problem is to make it compatible with older application.

I read in MSDN about Jet 4.0, It is saying that with the previous version of
Jet 4.0, it is allowed to read dbase file with extension other than .dbf
Due to security measure, it has been disallowed

The Problem is :
I have to read .dat as it is w/o renaming the file due to it might be used
when reading the file.
Copying before renaming might be my last effort, as I prefer to be real time
rather than copying the file.

Is there some way to get around this problem ?

Thanks

Regards

Michael

victor feria · Guest

Go to http://www.advantagedatabase.com . They have a tdataset component
(free) for use with Delphi. It can read dbase files. I think (and I might be
wrong) it can open a dbf file by just assigning the filetype property as a
dbf filetype. You can download the component and try it. It is worth the
effort.

cheers :)

"michael" <mgoh_id (AT) yahoo (DOT) co.uk> wrote

Bill Todd · Guest

There is a bit more to it than that. Advantage does not support all of
the xbase formats. To use the Advantage TDataSet components you must
install either Advantage Local Server (free) or purchase Advantage
Database Server.

--
Bill Todd (TeamB)

Benedictum · Guest

Which dbf version is your dat file? I have read dbaseIV and dbaseIII with
ease. I have not tried it with dBaseII, though. As I said, try it. Cost you
nothing except a little finger workout :)

"Bill Todd" <no (AT) no (DOT) com> wrote

Benedictum · Guest

Also, download the Advantage Architect. It should automatically install the
Advantage Local Server. Go to file ->Open (the table) with the settings at
"auto-sense". This should ask you what filetype it is use either dbf/cdx or
dbf/ntx.
If it opens the file then you are in business.

Herbert · Guest

I use TADOQuery for open table1.dat without problem, I put an example at
the botom,

my problem is How I can to make for the tables in the SELECT use the index
files table1.ind and
table2.ind ?

for example

SELECT * FROM table1.dat, table2.dat
WHERE table1.field1 = table2.field2

If I not use the indexed file the query get long time

Thanks
---------------------------
FOR DBF WITH EXTENSION OTHER THAN .DBF ( I.E. DAT )
I set 2 properties
1- ConnectionString=
Provider=MSDASQL.1;Persist Security Info=False;Data Source=Visual FoxPro
Tables;Extended Properties="DSN=Visual FoxPro Tables;UID=;
(here are the directory) !!!!!!!!!!!!!!!!
SourceDB=e:42;
SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=No;Dele
ted=No;"

2- SQL= SELECT * FROM table1.dat
---------------------------

"michael" <mgoh_id (AT) yahoo (DOT) co.uk> escribió en el mensaje
news:430c6581 (AT) newsgroups (DOT) borland.com...