Weird IsDbNull issue with MSSQL/ADO.NET

Question

Hi,

I have a problem selecting date-columns from a user defined function in MSSQL,
in short:
When I do a SELECT on a table, my datareader returns the correct date (IsDbNull returns false).
When I wrap the above table in a userdefined function, my datareader returns NULL (IsDbNull returns true).
When I wrap the above function in a view, my datareader returns the correct date again (IsDbNull returns false).

The error occured after I upgraded to VS 2005 Beta 2 (.NET v. 2), everything works fine in VS 2003 (.NET v. 1.1).
Has anyone else observed this ?

 

Answer 1

I would be interested in seeing the code!  Is the code identicall between the 03 and 05 versions?

Answer 2

Hi again,

Me bad ... after some more investigation, it seems that i was a little to quick on the keyboard ...

The problem was a parameter that wasent initialized correctly, sorry.