>>I have a store procedure that needs to return a character string. I have the string store in a local variable on SQL and I am running the stored procedure via SQLEXECUTE.
>>
>>What are my return options from SQL? Is there a way to catch a Print output from a Stored Procedure?
>>
>>Thank you in advance.
>
>You can return cursor with one field or you can use output parameter
lcRetVal = ""
>= SQLExec(lnHandle,"EXEC sp_name ?@lcRetVal")
I'm sorry, that didn't help. I must be missing something.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.