Click or drag to resize

DbServer.Filter Property (Typed)

X#
A string representing the current active filter.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.19
Syntax
 VIRTUAL PROPERTY Filter AS USUAL GET SET 
Request Example View Source

Property Value

Type: Usual
A string representing the current active filter.
Remarks
A string representing the current active filter. If no filter has been set, NULL_STRING is returned. Assigning a string or a code block to DBServer:Filter is equivalent to calling DBSetFilter().
Examples
This example displays the current Filter condition. Also, if you already have an existing filter condition, you might want to retrieve its :Filter value first, then if your new SetFilter() condition fails, you can reset it back to it's prior filter expression:
X#
 1CLASS Sales INHERIT DBServer
 2...
 3FUNCTION IgnoreDeleted()
 4LOCAL oDBSales AS Sales
 5oDBSales := Sales{}
 6oDBSales:SetFilter(!oDBSales:Deleted)
 7oDBSales:GoTop()        // move pointer to invoke filter
 8? oDBSales:Filter        // !oDBSales:Deleted
 9.
10. <Process records>
11.
12oDBSales:ClearFilter()
13? oDBSales:Filter        // NULL_STRING
See Also