Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP/ADO/SQL stored procedure syntax
Message
From
06/10/2005 19:10:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/10/2005 14:31:07
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056781
Message ID:
01057009
Views:
69
>>Probably prototyping it in ADO would work and you would check with >NextResultSet. Also you might try:
>>{? = call storedProc(?,?,?)}
>
>Could you clarify this, please? How would call to this function look syntaxically?
>CREATE PROCEDURE usp_test
> @Number INT,
> @NewNumber INT OUTPUT
>AS
>SET @NewNumber = @Number + 3
>RETURN @NewNumber
>GO
>
>I just don't know where I'm supposed to put quotation and question marks, brackets, where variable names go etc.
>
>Thanks

First ? is the return value. ? in parentheses represents procedure parameters:

"{? = call usp_test(?,?)}"

I wonder why you want the return value with such a procedure. You already have it as an output parameter.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform