Jump to content
Minh Hoang

ADOTable vs ADOQuery

Recommended Posts

Table components will bring back all the fields from each row returned whereas you can limit the number of fields returned with a query. Also, the result set is prepared on the server (using joins and where clauses and such) rather than bringing the data down to the client and then filtering it, so it can be much more efficient, especially noticeable over slow connections.

Share this post

Link to post

Sometimes table and query are both just a thin wrapper over the same dataset class. Table allows nice combobox with table names and controls underlying query itself. With query you have to write query but it gives much more customization abilities.

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now