I should've tried that before responding, there doesn't seem to be an Execute method in a RS.

Kev

>>>>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
>>>
>>>Yes, but you could call stored proc from ADO.
>>>Cetin
>>
>>Um, could you advise me on how to do that?
>>
>>Thanks
>>Kev
>
>oRS.Execute("myStoredProc(param)")
>
>Cetin