//In the following example, lr_db_dataset_action removes the dataset that was created by lr_db_executeSQLStatement.
lr_db_executeSQLStatement("StepName=PerformQuery", "ConnectionName=db1",
"SQLStatement=SELECT dbo.Customer.CustID, dbo.Customer.FirstName, dbo.Customer.LastName FROM dbo.Customer",
"DatasetName=MyDataset", LAST );
lr_db_dataset_action("StepName=RemoveDataset", "DatasetName=MyDataset", "Action=REMOVE", LAST );
//In the following example, lr_db_dataset_action prints the contents of the dataset to the Replay Log.
lr_db_executeSQLStatement("StepName=PerformQuery", "ConnectionName=db1",
"SQLStatement=SELECT dbo.Customer.CustID, dbo.Customer.FirstName, dbo.Customer.LastName FROM dbo.Customer",
"DatasetName=MyDataset",
LAST );
lr_db_dataset_action("StepName=PrintDataset", "DatasetName=MyDataset", "Action=PRINT", LAST );
lr_db_executeSQLStatement("StepName=PerformQuery", "ConnectionName=db1",
"SQLStatement=SELECT dbo.Customer.CustID, dbo.Customer.FirstName, dbo.Customer.LastName FROM dbo.Customer",
"DatasetName=MyDataset", LAST );
lr_db_dataset_action("StepName=RemoveDataset", "DatasetName=MyDataset", "Action=REMOVE", LAST );
//In the following example, lr_db_dataset_action prints the contents of the dataset to the Replay Log.
lr_db_executeSQLStatement("StepName=PerformQuery", "ConnectionName=db1",
"SQLStatement=SELECT dbo.Customer.CustID, dbo.Customer.FirstName, dbo.Customer.LastName FROM dbo.Customer",
"DatasetName=MyDataset",
LAST );
lr_db_dataset_action("StepName=PrintDataset", "DatasetName=MyDataset", "Action=PRINT", LAST );
No comments:
Post a Comment