FiteredRowSet question
I think I can see how to use a FilteredRowSet, how to build the filter etc. But, FilteredRowSet is a subclass of CachedRowSet and CachedRowSet has the toCollection methods. If I call the toCollection method on a FilteredRowSet with a filter do I get everything or will my returned collection be filtered as well?
Thanks
[332 byte] By [
sasdava] at [2007-10-2 19:24:15]

The documentation doesn't say anything one way or another that I've been able to find, so I'll just try it and see what happens.
What I really need, though, is a RowSet that I can populate, then disconnect from the source, then pass SQL statements to in order to subset the data further without having to reconnect.
Anybody seen anything like that?