Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling a SQL stored Procedure doesn't return values
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00494591
Message ID:
00494624
Vues:
26
>All parameters are strings, except the six parameter that is a SQL date then I use TTOC(datetime()) and the reference parameter paraoutput2 that also uis a SQL date type , then I used datetime() to set this parameter before to be called.
>The parameter paraoutput1 is supposed to return a code if some parameter is wrong or if the transaction is ok, but I'm receibing strange characters and some times I receive a Substring of the lcstring (sql string statement)

It looks like everything is okay. Can you use Query Analyzer (SQL Server) or SQLPlus (Oracle) to send your query outside of the VFP environment? Does it work with these? Othan than that, I'm sorry I couldn't help.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform