Benchmark Toolkit Sql query help

Nov 23, 2012 at 5:33 AM

I am writing custom scenarios in benchmark toolkit using VSTS 2008 for Dynamics AX 2009. I want to retrieve the count of the rows returned from a query. But it throws an exception.

Below is the query:

fsASNReceiptImportDetails.RecMethExecuteStatement("SELECT COUNT (*) FROM %1 WHERE %1.CIscoLocation == '" + CIscoLocation + "'");

 

Also fsASNReceiptImportDetails.RowCount() - is returning "-1" value after executing the query:

fsASNReceiptImportDetails.RecMethExecuteStatement("SELECT * FROM %1 WHERE %1.CIscoLocation == '" + CIscoLocation + "'");

here fsASNReceiptImportDetails - is AX table.