This question is always in the back of my mind when dealing with ADO. I am using dbGo componenets with Access / SQL Server backends. Using a TADOTable with Client cursor and Keyset Cursor type: if I filter it so only a single record is showing in a grid, are all of the other rows not currently showing still sitting in memory? Or, does the filter cause the table to go out to the back end to pick up only those rows that are to be included with the current record?
I have tried setting the cursor to server side, but that seems to be really hated by my application. Do I need to use a TadoQuery to bring in just the records that I want? I have read several ADO books and they have merely confused me. Thanks jamie
