>Are there any pros or cons to my "old way" vs. my new plan to just use Integer fields everywhere?

(Corresponding) Integer fields are always smaller and have not even a remote chance of introducing a rounding error...

>Also, I know that Sql Server has other Int options too, like "Small Int" and "Tiny Int". Seems tempting, but we don't have that in VFP, and I really want to do all my schema changes in VFP as much as I can before I push it over.

Temptation should involve gains - if data size is really important or you need to deploy to hundreds of small devices.
You can emulate smaller integer types with c(n) utilizing asc() and chr() in vfp as well or you can use money for 8-byte integers. But only if there is a headache stemming from problems, not for kicks <g>.

regards

thomas