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..