Filter data throufh DataEnvironment

Dear Friends

I am using MSHFlex Grid with DataEnvironment and want to filter recrod. pls solve my problem with detailed procedure.


Zubair khan

are you using this method?

set MSHFlex.datasource = rs


if yes then
just do this

rs.filter = "UserID = 'Cliven'"
MSHFlex.datasource = rs

Depending how your DE is set up you could always requery the recordset using the where clause.

The would be useful if you needed to limit the number of records in the recordset at any one time.