Are there any pros and cons using integer vs numeric?

[Peter]

I wonder whether I should define a field which will contain value from 0 - 9
as an integer or numeric(1). To save space, it makes sense to make it to be
numeric. Also, I wonder whether this issue still exists in VFP 8 SP1 and VFP
9: http://support.microsoft.com/default.aspx?scid=kb%3B[LN]%3B176884.

Thanks.

[Olaf Doschke]

Post by Peter
I wonder whether I should define a field which will contain value from 0 - 9
as an integer or numeric(1). To save space, it makes sense to make it to be
numeric. Also, I wonder whether this issue still exists in VFP 8 SP1 and VFP
9: http://support.microsoft.com/default.aspx?scid=kb%3B[LN]%3B176884.

Well, if you'd looked at the section "APPLIES TO", then you would have seen it
was an issue with versions up to VFP6, it's no problem with VFP8.

You may also simply test the code "Steps to Reproduce the behaviour".

Nevertheless you could use N(1), expecially if you expect the table to get very large.

Bye, Olaf.