>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
This should work:
SQLEXEC(gnConnHandle,"execute a_stored_procedure 0,'detail'")
I guess that 'detail' is string constant. If not just let me know, I give you another line.
Edward Pikman
Independent Consultant