Purpose

A filter for data in a Recordset

Prototype

PROPERTY Filter AS USUAL

USUAL Can be one of the following:

- Criteria string — a string made up of one or more individual clauses concatenated with AND or OR operators

- Array of bookmarks — an array of unique bookmark values that point to records in the Recordset object

- A FilterGroupEnum value

The server will send a NOTIFYFILECHANGE after the filter has been set.

strCnn := "Provider=sqloledb;" + ;

"Data Source=cpserver;Initial Catalog=pubs;User Id=sa;Password=; "

oConn := AdoConnection

// Set the default connection for better error reports

AdoSetConnection(oConn)

oConn:CursorLocation := adUseClient

oConn:Open(strCnn,NIL,NIL,NIL)

oSrv := AdoServer"employee",oConn,adOpenKeySet,NIL,adCmdTable

oSrv:filter := "lname like 'a*'"