<< As usual I'm probably missing something very simple here, but I've had some trouble running procedures one after another due to the STP_RETURN variable. >>
Duey: I use stored procedures a lot and do not observe the problem you're reporting. I can run two stored procedures, one after the other, returning different types and I receive correctly typed return values each time. For instance, if I run an integer-returning stored procedure my variable is set to an integer, and I can see STP_RETURN is an integer value. If I immediately run a text-returning stored procedure my variable (a different one, of course) is set to text, and I can see that R:Base has recreated STP_RETURN as a text variable. This is in 7.6, but I've been using SPs almost since they were added to R:Base and have never seen this problem. -- Larry
