>I am trying to execute SP using this syntax:
>=SQLEXEC(lnHandle, 'spname'+' '+'parametername', 'mycursor')
>Does not seem to work.
>But if I do first DO spname WITH parametername and then sqlexec it's working. Can somebody tell me what's wrong?
>Thanks Mark
What do you mean by 'does not seem to work'? Is it running and not returning anything? If so, could be your parameters. Are you passing parameter values or names? You need to put '@parametername' to send SP the value.