This script shows you how to delete a case in the OnNextCase Event in the output data file.
' ****************************************
' Designed by : Smarter Dimensions
' Last Updated : 4th August 2009
' Delete cases from the output file of a dms script.
' ****************************************
InputDatasource(Input, "")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrDataFileDsc; _
Location=C:tempshort_drinks.ddf; _
Initial Catalog=C:\temp\short_drinks.mdd"
SelectQuery = "SELECT * FROM VDATA"
End InputDatasource
OutputDatasource(Output, "")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrSAVDsc; _
Location=C:\temp\Output.sav; _
MR Init MDM DataSource Use=2; _
MR Init Overwrite=1"
MetaDataOutputName = "C:\temp\Output.MDD"
End OutputDatasource
Logging(MyLog, "")
Group = "DMA"
Alias = "datamgmt"
FileSize = 500
Path = "c:\temp"
End Logging
Event(OnNextCase, "")
If Respondent.Serial > 10 Then
dmgrJob.DropCurrentCase()
dmgrLog.LogError_2(Ctext(Respondent.Serial) + " - Case Deleted")
End If
End Event