![]() This is a problem because throughout other reporting practices, Nulls wreak havoc! The most common example of this havoc is if you concatenate several strings of text (essentially gluing pieces of text together into one long text), a single Null in any part of the concatenation will make the whole result Null. In fact, Nulls are not equal to any value. ![]() The tricky part is that Nulls are not equal to zero. Nulls are the absence of data – as if someone skipped that cell in the database. For this reason, we spend much of our time trying to cosmetically “fix” the data just enough so our report can run properly. ![]() As report writers, we often do not have the ability to change the data on the database directly we merely have to work with the data we’ve got. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |