>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao