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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only