<< Click to Display Table of Contents >> Navigation:  The Vo2Ado RDD > RDD Support Library > AdoDb() functions > AdoDbSetServerFilter

FUNCTION AdoDbSetServerFilter(cFilter AS STRING) AS STRING

RETURN DBINFO(DBI_SERVERFILTER, cFilter)

 

This function allows you to set a Server Side filter. The filter should be in a valid SQL syntax, without the WHERE clause. VO functions are not allowed in the filter string, only valid SQL criteria:

 

Sample:

 

 AdoDbSetServerFilter("au_lname LIKE '%A%'")

 

Setting the Server filter will close the current open recordset. A new recordset will be opened after a GOTOP or a SEEK has been executed.