How Do I Delete a Chunk of Records from a Data Table? (Magic xpa 3.x)
Programmers often need to delete large batches of data. This is commonly the case when purging databases, or moving records into archival tables.
-
Create your task (either as a subtask or stand-alone program).
-
Go to the Task Properties dialog box (Ctrl+P).
-
Select:
Task type: Batch
Initial mode: Delete
-
Click OK.
|
|
-
Now move to the data view editor. Select the Main Source for the data source you are deleting records from. In this case we selected Order Header.
-
Select the columns that include the records you want to delete. In this case, the only column we need to select is Order Status. But having a couple of others helps with debugging.
-
Zoom from the Range: and To: columns to define the upper and lower range for the delete. In this case we are deleting all records with a date of zero to 1000 days ago, which have a status of ‘X’. Technically the lower range for the date, ‘00/00/0000’DATE, is not required, because by default Magic xpa would use all records up to the upper range if no range was entered for the lower range.
Now, when this task is run, the records that meet the range criteria will be deleted from the data source.
The Online and Rich Client Samples projects (program TS08 and RTS08)
