Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling a SQL stored Procedure doesn't return values
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00494591
Message ID:
00494624
Views:
24
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform