IEEE single precision programmertetsujinnooniNovember 14 2008, 13:46:46 UTC
(real programmers use patch panels to hotpatch running binaries, don'tcha know....)
for the case of Oracle behind Crystal:
nvl(Foo,0) will substitute 0 for Foo if Foo is null
MS SQL Server uses isnull(Foo,0) in the same fashion.
Oracle will treat a zero length string as null.
Hopefully those three items will help! Feel free to direct mail further questions, I'm looking at it from a DB engine perspective rather than the reporting tool obviously...
Comments 12
for the case of Oracle behind Crystal:
nvl(Foo,0) will substitute 0 for Foo if Foo is null
MS SQL Server uses isnull(Foo,0) in the same fashion.
Oracle will treat a zero length string as null.
Hopefully those three items will help! Feel free to direct mail further questions, I'm looking at it from a DB engine perspective rather than the reporting tool obviously...
Reply
Try the CR forums at tekteps.com!
Hope that helps!
Reply
Leave a comment