Click or drag to resize

DbServer.Deleted Property (Typed)

X#
A logical value indicating whether the current record is marked as deleted.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.21
Syntax
 VIRTUAL PROPERTY Deleted AS LOGIC GET 
Request Example View Source

Property Value

Type: Logic
A logical value indicating whether the current record is marked as deleted.
Remarks
A logical value indicating whether the current record is marked as deleted. Note that a pointer change, such as GoTop(), must be invoked in order for the filter condition to become active.
Examples
This example uses Deleted as a filtering condition with the DBServer:SetFilter() method:
X#
 1CLASS Sales INHERIT DBServer
 2...
 3FUNCTION IgnoreDeleted()
 4LOCAL oDBSales AS Sales
 5oDBSales := Sales{}
 6oDBSales:SetFilter(!oDBSales:Deleted)
 7oDBSales:GoTop()
 8.
 9. <Process records>
10.
11oDBSales:ClearFilter()
This example uses a compound filtering condition with the DBServer:SetFilter() method, and is also assuming that the Players.dbf file is already open at the class level:
X#
 1CLASS Players INHERIT DBServer
 2...
 3FUNCTION pbResetFilter()
 4Local cFilter
 5cFilter    := [Season = '] + SELF:cSeason + [' .and. .not. empty(TeamNr) ]
 6cFilter    += [ .and. empty(HomePhone)]
 7cFilter    += [ .and. Gender = '] + SELF:cGender + [']
 8SELF:oPlayersServer:SetFilter(, cFilter )    // Note placement of comma parameter
 9SELF:oPlayersServer:GoTop()
10.
11. <Process records>
12.
13SELF:oPlayersServer:ClearFilter()
See Also