And I should have checked syntax before responding :)
oRS = oConn.Execute('StroredPProc(param)')
luValue = oRS.Fields(0).Value
Cetin
>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