Hi All- This is my first experience here so be kind...

I put in the command:

a_stored_procedure 0,detail .... and ....
a_second_sp

in the MS Access SQL Pass-through command and the stored procedures work fine.

I do the same thing in VFP..

SQLEXEC(gnConnHandle,'exec a_stored_procedure 0,detail') ...and...
SQLEXEC(gnConnHandle,'exec a_second_sp')

the second works perfectly in both Access and VFP. The former works only in Access. It seems like the parameters when passed in VFP are recognized differently then when passed from Access. I've tried quotes and a dozen other things but nothing seems to work.

Can anyone help me?

Erik