>
>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')
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.