Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Server Sp with OUTPUT parameter returns zilch
Message
From
20/06/2006 06:53:36
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01130183
Message ID:
01130199
Views:
17
Yes, thank's guys. By chance I also discovered
myvar = NULL
? SQLExec(nsql,[Exec dbo.UpdateCreditorBatchNo 'D',?@Myvar])
? myvar    && Now stores the GUID 
>>
>>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?
>>
>>TIA & BR
>
>You must pass it by reference
>
>MyVar = Space(36)
>SQLExec(nsql,[Exec dbo.UpdateCreditorBatchNo 'D',?@MyVar Output],'Temp')
>
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Reply
Map
View

Click here to load this message in the networking platform