Numb3rs

Can you tell the difference between these two numbers: 74714853002 and 120135369424?

Hint, the answer is not -45420516422. The second number is actually bigger than the first number.

The right answer is that first number is an integer datatype, but the second number is a big integer datatype. Try to cast or assign the second number as an integer and bad things will happen.

This was confounding the invoicing feature in the software program that I wrote for a long time.

Finally, only after a user took the time to explain the steps to reproduce the error was I was able to fix it. Heaps of praise for active users!

It's very different building a real world app than it is building a prototype or an even an intra/extranet app.