Hello AutomatedQA support,Test complete should provide DDTDriverObj.RowCount similar to DDTDriverObj.ColumnCountThis thread is derived from 'DDT using Excel sheet' thread.Currently test complete only provides column count and not row count.Therefore it is recomended to have row count in up coming test complete releases.Thank you.Payal

As a solution to this in my own data driven scripts I have implimented an index to all my sheets named "Row".eselect is a function that executes sql select statements and returns the recordset.ecommand is a function that executes sql commands.The indexing runs when I start my test and takes approx. 5-10 seconds at most.Additionally you'll notice that I pull the "rowcount" with a select statement when the indexing starts. Enjoy.JScript example: function indexsheet(){ var rs = eselect("SELECT Count(*) From [Script$]"); while (!rs.EOF){ c = rs(0).Value; rs.MoveNext; } rs.close(); rs = null; ecommand("Update [Script$] Set [Row] = ''"); for (var x = c + 1;x > 1;x--){ ecommand("Insert Into [Script$A" + (x - 1) + ":A" + (x - 1) + "] VALUES (" + x + ")"); } }

Yes Ryan Moran ,I am agree with you, I have also implemented something in VBScript.Payal,If you want to get the row count from the excel sheet you can follow the below approach- Set Exo=CreateObject("Excel.Application") Set Wbo=Exo.WorkBooks.Open("Your Path") Set Wso =Wbo.WorkSheets(1) rowCount = Wso.usedrange.rows.count Where - Exo = Excel Object Wbo = Workbook Object Wso = Worksheet Object

Hi Payal,DDT is a wrapper for ADO, and it provides the information available for ADO recordsets. It uses the standard way to work with tables.If you need to know the number of rows in the target file, you can iterate through the entire table and count the number of iterations.

Once I have iterated through the ddt data, if I want to move to the first record again, how do I do that?Thanks

The DDT objects create a forward only cursor so you can't navigate backwards. I believe, also, it doesn't have a RowCount necessarily, it just has an EOF marker.so, if you want to go back through, it's a matter of closing the object and re-creating it. Sorry.

Test complete should provide DDTDriverObj.RowCount

11 Replies

Ryan_Moran
Valued Contributor
11 years ago
As a solution to this in my own data driven scripts I have implimented an index to all my sheets named "Row".

eselect is a function that executes sql select statements and returns the recordset.

ecommand is a function that executes sql commands.

The indexing runs when I start my test and takes approx. 5-10 seconds at most.

Additionally you'll notice that I pull the "rowcount" with a select statement when the indexing starts. Enjoy.

JScript example:

function indexsheet(){

var rs = eselect("SELECT Count(*) From [Script$]");

while (!rs.EOF){

c = rs(0).Value;

rs.MoveNext;

}

rs.close();

rs = null;

ecommand("Update [Script$] Set [Row] = ''");

for (var x = c + 1;x > 1;x--){

ecommand("Insert Into [Script$A" + (x - 1) + ":A" + (x - 1) + "] VALUES (" + x + ")");

}

}
Ravik
Super Contributor
11 years ago
Yes Ryan Moran ,

I am agree with you, I have also implemented something in VBScript.

Payal,

If you want to get the row count from the excel sheet you can follow the below approach-

Set Exo=CreateObject("Excel.Application")

Set Wbo=Exo.WorkBooks.Open("Your Path")

Set Wso =Wbo.WorkSheets(1)

rowCount = Wso.usedrange.rows.count

Where -

Exo = Excel Object

Wbo = Workbook Object

Wso = Worksheet Object
YMinaev
Staff
15 years ago
Hi Payal,

DDT is a wrapper for ADO, and it provides the information available for ADO recordsets. It uses the standard way to work with tables.

If you need to know the number of rows in the target file, you can iterate through the entire table and count the number of iterations.
vthomeschoolmom
Super Contributor
13 years ago
Once I have iterated through the ddt data, if I want to move to the first record again, how do I do that?

Thanks
tristaanogre
Esteemed Contributor
13 years ago
The DDT objects create a forward only cursor so you can't navigate backwards. I believe, also, it doesn't have a RowCount necessarily, it just has an EOF marker.

so, if you want to go back through, it's a matter of closing the object and re-creating it. Sorry.
YMinaev
Staff
13 years ago
Hi All,

I've increased the appropriate suggestion's rating in our DB.
sastowe
Super Contributor
13 years ago
Can we have the feature allow us to specify the cursor type? It would be sad to loose the speed of the forward only cursor. By being able to specify the cursor type, we could decide whether we want speed or motion.

Does that make sense?
YMinaev
Staff
13 years ago
Hi,

Can you clarify what exact 'cursor type' you're talking about? It is a bit unclear.
tristaanogre
Esteemed Contributor
13 years ago
Jared,

Currently, as far as I know, the DDT driver objects only support "forward-only" cursor for navigating through the resulting record sets. You can only go to the next row until you hit EOF. You can't reset back to the beginning nor can you specify to go to a particular row. It would be nice, at least for ADODrivers, perhaps even for CSV, to allow an option to be able to reset back to the beginning of the record set or to be able to navigate backwards and forwards.
sastowe
Super Contributor
13 years ago
DDT.ADODriver is a wrapper for ADO recordset object. An ADO recordset object upon opening can have a parameter to identify the cursor type of the recordset. The options are static, dynamic, keyset and forward-only. Google ADO recordset for more info. It seems clear that DDT.ADODriver only supports the forward only cursor.

Given what DDT is intended to do, drive tests, forward only cursors seem fine. I think I was the one who asked for further support for other cursor types. I withdraw that request. If I want to do more stuff with ADO that DDT supports, I can use ADO directly.

Thanks

Stephanie