Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Server Sp with OUTPUT parameter returns zilch
Message
 
 
To
20/06/2006 05:56:27
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01130183
Message ID:
01130191
Views:
12
You have to pass output parameters by reference
SQLExec(nsql,[Exec dbo.UpdateCreditorBatchNo 'D',?@MyVar],'Temp')
>
>MyVar = Space(36)
>SQLExec(nsql,[Exec dbo.UpdateCreditorBatchNo 'D',?MyVar Output],'Temp')
>
>
>The Sp executes just fine in QA and returns a GUID.
>
>It also executes with a return value of 1 in VFP, but returns zilch.
>
>So, what am I doing wrong?
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform