@DeleteDifferenceByFormula

Deletes documents in the database with the DBHANDLE TODBHANDLE2 which are not present in the database with the DBHANDLE FROMDBHANDLE1.
It be only documents taken into account are, which have the NOTECLASS specified with FN NOTESCLASSES4 and matches the Scan-Formula TEXT FROMULA3.

Return-value:
On success, the number of deleted documents is returned; otherwise @ERROR.

FN NOTECLASS:
DEC   BIT   Meaning

00000   XX   No Notes   no documents
00001   01   Documents   data documents
00002   02   Policy-Note   database policy document
00004   03   Form-Note   form design documents
00008   04   View-Note   view design documents
00016   05   Icon-Note   icon document
00032   06   Design-Collection-Note   view documents
00064   07   ACL-Info-Note   ACL info document
00128   08   Help-Index-Note   
00256   09   Help-Note   help database document
00512   10   Filter-Note   macro design documents
01024   11   Field-Note   field design documents
02048   12   Replication-Note   replication documents
04096   13   Private-Design-Note   private design documents

32768   16   Default-Note of Each   the default document of each

32767   01-15   Notes   all documents
32766   02-15   All Non-Document-Notes   all non-data documents

FN FNUPDFLAGS5:
To combine the options, the values must be added.
DEC   Meaning
0001   Force change in any case (default and should always be specified)
0512   Deletion without deletion stub

Example: @DeleteDifferenceByFormula(FROMDBHANDLE1;TODBHANDLE2;FORMULA3;NOTECLASSES4;FNUPDFLAGS5);

Ret:=@DeleteDifferenceByFormula(dbh1;dbh2;"Form=\"Test Form1\"";1;513);

In the DB with the DBHANDLE dbh2, the documents are deleted that do not also occur in the DB with the DBHANDLE dbh1.
Only data documents (NOTECLASSES4=1) that match the scan formula "Form=\"Test Form1\"" are taken into account.
The deletion is forced and no deletion stub is created (FNUPDFLAGS5=513).

Note : This text was machine-translated and may contain inaccuracies.