ADOTable vs ADOQuery

[Minh Hoang 0]

Please kindly advise when we use this component over the other and vice versa

[Hans J. Ellingsgaard 21]

With sql databases always use the query component, you have much more control with it. 

[corneliusdavid 214]

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.

[Fr0sT.Brutal 900]

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.

[Minh Hoang 0]

Thank you very much to Hans, David and Fr0sT. I really appreciate your valuable advices.