Why doesn't ADO dataset itereator work?

FinalBuilder Discussion
1

I cannot get this to work. I use the iterator and the log each iteration to a variable , using the sql

 

 select '1' as name

I get these errors

Query returned unknown row count.
Set [SQLFilePath] to "1"
The iterator could not be initialised.
Invalid column number:

this is just a simple example because it was giving me the same error when I ran a real query. I've tried by both column names or numbers and get the same results. Column numbers I've done 0 and 1 in case its not zero based, same thing.

 

What am I missing?

I also updated FB to the latest version and stil the same.

thanks

 

select '1' as name

2

Hi Matt,

It look’s like the action has a bug when the grid on the ‘Iterator Variables’ tab includes an empty row, deleting the extra row should fix the problem. We’ll have a new build available soon which includes a fix for this bug.

Regards,
Paul.

3

Great, Thanks.

I have a new related problem now, if I apply a real query and assign the column to a variable and then log the variable (as an action for each iteration) I get the message Query returned unknown row count.
and it only iterates once and logs the first row from the query.

Am I missing something or is there a fix for that ?

thanks