Hi Dorin

Nice to hear from you.

>This should work
>
>lnRetVal = SQLEXEC(lnCon, "EXECUTE PROCEDURE DelUStock(?liID)", "crs_result")
>lnSPRetVal1 = crs_result.SPRetVal1

I will try this and let you know how I fare.

>* or, this work for sure
>lnRetVal = SQLEXEC(lnCon, "select SPRetVal1 from DelUStock(?liID)", "crs_result")
>lnSPRetVal1 = crs_result.SPRetVal1
>

This SELECT ... FROM SP(), does it work? Maybe I messed it up with I had tried to do this from a Delete Trigger and I was not able to do anything till Helen on FB forum suggested I use EXECUTE PROCEDURE

Thanks for your response.