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.

?