I am trying to create a double field with no decimal precision. If I use the following syntax I get an error:

CREATE TABLE mytable (myfield B (8,0))

If I leave off the decimal it runs but creates a field with decimal 2.

CREATE TABLE mytable (myfield B)

How do I create a double field with 0 decimal? I am using VFP 7.0. TIA