Stored Procedures

Could I execute a Stored Procedure inside an event?

Re: Stored Procedures

You can use the sc_lookup or sc_exec_sql to call a procedure.

example:
sc_exec_sql(“exec myProc”);

V?tor Jamil

Re: Stored Procedures

Thank you

Re: Stored Procedures

Did that solution even work?

Execute wouldn’t allow an output though if it does, but when I try using this syntax with Exec in there, it gives me a syntax error…

I just get the same error as I do using sc_lookup …

can't return a result set in the given context

best regards,

David

Hi
Could I execute a Stored Procedure with parametres inside an event?

Thank you