Looping through an ADO recordset, I get an Invalid use of null error when I try to add Null to an integer.
Anyone know of a clean way to go around that ? I'd like to avoid If-Then-Else if possible.
Thanks...
Printable View
Looping through an ADO recordset, I get an Invalid use of null error when I try to add Null to an integer.
Anyone know of a clean way to go around that ? I'd like to avoid If-Then-Else if possible.
Thanks...
Thank you !
I also found a solution directly in the query I make. Here it is if anyone is interested...
I am using an Oracle database and can use the nvl function. In the select statement, instead of doing: select field_1 from... you can do: select nvl(field_1,0) from...
What this does is replace all instances of null values in that field by a 0, and that solves my problem...