>I have a table with an int column and a default value set to zero.
>Table is in a DBC.
>
>I do SQL-Insert on the table and never mention the int column. But if I SQL-Select "select * from mytable where intcol=0" I get no results. Manually entering a zero in the column gets the rows returned, but it's like VFP is ignoring the default value. The table column has a regular index on it, accepts NULLs and just has 0 as a default value.
>
> ?

I can't reproduce this (returns all with no value entered).
Cetin