
SCRIPTMAKER - DeleteEmptyRecords
Oyvind -
There's a number of ways to skin a cat...
If you want to delete a SUBSET of records where order_id="" the looping script
is great and in any case, its a powerful script step to learn.
However, if you ALWAYS want to delete ALL records where order_id="", you can
simplify your script (play with this script a number of times on a dummy
database before implementing!):
Perform Find(Restore)
Delete All Records
The Find would be order_id=""
You can enable the "Perform Without Dialogue" option on the "Delete All
Records" Script step, but only do so after you are absolutely sure the Find
works correctly!
Tom Klingman