# ADO Iterator - null

**URL:** https://www.finalbuilder.com/forums/t/ado-iterator-null/4320
**Category:** Discussion
**Created:** [July 17, 2008, 1:55am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320 "2008-07-17T01:55:05Z")
**Posts on this page:** 5
**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: [July 17, 2008, 1:55am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320/1 "2008-07-17T01:55:05Z")

</div>

Hi,

I am getting a recordset fra a database... and one field is allowed to be null.... but the iterator fails trying to assign this to a string... is that logical?

I would like to be able to fetch the recordset, and the evaluate if the field is null or not, and the depending on that evaluation, decide what to do...

---

<div class="post-metadata">

### Author: ![tate](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/t/e19b73/32.png) [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 21, 2008, 3:20am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320/2 "2008-07-21T03:20:45Z")

</div>

So, the iterator action crashes if the value is null?   
  
 Maybe we need some extra options:   
  
 If null if found:   
 a. Fail action   
 b. Convert to string: - with the default being blank, but you could type in “” or something like that.   
  
 what do you think?

---

<div class="post-metadata">

### Author: ![sexy-trousers](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sexy-trousers/32/97_2.png) [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)
#### Post date: [May 21, 2009, 8:00am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320/3 "2009-05-21T08:00:23Z")

</div>

Tate, was NULL&nbsp;handling ever implemented? I'm running 3.0.0.629 and I don't see any NULL&nbsp;handling options...

TJ

---

<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: [May 22, 2009, 1:22am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320/4 "2009-05-22T01:22:36Z")

</div>

Hi Tim,   
  
 Currently Automise will just blank the variable value when the field is null, what kind of options would you find useful?   
  
 Regards,   
 Paul.

---

<div class="post-metadata">

### Author: ![sexy-trousers](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sexy-trousers/32/97_2.png) [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)
#### Post date: [May 22, 2009, 4:58am UTC](https://www.finalbuilder.com/forums/t/ado-iterator-null/4320/5 "2009-05-22T04:58:46Z")

</div>

The ADO Execute SQL&nbsp;and ADO Execute Stored Proc have an output option to replace NULL&nbsp;with a text representation in the results (default is "", perhaps add that same option to the ADO Dataset Iterator?

TJ