Ok, got it.

CREATE TABLE mytable (myfield B(0))

works.


>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