Devart Forums

In my little application I only have to connect an external DBase-File, who came from another System and read on Line of a table. It's a long times ago, that I work with DBF-Files, but it seems easy..., but it isn't...

I use a TUniConnection, a TUniQuery, a TUniDataSource and a TDBFUniProvider in my app.
I conecct to the File, set a little "select * from ..." statement to the UniQuery and open the query.
Now it takes appox. 2 Minutes (!) until the result appears.
The DBF-File is on my local maschine, not in the network or elsewhere.

First I do the same with the Delphi ADO-Components and I get the result in less than one second, but I don't want to use the ADO-Components, because I have many trouble with special characters, especially the german umlauts.
It seems, that UniDAV don't have such problems, so I want to use them.

Do someone have an idea, what I do wrong?

Hello,

By default, when opening DataSet, DBFProvider obtains all records from the table. Try to set the FetchAll property to false and check UniDAC performance once again.

This doesn't work, but if I set "ExtendedFieldInfo" to false, it runs in less than a second.

But now I have a second problem: It don't shows me the german Umlauts.
Do you have some suggetion for this?

Hello,

For these symbols to be displayed correctly you need to set the UseUnicode property to true in the following way:

UniConnection1.SpecificOptions.Values['UseUnicode'] := 'true';