Announcement

Collapse
No announcement yet.

Stored Procedures

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedures

    Could I execute a Stored Procedure inside an event?

  • #2
    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

    Comment


    • #3
      Re: Stored Procedures

      Thank you

      Comment


      • #4
        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 ...

        Code:
        can't return a result set in the given context

        best regards,

        David

        Comment


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

          Thank you

          Comment

          Working...
          X