No problem.. Glad I could be of assistance in finding a solution that worked for you..


>For others the final solution is a new class method taht looks like:
>
>this way I don't need to worry about making parameters...
>
>
>

>	**Execute a stored Proc maybe return parameters
>	**Accepts a 1 D array with all parameters list in order. (Maybe returns Output Parameter..)
>	**Example:
>		** DIMENSION laParams[2]
>		** laParams[1]='0000046'
>		** laParams[2]=1
>		** lOutPutValue=SP_EXEC("GetStatus",@laParams)
>	PROCEDURE SP_EXEC(lcSpname,laParams)
>	LOCAL xReturn
>		
>		WITH THIS.oCommand
>			.ActiveConnection =  oConnection
>			.commandtext = "GetStatus"
>			.CommandType = ADCMDSTOREDPROC
>			.parameters.refresh
>			FOR i=1 to ALEN(laParams,1)
>				.parameters(i).value=laParams[i]
>			ENDFOR
>			.Execute
>			xReturn=IIF(TYPE(".parameters(0)")="O",.parameters(0).value,.F.)
>		ENDWITH
>		
>		RETURN xReturn
>	ENDPROC
>
>

>
>Thanks for the lead John..