Yes, thank's guys. By chance I also discovered
myvar = NULL
? SQLExec(nsql,[Exec dbo.UpdateCreditorBatchNo 'D',?@Myvar])
? myvar
>>
>>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)