Big Flat Stacks - NULLs

[Bob Sneidar]

I vaguely recall that HC was not supposed to have nulls, but some bug or other caused them and wrecked havoc with HC stacks. Compacting the stack seemed to eliminate them. 

Bob


On Jun 16, 2010, at 1:00 PM, Paul Looney wrote:

> Ben,
> I should have also mentioned that Rev does not like NULLs.
> This is important when importing from HC - which is very forgiving of NULLs.
> I use something like this:
> 
> replace NULL with "" in myData
> 
> or
> 
> replace NULL with empty in myData
> 
> If there are NULLs in you HC data, Rev may skip some of it while importing. Rev will also have trouble sorting columns of data if there are NULLs.
> Where do the NULLs come from? I don't know for sure but we have found one recipe: the user has copied some information from another program into an HC field; we noticed this especially when people had copied something from MS Word into the Notes fields in some of our HC programs.
> Sorry I didn't mention this earlier. We found out the hard way.
> Paul Looney