Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql Server Sp with OUTPUT parameter returns zilch
Message
De
20/06/2006 06:53:36
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01130183
Message ID:
01130199
Vues:
18
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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform