>I have a feeling that this question must be asked 1000 times a week...
>
>but how do I raise an error from within a stored procedure successfully while calling that stored proc through the VFP OleDB provider?
>
>For example, my current stored proc in my VFP database says something to the effect of:
>
>Procedure MyProc
>
> ERROR "This is an error"
>
>EndProc
>
>
>From another application, I get a connection to that DB through the OleDB provider, execute the stored proc, and get "Feature not available."
>
>Isn't there a way to raise an error through the provider?
Shawn,
Check ComReturnError()
PS: Forget it, for a momemnt I thought you were asking about olepublic.
Cetin