Hi all:

How do I determine if SQL considers deleted records? I'm running a SQL statement that insists in including deleted records and SET DELE has no effect.

lso, (as we are told in the help documentation) including AND !deleted() is a no-no.

In the example below, the table EXPNSINV has deleted records.

Thanx,

Yossi

SELECT fm_flcode, ex_price * ex_qty AS sqAmount, ex_exptype ;
			FROM it!flckmast INNER JOIN it!expnsinv ;
			ON fm_flcode = ex_flcode ;
			WHERE ex_flcode$tcFlcode ;
			INTO CURSOR cursExpenses