asked on

Databasequestion

I'm using Dbase files. For working i only use the query and the database component. For what ist the table component important?

Igor UL7AAjr

TTable provides direct access to one table at one time. Working with DBase files it not created temporary tables (TQuery do it).

Cheers,
Igor.

tzigan

ASKER

That means, i don't need the ttable, and doesn't give me advantage for using dbase files?

RBertora

No you don't need to work with the table component.

In my oppinion it is a waiste of time designed specifically for knocking up super fast demos for people who don't have a clue of SQL. Commonly the ttable is used with the DBNavigator component which itself is buggy and just makes the whole thing not worth it.

(just my experience)

Rob;-)

Igor UL7AAjr

It will work litle bit faster if you will use TTable, instead TQuery, where it's possible. Run you application and see at working directory, every time, you TQuery.Open, you can see temporary file _xxx.DBF. Application spend some time to create it. Then system show you result of query by the same way as for TTable. Usually you need TQuery for retrieving records by condition or joining tables or retrieveing data from a SQL server.

Best regards,
Igor.

ASKER CERTIFIED SOLUTION

Lischke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Igor UL7AAjr

But it only theory, I'm also prefer TQuery;)

Cheers,
Igor.

Igor UL7AAjr

But it only theory, I'm also prefer TQuery;)

Cheers,
Igor.