I use DataEnvironment (VB6) which returns some recordsets. I want to show the data on a data report but I want to display only the data that satisfy some criteria. I use the filter command:
let's say that the returning recordset from the data environment (deMyEnvironment) is: rsMyRecordset

deMyEnvironment.rsMyRecordset.filter = " Number > 30 "



My database (SQL Server 6.5) is very large and the problem is that my program loads all the database in memory, then it executes the query, displays the data I want in a report and only after the program ends, the memory is released. Is that a problem of data environment, of data report or mine? Can I use another way of filtering the data not localy but on the server?
Thank you!

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece