lr_db_getValue 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}") );
    i=i+1;
    }

No comments:

Post a Comment