If you have Set deleted on then dleeted records are not detected by the deleted() fn. Is this the case?


>This one is killing me. I've looked at it for a while but don't understand the results:
>
>

>select p32pur1.vendorcode, p32pur1.transno, p32pur1.vdrinvno, p32pur1.itemdesc,;
> p32pur1.aptype, p32pur1.batchno, p32vend1.vendor ;
> FROM P32Pur1 ;
> JOIN P32Vend1 ;
> ON P32Pur1.Vendorcode = P32Vend1.Vendorcode ;
> WHERE aptype = 'DC' and EMPTY(p2gl) and ! deleted() .and. at('REVERS',comment)=0 ;
> into cursor curInv READWRITE
>

>
>This "Select" is run from a button click on a form with a private data session, which calls a form with a default data session that displays the results of this query and you can select 1 for deletion.
>
>In this example, I click on the button and 3 records are returned. If I select one of records for deletion, then click the button to attempt to delete another one, the tally from the above query is 0 records. But the other 2 records not deleted should be displayed. If I click the button again, the display will look like I expect.
>
>I've verified that Ansi and Exact are what they should be.
>
>Anyone have any suggestions?
>
>Thanks,
>
>PF