lr_checkpoint example

int i=1;
    lr_db_executeSQLStatement("StepName=PerformQuery""ConnectionName=db1",
    "SQLStatement=SELECT dbo.Customer.CustID, dbo.Customer.FirstName, dbo.Customer.LastName FROM dbo.Customer",
    "DatasetName=MyDataset"LAST );

    while (i<4) {
        lr_db_getvalue("StepName=GetValue""DatasetName=MyDataset",
                "Column=FirstName",  "Row=next""OutParam=MyOutputParam"LAST );

        lr_output_message("The value is: %s"lr_eval_string("{MyOutputParam}") );
        lr_checkpoint("StepName=VerifyCheckpoint""ExpectedValue=Joe",
        "ActualValue={MyOutputParam}""Compare=Equals""StopOnValidationError=false"LAST );

        i=i+1;

No comments:

Post a Comment