>I have a SQL stored procedure that accepts one parameter and returns one record with one field. I use it from VFP and it works great. I need to call this procedure from another SQL procedure. How do you do this since I’m not using a return in the 1st procedure? Can you give me an example?

Mike,

It would be better to return that value in an output parameter. It's easy to retrieve in VFP and in another stored procedure. See Re: Can stored procedures return values? Message #876903 for sample code. Call from VFP can be simplified, if you don't need stored procedure return value.

lnResult = SQLEXEC(lnConn ,[EXEC Proc_test 1,2, ?@lcStr])