>>>I want to set a Filter in View through Which I can either
>>>choose to :-
>>>
>>>1. Select all records
>>>or
>>>2. Select only deleted records
>>>or
>>>3. Select only undeleted Records
>>>
>>>Any suggestions/ideas ??
>>
>>either you add a field to your view
>>SELECT .. DELETED() as lDeleted
>>
>>or you can make this a parameter in your WHERE
>>and REQUERY as needed
>>
>>Arnon
>
>Thanks a Lot for both of your suggestions...
>
>I'll prefer to do it with WHERE Clause... But not able to form it properly...
>
>Can you pls tell me how to do exactly through where clause...

You need to specify which tables records are to be considered for deletion status; in the examples below, substitute your table's alias for cAliasName in the DELETED() function. If only one table is considered in the query, you can omit it.

Make certain to SET DELETED OFF before the query to allow consideration of deleted records in the query result (and to be able to see tuples that contain deleted records in the result!)

For deleted records:

WHERE DELETED(cAliasName)

undeleted records:

WHERE NOT DELETED(cAliasName)

Do not include any reference to DELETED() if both deleted and undeleted records are to be considered.