>Hi
>
>When creating a new record using an ADO Recordset via ODBC to a VFP DBC Table, it doesn't use the Default Value that I have in the Table properties.
>
>Is this normal? Do I have to enter the default value via ADO to achieve this?
>
>Thanks
>Kev

You can also implement those yourself by looking at the results of the OpenSchema method of the connection object. When you specify adSchemaColumns as the first parameter you will have this information on the COLUMN_HASDEFAULT and COLUMN_DEFAULT fields of the resulting recordset. HTH,