Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning Error Message in Stored Procedure usin VFP OLE
Message
De
19/06/2004 05:20:21
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00915249
Message ID:
00915312
Vues:
10
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform