Solved

Databasequestion

Posted on 2000-03-17
7
147 Views
Last Modified: 2010-04-04
I'm using Dbase files. For working i only use the query and the database component. For what ist the table component important?
0
Comment
Question by:tzigan
7 Comments
 
LVL 9

Expert Comment

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

Cheers,
Igor.
0
 

Author Comment

by:tzigan
Comment Utility
That means, i don't need the ttable, and doesn't give me advantage for using dbase files?
0
 
LVL 7

Expert Comment

by:RBertora
Comment Utility
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;-)
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 9

Expert Comment

by:ITugay
Comment Utility
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.



0
 
LVL 10

Accepted Solution

by:
Lischke earned 100 total points
Comment Utility
Actually, you can consider TTable as being a special form of a TQuery (although they are not descentents of each other). The keypoint is that the DB works with socalled cursor (that's where the original name comes from as "cursor" means: "current set of record"). TQuery does NOT create temporary tables by default. It just tries to open a DB cursor as TTable does too. Actually, TTable is a convenient wrapper for database beginners. Professional DB packages like IB Objects don't even have a TTable equivalent. They all work exclusively with queries (and special constructs like DSQL, stored procedures, generators etc.).

Ciao, Mike
0
 
LVL 9

Expert Comment

by:ITugay
Comment Utility
But it only theory, I'm also prefer TQuery;)

Cheers,
Igor.
0
 
LVL 9

Expert Comment

by:ITugay
Comment Utility
But it only theory, I'm also prefer TQuery;)

Cheers,
Igor.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now