DeleteData

Description

Deletes data in the database according to the given TransferDef. The data will be deleted in reversed nesting level order. Rows appurtenant in underlying levels will also be deleted.

Signature
int DeleteData(string key, TransferDef transferDef)

Parameters

Name Data Type Description

key

string required

The authentication key

transferDef

TransferDefBase required

The transfer definition object. It can be a SimpleTransferDef or a TransferDef object.

Response

Data Type Description

int

Number of deleted rows.

Example

//***************************************************
//
// DeleteData
//
//***************************************************

// Initiate webservice
SurveyDataSoapClient sd = new SurveyDataSoapClient();

// Create a transfer definition
TransferDef transferDef = SurveyDataUtil.NewTransferDef(
    projectID,
    true,
    DatabaseType.Production);

// Create where-clause (all responses that were completed
// after 01-01-2002
WhereClause whereClause =
    SurveyDataUtil.NewWhereClause(
    SurveyDataUtil.NewBinaryComparison(
    ComparisonType.GreaterThan,
    SurveyDataUtil.NewQueryForm("interview_end"),
    SurveyDataUtil.NewQueryConstant(
    ConfirmitDbType.Datetime,new DateTime(2002,1,1))));
transferDef.Where = whereClause;

// Delete the responses
int responsesDeleted = sd.DeleteData(key,transferDef);