Try this:

LPARAMETERS cConnString As String ,cComando As String, lcParam As String 

	oConn 	 = CREATEOBJECT("ADODB.Connection")
	oComando = CREATEOBJECT("ADODB.Command")
	oRS 	 = CREATEOBJECT("ADODB.Recordset")

	oConn.Connectionstring = cConnString
	oConn.Open

	IF TYPE("lcParam")="U"
		lcParam=""
	ENDIF 

        *--- cComando = name of the desired procedure
        *--- lcParam = string with parameters

	oComando.CommandText= cComando+" "+lcParam
	oComando.ActiveConnection=oConn
	
	oRS = oComando.Execute()
	oConn = Null
	oComando = Null 
RETURN oRS

>Assuming we have the following SQL stored procedure:
>

>CREATE PROCEDURE usp_test
>	@Number	INT,
>	@NewNumber INT OUTPUT
>AS
>SET @NewNumber = @Number + 3
>RETURN @NewNumber
>GO
>

>
>In VFP we have valid ADODB.Connection object oConn and some variables. I want to use connection's Execute method:
>

>LOCAL lnIn AS Integer, lnOut AS Integer, lnReturn AS Integer
>lnIn=15
>oConn.Execute("What?")
>

>
>What would be the correct syntax for:
>a) getting procedure's return value?
>b) getting procedure's output parameter?
>
>Microsoft claims that it is possible to execute a stored procedure as a native method of a Connection object. Something like this:
>

>lnReturn = oConn.usp_test(lnIn, @lnOut)
>

>I has not been able to get it working. Has anyone?