PeterOcean
Programmer
I have a head scratcher of a problem. I am creating an XML doc with the results of a db query. An element is created with the name of the field and the text value of the element is set to the value of the field. The problem happens when I check to see whether the value is null.
My code is as follows:
if ISNULL(rs.fields.item(iCnt).value) then
xml.Text = ""
else
xml.text = rs.fields.item(iCnt).value
end if
This works fine in debug mode, but when I just let it run I get an error "Invalid use of NULL" and it stops in the else statement.
My code is as follows:
if ISNULL(rs.fields.item(iCnt).value) then
xml.Text = ""
else
xml.text = rs.fields.item(iCnt).value
end if
This works fine in debug mode, but when I just let it run I get an error "Invalid use of NULL" and it stops in the else statement.