>>>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.
What's the problem? Anyway, the parameter in SP should be marked as output.
CREATE PROCEDURE sp_name @par1 varchar(200) OUTPUT
AS
...
SET @par1 = "My Return String"
...
--sb--