Hi All:

I've been able to execute a Stored Procedure in SQL SERVER 7.0 using the ADO Command Object passing 1 parameter via a COM (.exe) I wrote in VFP. It works great and it's SUPER fast.

Now I need to send THREE (3) parameters to the Stored Procedure and I'm not sure how this is done. I've tried this ...

I've tried this ....

DIMENSION aParameters[3]
aParameters[1] = lnFirstVar
aParameters[2] = lnSecondVar
aParameters[3] = lnThirdVar
oCommand.Execute(,@aParameters,)

... and it didn't work. What am I doing wrong here? Is it possible to send more than one parameter?

Thanks In Advance,

Mal