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...
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?
Tate, was NULL handling ever implemented? I'm running 3.0.0.629 and I don't see any NULL handling options...
TJ
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.
The ADO Execute SQL and ADO Execute Stored Proc have an output option to replace NULL with a text representation in the results (default is "", perhaps add that same option to the ADO Dataset Iterator?
TJ