Excellent, thanks
Kev
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement