Handle dbnull values

[larris]

How to i handle dbnull values? Does the oracle NVL function works in VB 2005?

 

[kulrom]

1st off, notice that SQL functions do not depend on the VB version but rather it depends on backend which is reffered by the query ... with other words NVL function will work just fine while you have ORACLE as backend. Means this function NVL will return "N/A" when DIFF is NULL. To be able to return "N/A" you must cast the value of DIFF to a string, otherwise NVL will fail. I guess you know that but i thought it may be worth to be said.

Regards