Records retrieved in detail table

[inetd]

If a master table and a detail table is linked one-to-many, what is the behaviour of the detail TTable /TADOTable?

Is it retrieving all the records and then filter the corresponding records? Or, just retrieve the corresponding records from the table?

Thx.

 

[inetd]

Any idea?

 

[hilfy]

It depends on the database you're using. If it's a desktop database like Paradox or xBase, it retrieves all the records and then filters based on the selected index. If it's a client/server database like MS SQL Server or Oracle, it should be using the linking field(s) in a where clause on the server.

-Dell