<< the simple solution is to buy a supported database management tool>>
www.adager.com  <<<  great deal on a trade in>>>

HP discontinues DBChange: Adager has a generous upgrade offer.



----- Original Message -----
From: Thisted, Kristian <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, November 08, 2000 6:12 AM
Subject: Cleaning dataset with Aslplus


> Hello ...
>
> I use this very simple method in Askplus to delete entries:
>
>    SET = ORDER
>    FIND ALL ORDERNR
>    REPORT
>      LINK L1, ORDERNR :: CUSTOM.ORDERNR
>      NEWREG #B : X6 = "REMOVE"
>      #B UPDATE TEXT, IF L1..ORDERNR = $MISSING
>    END
>    SET = ORDER
>    FIND TEXT="REMOVE"
>    DELETE
>
> This works fine until the SET are all keyItems. "Update" wont perform in
> that case.
> Who has the smartest way to handle this?
>
> I want to run the job while users are on. I do have Supertool.
>
> /K