# Why doesn't ADO dataset itereator work?

**URL:** https://www.finalbuilder.com/forums/t/why-doesnt-ado-dataset-itereator-work/1083
**Category:** Discussion
**Created:** [January 22, 2009, 7:50am UTC](https://www.finalbuilder.com/forums/t/why-doesnt-ado-dataset-itereator-work/1083 "2009-01-22T07:50:08Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [January 22, 2009, 7:50am UTC](https://www.finalbuilder.com/forums/t/why-doesnt-ado-dataset-itereator-work/1083/1 "2009-01-22T07:50:08Z")

</div>

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

&nbsp;

&nbsp;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.

&nbsp;

What am I missing?

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

thanks

&nbsp;

select '1' as name

---

<div class="post-metadata">

### Author: ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [January 22, 2009, 10:44am UTC](https://www.finalbuilder.com/forums/t/why-doesnt-ado-dataset-itereator-work/1083/2 "2009-01-22T10:44:11Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [January 23, 2009, 3:52am UTC](https://www.finalbuilder.com/forums/t/why-doesnt-ado-dataset-itereator-work/1083/3 "2009-01-23T03:52:57Z")

</div>

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