>Help!
>
>SELECT last,first,enter,left,st,myOtherTable.descr;
> FROM myTable INNER JOIN myOtherTable ;
> ON myTable.id=myOtherTable.id ;
> WHERE (ENTER<=CTOD('02/01/02') AND UPPER(St300.st)="A" AND DELETED()=.F.) ;
> OR (LEFT>CTOD('02/01/02') AND ST300.ST='I' AND DELETED()=.T.))
>
>
>where DELETED() refers to whether or not the corresponding record in myTable is marked for deletion.
>
>The above statement does not work. Does anybody know a workaround?
>Thanks all!
As Sergey writes, deleted records should be treated as non-existent.
Just use SET DELETED ON to omit deleted records.
Also note that
deleted() = .T. is equivalent to
deleted(), and
deleted = .F. is equivalent to
not deleted.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)