This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
RE: LScript: Delete documents using a Terminations List ~Umberto Nongeroson 28.Oct.03 10:10 PM a Web browser Applications Development 6.0.2 CF2Windows XP
Sorry -- please read my previous post again. You should not use a full-text search for this because it does not do an exact match on the complete value of a text field. Even though you use "=" in your query, for a text field it treats that as "contains" rather than "=".
For instance, if your query is ([firstname] = "Robert" and [lastname] = "Jones"), you will end up deleting not only the record for Robert Jones, but also Robert B. Jones, Robert Jones-Ransdottir, William Robert Jones III, and if you're not careful how you do your flags, Roberta Jones also.
Instead, use NotesView.GetDocumentByKey method, specifying exact match, to locate only one the document that you actually want to delete.