03 Ağustos 2005 Çarşamba 07:10Hi,
I have a problem selecting date-columns from a user defined function in MSSQL,
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 ?
03 Ağustos 2005 Çarşamba 13:08I would be interested in seeing the code! Is the code identicall between the 03 and 05 versions?
04 Ağustos 2005 Perşembe 08:54Hi 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.