SQL Toolkit - Getting output from stored procedure

[CVI@Boeing]

I am unable to get an output or return value from a stored procedure in SQL Server 2000 using LW/CVI 6.0.
I looked at all the examples. The KB and forums had users with similar problems with LabView but I have not seen any posts using LW/CVI. Input parameters work OK, it's just trying to retrieve an output. I am using DBCreateParamxxxx instead of DBRefreshParams because input parameters didn't seem to work with the latter function.

[Scott Y]

Hello,

Please try the attached example. If you still have the same issues please feel free to post again to let us know.

Scott Y
NI

[CVI@Boeing]

Scott,
Thanks for the info. It helped greatly and I can now read outputs from my stored procedure!
It turns out the problem was with my stored procedure. The examples I saw from Microsoft used either the SET or SELECT to set the output variable but not both together. Using the SET then the SELECT statements worked.

Very grateful,
Art