>In VFP, if I say INSERT INTO MyTable (RecordId) VALUES (10) I get
>a blank record with 1 field filled in. The remaining fields have
>a default value acording to the data type of the field.
>
>I have 56 fields in one table, I have to give all 56 fields a
>default value? This is not possible in ADO without filling in
>all fields???
>
>And I was just beginning to like ADO.

OK. The difference is you are going through the ODBC driver (or OLEDB provider) and the NULL behavior is different. Sorry.