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;
}
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